Re: Using mysql support with php4-cgi.

2003-01-22 Thread fred
Hi Alex,

Thanks very much for your answer, it now works as expected.

Regards, Fred.

Alexander Seidel wrote:

On Tue, Jan 21, 2003 at 05:30:01PM +, fred wrote:


I am trying to use php4-cgi to run some php scripts from cron. The 
problem is that php4-cgi is not built with mysql support, to find that 
out I did :

/usr/lib/cgi-bin/php4 -i


There are different php.ini for PHP4 as module and as CGI.

You need to install php4-mysql and to activate mysql support in
/etc/php4/cgi/php.ini.

Regards

Alex.





--
Fred Clausen - Systems Administrator
Unique Interactive, part of UBC Media Group plc
Winners of the 2002 CRCA NTL New Media Award

http://www.ubcmedia.com
http://www.uniqueinteractive.co.uk
T: +44 (0)20 7453 1667 F: +44 (0)20 7486 5081


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: swapon not run at boot with raid drives

2003-01-22 Thread I. Forbes
Hello Russell 

On 21 Jan 2003 at 11:30, Russell Coker wrote:

> There was a bug in 2.2.x kernels which could cause a kernel panic if you 
> swaped on a RAID device that was re-syncing.  AFAIK 2.4.x had it fixed long 
> ago.  So if you are running a 2.4.x kernel you can just edit the shell script 
> in question to remove that check.

> Why not put "swapon -a" in a cron job?

I have done this, protected by an if statement to check if the drives 
are busy syncing, it should work, but it is a bit clumsy. It would be 
neater to have something which waited until the syncing was finished 
and then mounted the swop partitions.

If my swop partitions are not on raid devices, am I vulnerable to the 
above bug? (Not that I really want to test this on production 
machines).

Thanks

Ian

-
Ian Forbes ZSD
http://www.zsd.co.za
Office: +27 21 683-1388  Fax: +27 21 674-1106
Snail Mail: P.O. Box 46827, Glosderry, 7702, South Africa
-



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: swapon not run at boot with raid drives

2003-01-22 Thread Russell Coker
On Wed, 22 Jan 2003 11:08, I. Forbes wrote:
> If my swop partitions are not on raid devices, am I vulnerable to the
> above bug? (Not that I really want to test this on production
> machines).

No.  It only applies if the swap is on a RAID partition that is re-syncing.

-- 
http://www.coker.com.au/selinux/   My NSA Security Enhanced Linux packages
http://www.coker.com.au/bonnie++/  Bonnie++ hard drive benchmark
http://www.coker.com.au/postal/Postal SMTP/POP benchmark
http://www.coker.com.au/~russell/  My home page


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: MTU Issues

2003-01-22 Thread Miernik
On Tue, Jan 21, 2003 at 03:06:52PM -0800, Jeremy C. Reed wrote:
> (Is anyone interested in helping write an article comparing Debian with
> NetBSD? Please let me know off-list.)

I see some confusion here: didn't you mean "comaring Debian GNU/Linux
with Debian GNU/NetBSD"?

Please take a look at the bottom of this page:

http://www.debian.org/ports/

-- 
Miernik  
___ ICQ: 4004001 ___/___ tel.: +48608233394 ___/  mailto:[EMAIL PROTECTED]
No Iraq war! http://www.globalexchange.org/campaigns/iraq/invadeIraq082702.html
Please call the White House +1-202-456- or fax +1-202-456-2461 and say no!



msg07857/pgp0.pgp
Description: PGP signature


100% Debian based Cyber-Center in Strasbourg

2003-01-22 Thread Michelle Konzack
Hello, 

Curently I am in creation of my Cyber-Center in Strasbourg, 
which is origialy only for Internet and Office... 

But now I am interested in Net-Games... 

Not only some Game-Servers. I like to use Linux-Game too. 
Are there some like 'Counterstrike'... 

I like to install my own Game-Server on a Athlon 1400 with 
512 MByte which must server up to (very rar) 30 Clients in 
the local 100 MBit LAN. 

Oh yes, I have found only Action-Net-Games for WinSuck 
(Server maybe on Linux) but no Linux-Clients...

Are the Games only in english or are ther some in german 
and french (very important for the French-users :-P ) ? 

Thanks for any informations... 
Michelle



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




