New subject: [Serusers] Password problem with ser and mysql

17 Jan 2003

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@localhost For example: grant ALL on ser.* to 
 ser@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@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@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@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@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@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@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(a)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(a)lists.iptel.org
 http://lists.iptel.org/mailman/listinfo/serusers

RE: [Serusers] Password problem with ser and mysql