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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
ZS> _______________________________________________ ZS> Serusers mailing list ZS> serusers@lists.iptel.org ZS> http://lists.iptel.org/mailman/listinfo/serusers