[Serusers] Password problem with ser and mysql

[Jan Janak]

Hello,

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

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
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
> 
-------------- 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/ae42d5e1/attachment.pgp>