22 Jan
2004
22 Jan
'04
6:21 p.m.
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(a)lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers
> >
> >
> >
>
>
ZS> _______________________________________________
ZS> Serusers mailing list
ZS> serusers(a)lists.iptel.org
ZS> http://lists.iptel.org/mailman/listinfo/serusers
--
Best regards,
Vitali