How does openser connect to mysql which is not in the same machine (say openser is in 10.0.0.1 and mysql is in 10.0.0.2)? I have configured all mysql statement in the configuration file as "mysql://openser:openserrw@10.0.0.2/openser" but openser failed to start. Below is the error message from the log.
Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: new_connection: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: ERROR:domain_db_init: cannot initialize database connection Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: ERROR: domain:child_init(): Unable to connect to the database Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: ERROR:init_mod_child: Error while initializing module domain, rank 1
I find that we need to set the SQL_HOST in openserctl. Or write SQL_HOST=db in /usr/local/etc/openser/.openserctlrc. ---------------- After setting it up, I am facing the other problem.
I am confused for the below functions in the register method.
if (!www_authorize("","subscriber")) { www_challenge("","0"); return; };
if (!check_to()) { sl_send_reply("401", "Unauthorized"); return; };
If openser and mysql are installed in the same machine, above statement will work. However, if they are installed in different machine, about statements will failed. for example. openser installed in openser.example.com (10.0.0.1) mysql installed in mysql.example.com (10.0.0.2) In subscriber table, we have some accounts and the value of domain field is openser.example.com What should be filled in the functions www_authorize("[input]","subscriber")) and www_challenge("[input]","0") for the above case? If I fill with openser.example.com, the above functions will still failed.
On 1/21/06, unplug maillisting@gmail.com wrote:
How does openser connect to mysql which is not in the same machine (say openser is in 10.0.0.1 and mysql is in 10.0.0.2)? I have configured all mysql statement in the configuration file as "mysql://openser:openserrw@10.0.0.2/openser" but openser failed to start. Below is the error message from the log.
Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: new_connection: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: ERROR:domain_db_init: cannot initialize database connection Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: ERROR: domain:child_init(): Unable to connect to the database Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: ERROR:init_mod_child: Error while initializing module domain, rank 1
Hi,
be sure that all module you are using have the db_url parameter properly set (if param available). By default, the value of this param is pointing to localhost.
unplug wrote:
I find that we need to set the SQL_HOST in openserctl. Or write SQL_HOST=db in /usr/local/etc/openser/.openserctlrc.
After setting it up, I am facing the other problem.
I am confused for the below functions in the register method.
if (!www_authorize("","subscriber")) { www_challenge("","0"); return; }; if (!check_to()) { sl_send_reply("401", "Unauthorized"); return; };If openser and mysql are installed in the same machine, above statement will work. However, if they are installed in different machine, about statements will failed. for example. openser installed in openser.example.com (10.0.0.1) mysql installed in mysql.example.com (10.0.0.2) In subscriber table, we have some accounts and the value of domain field is openser.example.com What should be filled in the functions www_authorize("[input]","subscriber")) and www_challenge("[input]","0") for the above case? If I fill with openser.example.com, the above functions will still failed.
the first parameter may be the domain name used for authentication - it order to work, it must be the same as the domain the users are subscribed with (see domain column in subscriber table).
regards, bogdan
On 1/21/06, unplug maillisting@gmail.com wrote:
How does openser connect to mysql which is not in the same machine (say openser is in 10.0.0.1 and mysql is in 10.0.0.2)? I have configured all mysql statement in the configuration file as "mysql://openser:openserrw@10.0.0.2/openser" but openser failed to start. Below is the error message from the log.
Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: new_connection: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: ERROR:domain_db_init: cannot initialize database connection Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: ERROR: domain:child_init(): Unable to connect to the database Jan 21 14:25:51 owthkems01 /usr/local/sbin/openser[12298]: ERROR:init_mod_child: Error while initializing module domain, rank 1
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Bogdan-Andrei Iancu -
unplug