for 2nd time already
my mysql works fine! i am being able to do everything that i need i can
logon as a root i can logon as vpopmail user and i dont use redhat! and
rpms!
this is *NOT* an issue with mysql.. this is an issue with some permitions
that's all
----- Original Message -----
From: "Ole Gjerde" <[EMAIL PROTECTED]>
To: "Alex Kramarov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 24, 2001 5:38 AM
Subject: Re: vsql_getpw: failed select
> This is definately no longer the case with 7.x (I don't have 6.x to check
to
> see if it ever was like that)
>
> [ole@radius2 ole]$ mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1973 to server version: 3.23.37-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
>
> mysql> exit
> Bye
> [ole@radius2 ole]$ ls -ld /var/lib/mysql
> drwxr-xr-x 11 mysql mysql 4096 Jun 24 04:02 /var/lib/mysql
>
> If you want to upgrade to a newer version of mysql, simply get the rpm
from
> rawhide (you'll want to compile it yourself using rpm --rebuild
> mysql-blahblah.src.rpm)
> ftp://ftp.valinux.com/pub/mirrors/redhat/redhat/linux/rawhide/SRPMS/SRPMS/
>
> HTH,
> Ole Gjerde
>
> ----- Original Message -----
> > Alex Kramarov wrote:
> > >
> > > I actually ran into this myself, and you probaly have the same
problem.
> try
> > > logging into mysql with non-root user and with default RedHat
> installation
> > > (that is what I am using) you will fail. mysql connectivity from the
app
> to
> > > the database is done through unix sockets
> > >
> > > /var/lib/mysql/mysql.sock
> > >
> > > the default permissions for the /var/lib/mysql directory are for the
> mysql
> > > user only, and of course root can access it, but vpopmail user cannot.
I
> > > just gave the directory world readable permissions, this did the
trick.
> i am
> > > wondering if there is another way to do this ? i actually didn't see
> > > anything about this issue in the first 5 pages of the mailing list
> archive .
>
>
>
