[Serusers] error starting ser daemon with persistency support

[Vitali Nikolaev]

Hello Ziying,


modparam("auth_db", "db_url","sql://ser:passwd@localhost/ser")
modparam("usrloc", "db_url", "sql://ser:passwd@localhost/ser")


Thursday, January 22, 2004, 11:17:20 AM, you wrote:



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

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

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

ZS> Thanks again.

ZS> Ziying Sherwin


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

ZS> _______________________________________________
ZS> Serusers mailing list
ZS> serusers at lists.iptel.org
ZS> http://lists.iptel.org/mailman/listinfo/serusers



-- 
Best regards,
 Vitali