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

17 Jan 2003

Yes, that was my problem! Thank you very mutch!

Are you involved in the SHIP (http://voip.sh.cvut.cz/about.shtml)
project? (because of your emailaddress). I read that you are using Vocal
as voice mail server. Do you have an installation guide how to setup
such a system with vocal and ser?

regards,
Klaus

...
  -----Original Message-----
 From: Jan Janak [mailto:J.Janak@sh.cvut.cz] 
 Sent: Friday, January 17, 2003 1:14 PM
 To: Klaus Darilion
 Cc: serusers(a)lists.iptel.org
 Subject: Re: [Serusers] Password problem with ser and mysql

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

_______________________________________________
  Serusers mailing list
 serusers(a)lists.iptel.org
 http://lists.iptel.org/mailman/listinfo/serusers

RE: [Serusers] Password problem with ser and mysql