hello group,
I just started setting up Ser on a linux box (Debian). Please excuse me if my questions have been asked many times before. I have two questions here 1. when I compile from source, the mysql module is not compiled, I cannot find mysql.so anywhere. I use the latest 0.8.12 release. The daemon started okay without mysql modules.
2. after no luck with the source, I switched to Debian package. I see mysql modules are properly installed. I installed the mysql client on my Debian box, and the Mysql database on a external box, I created all tables and users successfully and I can manually access the database from command line. But when I start the Ser daemon, it would not start and still trying to look the Mysql.sock on local machine. my questions is where do you tell Ser daemon to use global my.cnf file for external database?
Chundao Che
Chundao Che wrote:
hello group,
I just started setting up Ser on a linux box (Debian). Please excuse me if my questions have been asked many times before. I have two questions here
- when I compile from source, the mysql module is not compiled, I
cannot find mysql.so anywhere. I use the latest 0.8.12 release. The daemon started okay without mysql modules.
you have to enable mysql in the Makefile or by typing: make modules ........... as described in http://lists.iptel.org/pipermail/serusers/2004-March/006904.html
- after no luck with the source, I switched to Debian package. I see
mysql modules are properly installed. I installed the mysql client on my Debian box, and the Mysql database on a external box, I created all tables and users successfully and I can manually access the database from command line. But when I start the Ser daemon, it would not start and still trying to look the Mysql.sock on local machine. my questions is where do you tell Ser daemon to use global my.cnf file for external database?
you have to set the database url: modparam("auth_db", "password_column", "password") modparam("auth_db", "db_url", "mysql://ser:XXXXXXX@your.server.com/ser")
klaus
Klaus,
thanks for your response. To question #1, after 'make modules' there is no mysql.so file generated. Question #2, the db_url does not seem to do anything differently.
Chundao
Klaus Darilion wrote:
Chundao Che wrote:
hello group,
I just started setting up Ser on a linux box (Debian). Please excuse me if my questions have been asked many times before. I have two questions here
- when I compile from source, the mysql module is not compiled, I
cannot find mysql.so anywhere. I use the latest 0.8.12 release. The daemon started okay without mysql modules.
you have to enable mysql in the Makefile or by typing: make modules ........... as described in http://lists.iptel.org/pipermail/serusers/2004-March/006904.html
- after no luck with the source, I switched to Debian package. I see
mysql modules are properly installed. I installed the mysql client on my Debian box, and the Mysql database on a external box, I created all tables and users successfully and I can manually access the database from command line. But when I start the Ser daemon, it would not start and still trying to look the Mysql.sock on local machine. my questions is where do you tell Ser daemon to use global my.cnf file for external database?
you have to set the database url: modparam("auth_db", "password_column", "password") modparam("auth_db", "db_url", "mysql://ser:XXXXXXX@your.server.com/ser")
klaus
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
On Jun 03, 2004 at 09:45, Chundao Che cche@umd.umich.edu wrote:
Klaus,
thanks for your response. To question #1, after 'make modules' there is no mysql.so file generated. Question #2, the db_url does not seem to do anything differently.
#1 : make modules include_modules=mysql or make modules ; make modules modules=modules/mysql
and to install:
make install include_modules=mysq
#2 :
What modules are you using? Try something like: modparam("usrloc|acc|auth_db|group|msilo", "db_url", "mysql:ser:XXXXXXX@your.server.com/ser")
(and delete from it the modules you are not using)
Andrei
Chundao
Klaus Darilion wrote:
Chundao Che wrote:
hello group,
I just started setting up Ser on a linux box (Debian). Please excuse me if my questions have been asked many times before. I have two questions here
- when I compile from source, the mysql module is not compiled, I
cannot find mysql.so anywhere. I use the latest 0.8.12 release. The daemon started okay without mysql modules.
you have to enable mysql in the Makefile or by typing: make modules ........... as described in http://lists.iptel.org/pipermail/serusers/2004-March/006904.html
- after no luck with the source, I switched to Debian package. I see
mysql modules are properly installed. I installed the mysql client on my Debian box, and the Mysql database on a external box, I created all tables and users successfully and I can manually access the database from command line. But when I start the Ser daemon, it would not start and still trying to look the Mysql.sock on local machine. my questions is where do you tell Ser daemon to use global my.cnf file for external database?
you have to set the database url: modparam("auth_db", "password_column", "password") modparam("auth_db", "db_url", "mysql://ser:XXXXXXX@your.server.com/ser")
klaus
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Try this and see if mysql compilation fail and the error returned.
cd modules/mysql/ make (collect error and send to list)
In some systems the mysql.so compilation fail due to absence of zlib or other needed files.
----- Original Message ----- From: "Andrei Pelinescu-Onciul" pelinescu-onciul@fokus.fraunhofer.de To: "Chundao Che" cche@umd.umich.edu Cc: serusers@lists.iptel.org Sent: Thursday, June 03, 2004 11:37 AM Subject: Re: [Serusers] Mysql DB on remote host
On Jun 03, 2004 at 09:45, Chundao Che cche@umd.umich.edu wrote:
Klaus,
thanks for your response. To question #1, after 'make modules' there is no mysql.so file generated. Question #2, the db_url does not seem to do anything differently.
#1 : make modules include_modules=mysql or make modules ; make modules modules=modules/mysql
and to install:
make install include_modules=mysq
#2 :
What modules are you using? Try something like: modparam("usrloc|acc|auth_db|group|msilo", "db_url",
"mysql:ser:XXXXXXX@your.server.com/ser")
(and delete from it the modules you are not using)
Andrei
Chundao
Klaus Darilion wrote:
Chundao Che wrote:
hello group,
I just started setting up Ser on a linux box (Debian). Please excuse me if my questions have been asked many times before. I have two questions here
- when I compile from source, the mysql module is not compiled, I
cannot find mysql.so anywhere. I use the latest 0.8.12 release. The daemon started okay without mysql modules.
you have to enable mysql in the Makefile or by typing: make modules ........... as described in http://lists.iptel.org/pipermail/serusers/2004-March/006904.html
- after no luck with the source, I switched to Debian package. I see
mysql modules are properly installed. I installed the mysql client on my Debian box, and the Mysql database on a external box, I created all tables and users successfully and I can manually access the database from command line. But when I start the Ser daemon, it would not start and still trying to look the Mysql.sock on local machine. my questions is where do you tell Ser daemon to use global my.cnf file for external database?
you have to set the database url: modparam("auth_db", "password_column", "password") modparam("auth_db", "db_url",
"mysql://ser:XXXXXXX@your.server.com/ser")
klaus
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Doing make directly in a module directori is totaly broken. If you want to compile only a module do : make modules modules=modules/mysql
Bogdan
Ezequiel Colombo wrote:
Try this and see if mysql compilation fail and the error returned.
cd modules/mysql/ make (collect error and send to list)
In some systems the mysql.so compilation fail due to absence of zlib or other needed files.
----- Original Message ----- From: "Andrei Pelinescu-Onciul" pelinescu-onciul@fokus.fraunhofer.de To: "Chundao Che" cche@umd.umich.edu Cc: serusers@lists.iptel.org Sent: Thursday, June 03, 2004 11:37 AM Subject: Re: [Serusers] Mysql DB on remote host
On Jun 03, 2004 at 09:45, Chundao Che cche@umd.umich.edu wrote:
Klaus,
thanks for your response. To question #1, after 'make modules' there is no mysql.so file generated. Question #2, the db_url does not seem to do anything differently.
#1 : make modules include_modules=mysql or make modules ; make modules modules=modules/mysql
and to install:
make install include_modules=mysq
#2 :
What modules are you using? Try something like: modparam("usrloc|acc|auth_db|group|msilo", "db_url",
"mysql:ser:XXXXXXX@your.server.com/ser")
(and delete from it the modules you are not using)
Andrei
Chundao
Klaus Darilion wrote:
Chundao Che wrote:
hello group,
I just started setting up Ser on a linux box (Debian). Please excuse me if my questions have been asked many times before. I have two questions here
- when I compile from source, the mysql module is not compiled, I
cannot find mysql.so anywhere. I use the latest 0.8.12 release. The daemon started okay without mysql modules.
you have to enable mysql in the Makefile or by typing: make modules ........... as described in http://lists.iptel.org/pipermail/serusers/2004-March/006904.html
- after no luck with the source, I switched to Debian package. I see
mysql modules are properly installed. I installed the mysql client on my Debian box, and the Mysql database on a external box, I created all tables and users successfully and I can manually access the database from command line. But when I start the Ser daemon, it would not start and still trying to look the Mysql.sock on local machine. my questions is where do you tell Ser daemon to use global my.cnf file for external database?
you have to set the database url: modparam("auth_db", "password_column", "password") modparam("auth_db", "db_url",
"mysql://ser:XXXXXXX@your.server.com/ser")
klaus
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Andrei Pelinescu-Onciul -
Bogdan-Andrei IANCU -
Chundao Che -
Ezequiel Colombo -
Klaus Darilion