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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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@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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Jan Janak -
Klaus Darilion