Is this problem solved ?
> su-2.05# ./vuserinfo [EMAIL PROTECTED]
> vsql_getpw: failed select
Sorry to all if it's already solved. I found someone make patch
to the vmysql.c, but I think the problem is not in vmysql.c, since
another binaries like vadddomain, vadduser, vsetuserquota,
and vpasswd is working fine.
I found something interesting when I look at "vuserinfo.c" source.
Look at function "main".
> get_options(argc,argv);
> if (Domain[0] == 0 ) {
> parse_email( Email, User, Domain, MAX_BUFF);
> if ( (mypw = vauth_getpw( User, Domain )) == NULL ) {
...
> }
> display_user(mypw);
> vclose();
> } else {
> first = 1;
> while( (mypw=vauth_getall(Domain, first, 0))){
> first = 0;
> display_user(mypw);
> }
> vclose();
> }
Are you sure it is "if (Domain[0] != 0)" ?
>From function "get_option", if there is "-D" parameter,
then variable "Domain" is filled with the value following
"-D" parameter. "Domain[0]" is not zero if there is value
in variable "Domain". So if we do "./vuserinfo user@domain",
it will always run the bottom part, not the upper part that
has function to split the email address into user and domain.
I change it to "Domain[0] == 0", and vuserinfo seems normal.
"./vuserinfo user@domain" is ok, but "./vuserinfo user" cause
segmentation fault. I think the segmentation fault problem is
in parse_email function.
Best Regards,
Adrian Purnama
PS: Sorry for my bad English... :P
----- Original Message -----
From: "Ken Jones" <[EMAIL PROTECTED]>
To: "Alex Kramarov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, June 23, 2001 7:30 PM
Subject: Re: vsql_getpw: failed select
> The other way to do this on RedHat is to remove the
> mysql installation
>
> rpm -qa | grep SQL
> rpm -e <each package one by one>
>
> Then download the latest mysql rpms from www.mysql.com
> Then install them.
>
> The latest rpms from mysql.com do not have the problem
> you are describing. Cool huh?
>
> Ken Jones
>
> 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 .
> > .
> >
> > -------Original Message-------
> >
> > From: alexus
> >
> > Date: ��� ���� 22 ���� 2001 20:37:10
> >
> > To: [EMAIL PROTECTED]
> >
> > Subject: vsql_getpw: failed select
> >
> > even though i can check this user's e-mail for some unknown reason
whenever
> >
> > i do vuserinfo on this user i get this error
> >
> > su-2.05# ./vuserinfo [EMAIL PROTECTED]
> >
> > vsql_getpw: failed select
> >
> > su-2.05#
> >
> > could someone explain this to me?
> >
> > thank you in advance
>
