Hi,
In order for MySQL to work correctly, all you should need is everything
in /var/lib/mysql owned by user 'mysql' (with group 'mysql' for good
luck) and set to rwx------.
I'm not sure about the usefulness of these pre-built skels - the whole
idea was that they made things easier but they seem to create more
problems than they solve - I recommend people stick to 'rolling their
own' ;-) until they're a bit more reliable.
Hope this helps,
--
Ben Kennish
e: [EMAIL PROTECTED]
w: www.fubra.com
Marcos Rubinstein ALPA WWW wrote:
>
> Thanks Gary... it works :)
>
> re the permissions... the only thing that I needed to do was to chmod a+x
> /var/lib/mysql. Do not know if that in itself could pose a security
> problem! (wandering why mysql creates the dir with only user rwx all
> others zip)...
>
> Thanks
> Marcos
>
> On Sun, 20 May 2001, cars sold wrote:
>
> > Hi
> >
> > just to follow up on this - the fix we implemented to get over this is as
> > follows:
> >
> > 1) get a php.ini file into the vs /etc directory
> >
> > 2) in /etc/php.ini - add an extension_dir= path as follows:
> >
> > extension_dir= /usr/lib/php4
> >
> > 3) in /etc/php.ini - add a line to load the mysql.so dynamically
> >
> > extension= mysql.so
> >
> > then we had a permission problem on mysql.sock - although the mysql.sock was
> > writable the directory was not so we had to chmod 777 /var/lib/mysql
> >
> > not sure on the security implications or warrantble nature of any of this
> > but phpMyAdmin is up and running...but we are working in the dark and it's
> > not production so....
> >
> > Gary
> >
> > ----- Original Message -----
> > From: "Urivan Saaib" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, May 20, 2001 4:01 AM
> > Subject: emmhh..yet another PHP/MySQL question.. :)
> >
> >
> > > Hi all,
> > >
> > > Well i downloaded the php-mysql prebuilt skel, then i copied all files
> > > related to php and mysql into a new virtual server :
> > >
> > > cd /tmp; bunzip2 fvsd-skel.tar.gz | tar xvf -
> > > updatedb
> > > for i in `locate mysql php | grep \/tmp\/skel |
> > > perl -pi.bak -e `s/\/tmp\/skel\///'`
> > > do; tar -dvf /tmp/php-mysql-stuff.tar.gz $i; done
> > >
> > > copied libphp3.so as well just to do some tests...
> > >
> > > Configured apache first with php3, and everything worked, but when
> > > commented the php3 lines in httpd.conf and uncommented the php4 and
> > > restarted, well the php4 files yes, they are parsed, but i cannot make
> > > mysql connections due to the following :
> > >
> > > "Call to undefined function: mysql_connect()"
> > >
> > > Is there any extra missing file needed for libphp4 that i'm missing ?
> > >
> > > Regards,
> > > _______________________________________________________
> > > Urivan Saaib
> > > Presidente
> > > CiberNET Mexico
> > > Email: [EMAIL PROTECTED]
> > >
> > >
> >
