I have the same problem. (I run Redhat 6.2)
I think I will have to agree that this is not a mysql permissions problem,
every other vpopmail command works fine. Just not vuserinfo.
Any other ideas Ken/folks?
---
[root@xenon /root]# vuserinfo [EMAIL PROTECTED]
vsql_getpw: failed select
---
I built mysql 3.23 from source.
I have vpopmail 4.9.10
[root@xenon /root]# mysql -V
mysql Ver 11.12 Distrib 3.23.32, for pc-linux-gnu (i686)
[root@xenon /root]# vuserinfo -v
version: 4.9.10
mySQL permissions are as follows
[root@xenon /root]# ls -l /var/db/
drwxr-xr-x 17 mysql mysql 1024 Jun 20 14:03 mysql
--
Regards,
Kieran Barnes
Signum 1226 Ltd
Visit our website at http://www.1226.net
Phone: 01772 622889 || Fax: 01772 622558
> -----Original Message-----
> From: alexus [mailto:[EMAIL PROTECTED]]
> Sent: 24 June 2001 16:23
> To: Ole Gjerde; Alex Kramarov
> Cc: [EMAIL PROTECTED]
> Subject: Re: vsql_getpw: failed select
>
>
> 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 .
> >
> >
> >
>
