[Serusers] error starting ser daemon with persistency support

[Bogdan-Andrei IANCU]

Hi,

in config script, when setting the parameters for the usrloc module, you 
have something like:
    modparam("usrloc", "db_url", "sql://ser:xxxxx@localhost/ser")
the sql url has this format:
    sql://user:password@host/database
so, please update this URL conforming to your configuration.

Bogdan

Ziying Sherwin wrote:

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