[Serusers] Password problem with ser and mysql

[Klaus Darilion]

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 at sh.cvut.cz] 
> Sent: Friday, January 17, 2003 1:14 PM
> To: Klaus Darilion
> Cc: serusers at 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 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
> > > > 
> > > 
> > 
> _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
> > 
>