[Serusers] Password problem with ser and mysql

[Klaus Darilion]

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
> > 
>