[Serusers] Password problem with ser and mysql

[Jan Janak]

Hello,

auth is not the only module that uses database. If you have enabled
support for database in usrloc (by modparam("usrloc", "db_mode", 1) or
modparam("usrloc", "db_mode", 2) then you have to change usrloc's password
as well.
Try to use the following:
modparam("usrloc", "db_url", "sql://ser:klaus@localhost/ser")

  regards, Jan.cd 

On 17-01 11:56, Klaus Darilion wrote:
> Hello Jan!
> 
> Comments inline.
> > default username and password for auth module is 
> > serro:47serro11, if you are able to login as ser:heslo, then 
> > username and password can be changed.
>  
> > If you change your password in mysql, you must change it for 
> > ser at localhost For example: grant ALL on ser.* to 
> > ser at localhost identified by 'klaus';
> 
> I changed it for localhost, but it won't work.
> 
> > If you use something like grant ALL on ser.* to ser 
> > identified by 'klaus'; then the server will be unable to 
> > login to the database.
> > 
> > Try also the following:
> > mysql -h localhost -u ser -p ser
> 
> I changed the password of ser at localhost to 'klaus'. I can connect to
> mysql with
> mysql -h localhost -u ser -p ser
> and password 'klaus'. I changed the password in ser.cfg to 'klaus'
>   modparam("auth", "db_url", "sql://ser:klaus@localhost/ser")
> , but still the ser server can't start:
>   : connect_db(): Access denied for user: 'ser at localhost' (Using
> password: YES)
> 
> 
> I still think there must be a bug somewhere, so that ser tries to
> connect with the 'heslo' password.
> 
> regards,
> Klaus
> 
> > This will prompt for password, if you are unable to login 
> > with your password, ser will be unable to login as well 
> > (probably because you changed password for ser and not for 
> > ser at localhost)
> > 
> >   regards, Jan.
> > 
> > On 16-01 18:34, Klaus Darilion wrote:
> > > Hello!
> > > 
> > > I have sucessfully installed the ser server (0.8.10 from 
> > rpms) with an 
> > > mysql database. When I use the standard password for the user "ser" 
> > > everything works fine. But if I change the password from 
> > "heslo" to a 
> > > new one, for example "klaus" instead of "heslo" (of course in the 
> > > mysql-database und in the config file) the ser server can not start 
> > > up.
> > > 
> > > Following are some different configurations and my suggestions what 
> > > could be the problem.
> > > 
> > > ser.cfg: modparam("auth", "db_url", "sql://ser:heslo@localhost/ser")
> > > mySQL-root-password: XXXXX
> > > mySQL-ser-password: heslo
> > > ---> works fine
> > > 
> > > ser.cfg: modparam("auth", "db_url", "sql://ser:klaus@localhost/ser")
> > > mySQL-root-password: XXXXX
> > > mySQL-ser-password: klaus
> > > ---> doesn't work: connect_db(): Access denied for user: 
> > > ---> 'ser at localhost'
> > > (Using password: YES)
> > > should work, so I tried another user
> > > 
> > > ser.cfg: modparam("auth", "db_url", 
> > "sql://root:XXXXX@localhost/ser")
> > > mySQL-root-password: XXXXX
> > > mySQL-ser-password: heslo
> > > ---> works fine
> > > 
> > > ser.cfg: modparam("auth", "db_url", 
> > "sql://root:XXXXX@localhost/ser")
> > > mySQL-root-password: XXXXX
> > > mySQL-ser-password: klaus
> > > ---> doesn't work: connect_db(): Access denied for user: 
> > > ---> 'ser at localhost'
> > > (Using password: YES)
> > > very strange, because I told ser to connect as root. Is ser 
> > using the 
> > > default user/password instead of the configured one?
> > > 
> > > ser.cfg: modparam("auth", "db_url", 
> > "sql://root:YYYYY@localhost/ser")
> > > mySQL-root-password: XXXXX
> > > mySQL-ser-password: heslo
> > > ---> doesn't work: connect_db(): Access denied for user:
> > > 'root at localhost' (Using password: YES)
> > > of course it doesn't work, wrong password. So ser cares about the
> > > settings in ser.cfg
> > > 
> > > So my suggestion is that ser connects several times to the database 
> > > whereas one time it uses the configured user/password and 
> > another time 
> > > it uses the default user/password - maybe a bug in the auth module?
> > > 
> > > Or does somebody of you changed the password successfuly?
> > > 
> > > It would be nice if you can help me.
> > > 
> > > Thanks,
> > > Klaus
> > > 
> > > My system is:
> > > Linux version 2.4.18-14 (bhcompile at astest.test.redhat.com) 
> > (gcc version
> > > 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) #1 Wed Sep 4 
> > 12:13:11 EDT 2002
> > > MySQL 3.23.52
> > > ser-0.8.10-2.i386.rpm
> > > ser-mysql-0.8.10-2.i386.rpm
> > > _______________________________________________
> > > Serusers mailing list
> > > serusers at lists.iptel.org
> > > http://lists.iptel.org/mailman/listinfo/serusers
> > > 
> > 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20030117/f52cdb85/attachment.pgp>