Here is what I hope will work for you. You'll want to take a close look at the config.php.sample file, especially the section entitled "Multiple database field setup". Make sure to set $split_username_query = 1 and $split_username_domain_field = 'pw_domain';
Let me know if it works! Cheers, paul > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:akindele@;webox.net] > Sent: Wednesday, November 13, 2002 12:57 PM > To: [EMAIL PROTECTED] > Subject: RE: [SM-USERS] change_mysqlpass issue > > >> That is correct the vpopmail db is in mysql and the same db i am using > > for > >> the changemysql normally i type in [EMAIL PROTECTED] > > > > Wait, from your previous mails, I understood that your username was just > > "user". In fact, you were logging in (without vlogin) by typing the > > whole "[EMAIL PROTECTED]"? If that is the case, then the output from the > > last options.php that I sent are correct, at least from SM's > > perspective. > > > >> i just added the vlogin plugin and can log in with user > >> in the vpopmail table in mysql the username field is pw_name and users > > are > >> stored as user > > > > The *username* field is called pw_name???? > > The users are stored without the domain name??? Then how is it that > > (before vlogin) you had to type in "[EMAIL PROTECTED]"?? Where does the > > mapping between "user" and "[EMAIL PROTECTED]" take place? > > > > The change password plugin assumes that the username you used to log in > > is (sensibly) the id it needs to look up in MySQL to find and change the > > password. Is this not correct? > > > > Perhaps send a sample (like one row) of your database table and the > > corresponding login you'd use to log in with that user. > > > -------------------------------------+----------+-----------------+ > | pw_name | pw_domain | pw_passwd | > pw_uid | pw_gid | pw_gecos | pw_dir > | pw_shell | pw_clear_passwd | > +----------------+------------------+---------------------------------+- -- > -----+--------+-----------------+--------------------------------------- -- > --------------+----------+-----------------+ > | user | domain.com | $1$MZSnZ$OVC6RDU8g0WtroHfQJHOf1 | 0 > | 0 | user | /home/vpopmail/domains/domain.com/user | > NOQUOTA | test | > > > [EMAIL PROTECTED] is the login name without vlogin > with vlogin i can use user > as you can see the user field is pw_name and only has user in it > the second options.php showed the main problem it was using > [EMAIL PROTECTED] as the user name when the table shows user, i have not > added any pluggin except vlogin > Thanks > akin:) > > > > - paul >
change_mysqlpass.2.1-1.2.8.tar.gz
Description: Binary data
