[Serusers] error starting ser daemon with persistency support

[Ziying Sherwin]

Thank you very much for the help with the debug level. Now we can finally find
where the problem is. It seems that it has something to do with the MySQL
database access. We changed the username and password in both ser_mysql.sh
and serctl. So we got the following error message from the ser debug output:

 0(29503) connect_db(): Access denied for user: 'ser at localhost' (Using password: YES)
 0(29503) db_init(): Error while trying to connect database
 0(29503) mod_init(): Error while connecting database
 0(29503) init_mod(): Error while initializing module usrloc
ERROR: error while initializing modules

We did not find any place to reset the password and username in the ser.cfg
file, does that mean that those passwords and usernames are hard-coded into
the C files? Which files should we change to reflect the password/username
modification we made?

Thanks again.

Ziying Sherwin


On Thu, 22 Jan 2004, Bogdan-Andrei IANCU wrote:

> Hi,
> increase the debug level in configuration file and you will see the line 
> were the error lays in config script.
> 
> Bogdan
> 
> Ziying Sherwin wrote:
> 
> >We are trying to compile ser 0.8.12 on Solaris 2.8 using gcc 3.3. The 
> >compilation and installation go smoothly until we tried to start the ser
> >daemon with persistancy support.
> >
> >We followed the instructions listed on the website. First, we modified the
> >MySQL configuration file to increase the maximun connections allowed. Second
> >we restart the MySQL daemon. Third, we modified the ser_mysql.sh file to 
> >set the username, password and path properly and used it to create the MySQL
> >tables. Then we modifid ser.cfg file and uncommented the following lines:
> >
> >   loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/mysql.so"
> >   loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/auth.so"
> >   loadmodule "/depot/package/ser_0.8.12/lib/ser/modules/auth_db.so"
> >   modparam("usrloc", "db_mode", 2)
> >   modparam("auth", "calculate_ha1", yes)
> >   modparam("auth_db", "password_column", "password")
> >
> >uncommented and modified the following lines:
> >
> >   if (!www_authorize("<our domain name>", "subscriber")) {
> >          www_challenge("<our domain name>", "0");
> >          break;
> >   };
> >
> >Finally, we tried to start the ser daemon by directly calling the binary "ser",
> >and the got the following error message:
> >
> >  
> >
> >>ser
> >>    
> >>
> >ERROR: bad config file (1 errors)
> >
> >How can we find where the error is? All the modules listed in the configuration
> >file are present in the directory. What else could go wrong? 
> >
> >Thank you very much in advance.
> >
> >Ziying Sherwin
> >
> >
> >_______________________________________________
> >Serusers mailing list
> >serusers at lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers
> >
> >  
> >
> 
>