RE: 100% Debian based Cyber-Center in Strasbourg

2003-01-22 Thread Andre Frimberger


> -Original Message-
> From: Michelle Konzack [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, January 22, 2003 4:36 AM
> To: [EMAIL PROTECTED]
> Subject: 100% Debian based Cyber-Center in Strasbourg
> 
> 
> Hello, 
> 
> Curently I am in creation of my Cyber-Center in Strasbourg, 
> which is origialy only for Internet and Office... 
> 
> But now I am interested in Net-Games... 
> 
> Not only some Game-Servers. I like to use Linux-Game too. 
> Are there some like 'Counterstrike'... 
> 
> I like to install my own Game-Server on a Athlon 1400 with 
> 512 MByte which must server up to (very rar) 30 Clients in 
> the local 100 MBit LAN. 
> 
> Oh yes, I have found only Action-Net-Games for WinSuck 
> (Server maybe on Linux) but no Linux-Clients...
> 
> Are the Games only in english or are ther some in german 
> and french (very important for the French-users :-P ) ? 
how about quake ? :)
runs also under linux ;)



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: Network Diagrams

2003-01-22 Thread Cameron Moore
* [EMAIL PROTECTED] (Wayne Tucker) [2003.01.21 20:01]:
> Does anybody have any recommendations for a good network diagraming
> program?  I'm starting to get used to Dia, but I'm just wondering if
> there are any others out there that I haven't come across.

AFAIK, the only other Visio-style program is Kivio.  But the stensils
cost money -- I've personally used it because of that.
  http://www.thekompany.com/projects/kivio/

As for network mapping tools, Scotty/tkined looks pretty cool, but I've
yet to test it out.
  http://wwwhome.cs.utwente.nl/~schoenw/scotty/

If you work in a Micros~1 shot, I've heard that Visio 2000 will work
with the crossover wine package.

I've wished for years now that someone would pick up Dia and start
working on fixing it up.  :-(

Let me know if you find anything else.  I've been looking for a Visio
replacement for years.
-- 
Cameron Moore
[ Why is the word dictionary in the dictionary? ]


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: MTU Issues

2003-01-22 Thread Jeremy C. Reed
On Wed, 22 Jan 2003, Miernik wrote:

> On Tue, Jan 21, 2003 at 03:06:52PM -0800, Jeremy C. Reed wrote:
> > (Is anyone interested in helping write an article comparing Debian with
> > NetBSD? Please let me know off-list.)
> 
> I see some confusion here: didn't you mean "comaring Debian GNU/Linux
> with Debian GNU/NetBSD"?

No. I am talking about comparing Debian GNU/Linux with "real" NetBSD.

(But is someone wants to write an article about that comparing Debian with
Debian, please let me know.)

> Please take a look at the bottom of this page:
> 
> http://www.debian.org/ports/

I already know; please see my articles[1]:
 http://www.bsdtoday.com/2001/July/Editorial527.html
 http://www.bsdtoday.com/2002/January/News625.html

  Jeremy C. Reed
echo 'G014AE824B0-07CC?/JJFFFI?D64CB>D=3C427=>;>6HI2>


Re: odbc_pconnect()

2003-01-22 Thread Bernie Berg
David H. Clymer wrote:


perhaps you have to load the odbc module in the /etc/php4/apache/php.ini



Thanks david, you were absolutly correct.  I had to add odbc.so do the 
bottom of the file.  Of course this leads me to a new error on my php page:

Warning: SQL error: [unixODBC]tds_connect failed, SQL state 08001 in 
SQLConnect in /var/www/www.website.com/homesearch.php on line 49

#Here is line 49 in my php page:

$cx=odbc_pconnect("circa","myusername","mypassword");

#Here is my odbc.ini, note the non standard port:

[ODBC Data Sources]
circa=CA EDBC  ;(note that format is dsnname=drivername)

[circa]
Driver=/usr/lib/odbc/libtdsodbc.so
Decription = MS-SQL
Trace = 1
Servername=192.168.0.100
Database = mydatabase
UID = myusername
PORT = 1511
TraceFile = mssql.log
ServerType=MSSQL

#And here is my odbcinst.ini:

[ODBC Drivers]
CA EDBC=Installed

[circa]
Driver=/usr/lib/odbc/libtdsodbc.so
DontDLClose=1


I know that there are some errors in ther... And while I know it doesn't 
directly relate with exacly what I am working on I've been folowing the 
instruction on this page as well as I can, but with no success:

http://support.cai.com/techbases/ingres/4327.html

any ideas?
thanks for your time.

--
Bernie Berg|  [EMAIL PROTECTED]
Network Administrator  |  Office:(605)362-6361
Circa Design Company   |  Cell:(605)359-2237


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]



Limit MySQL database sizes

2003-01-22 Thread Jason Lim
Hi all,

How can a "quota" be put on MySQL sizes? That is... in a similar fashion
to the "commercial" control panels like Cpanel and such?

Normal filesystem quotas don't work, since the database is owned by user
"MySQL" and not the user him/herself.

Right now we're using a custom script that just reports any values over a
certain amount, and the possibility to "trim" very large ones, but it
would be much better if something like a proper quota could be put on (eg.
30Mb).

Any ideas?

Thanks in advance.

Jas.


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: Limit MySQL database sizes

2003-01-22 Thread Jason Lim
> > Normal filesystem quotas don't work, since the database is owned by
user
> > "MySQL" and not the user him/herself.
>
> You can chown the data files and make sure they're group-writable.

Could you expand on that a bit? You mean make it owned by the user, and
group writable by MySQL?

> > Right now we're using a custom script that just reports any values
over a
> > certain amount, and the possibility to "trim" very large ones, but it
> > would be much better if something like a proper quota could be put on
(eg.
> > 30Mb).
> >
> > Any ideas?
>
> There is no build-in mechanism yet.

Mmm... then how on earth are those "Cpanels" and others doing it?


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: Limit MySQL database sizes

2003-01-22 Thread Jeremy Zawodny
On Thu, Jan 23, 2003 at 06:02:21AM +0800, Jason Lim wrote:
> Hi all,
> 
> How can a "quota" be put on MySQL sizes? That is... in a similar fashion
> to the "commercial" control panels like Cpanel and such?
> 
> Normal filesystem quotas don't work, since the database is owned by user
> "MySQL" and not the user him/herself.

You can chown the data files and make sure they're group-writable.

> Right now we're using a custom script that just reports any values over a
> certain amount, and the possibility to "trim" very large ones, but it
> would be much better if something like a proper quota could be put on (eg.
> 30Mb).
> 
> Any ideas?

There is no build-in mechanism yet.
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: Limit MySQL database sizes

2003-01-22 Thread Jeremy Zawodny
On Thu, Jan 23, 2003 at 06:50:30AM +0800, Jason Lim wrote:
> > > Normal filesystem quotas don't work, since the database is owned by
> user
> > > "MySQL" and not the user him/herself.
> >
> > You can chown the data files and make sure they're group-writable.
> 
> Could you expand on that a bit? You mean make it owned by the user, and
> group writable by MySQL?

Exactly.

> > > Right now we're using a custom script that just reports any values
> over a
> > > certain amount, and the possibility to "trim" very large ones, but it
> > > would be much better if something like a proper quota could be put on
> (eg.
> > > 30Mb).
> > >
> > > Any ideas?
> >
> > There is no build-in mechanism yet.
> 
> Mmm... then how on earth are those "Cpanels" and others doing it?

Never seen one, so I'm not sure.

I've been toying with the idea of writing a simple mysqlquotad that
would monitor space and revoke users's INSERT privileges until they
pruned their tables (after sufficient notificaiton, of course).

Wouldn't be too hard to do, I just haven't found the time yet...

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: Network Diagrams

2003-01-22 Thread Charl Matthee
On Wed Jan 22 2003 at 10:41:50AM -0600 'Cameron Moore' <[EMAIL PROTECTED]> wrote:

> If you work in a Micros~1 shot, I've heard that Visio 2000 will work
> with the crossover wine package.

We need to share diagrams with a lot of people on win32 (they all seem to use 
Visio) so we opted to go the CrossOver Office + Visio 2000 route. It really 
works well and is recommended if you don't mind paying the relevant license 
fees.

See [http://www.codeweavers.com/products/office/].


Ciao

Charl
__ 

[  Charl Matthee  ]   [ +27-11-721-3800 ]   
[ Systems Manager ]   [ +27-11-405-6508 ]   
__


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]