Hello Everybody,
I am using ser with mysql to authenticate my users, well, i'm trying to use, i'm having an erro message when I start it. What I exactly did was: start up ser (without mysql.so modulo at ser.cfg), and started mysql database with just one table ... obviously when I try to execute "# ser_mysql.sh create", this returns me the following error because I don't have the mysql.so configured in the ser.cfg
"ERROR 1064 (42000) at line 7: You have an error inyour SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY '47serro11'' at line 1"
The problem is that when I configure the mysql.so at ser.cfg with the line '"lodmodule "/usr/local/lib/ser/modules/mysql.so"' and start again the ser server, the following error appears:
"ERROR: bad config file (1 errors)"
Even if you could create the mysql tables with the ser_mysql.sh I wouldn't be able to run ser with the mysql support. What am i doing wrong ?
I seem to be having a similar problem After having just rebuilt, I find that on "ser start" it tells me "one script error" because it cannot find "mysql.so" make all make install seems to build and install other shared objects but not mysql.so I am just trying to find out why... Chris
-----Original Message----- From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Felipe Martins Sent: 07 December 2004 13:24 To: serusers@lists.iptel.org Subject: [Serusers] SER MySQL Support Error !!!
Hello Everybody,
I am using ser with mysql to authenticate my users, well, i'm trying to use, i'm having an erro message when I start it. What I exactly did was: start up ser (without mysql.so modulo at ser.cfg), and started mysql database with just one table ... obviously when I try to execute "# ser_mysql.sh create", this returns me the following error because I don't have the mysql.so configured in the ser.cfg
"ERROR 1064 (42000) at line 7: You have an error inyour SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY '47serro11'' at line 1"
The problem is that when I configure the mysql.so at ser.cfg with the line '"lodmodule "/usr/local/lib/ser/modules/mysql.so"' and start again the ser server, the following error appears:
"ERROR: bad config file (1 errors)"
Even if you could create the mysql tables with the ser_mysql.sh I wouldn't be able to run ser with the mysql support. What am i doing wrong ?
Hello All,
Does anyone know something about the error messages i'm receiving ? I looked for it all over the net and find nothing .. any help will be in hand ...
On Tue, 7 Dec 2004 10:23:57 -0300 Felipe Martins fmartins@mundivox.com wrote:
Hello Everybody,
I am using ser with mysql to authenticate my users, well, i'm trying to use, i'm having an erro message when I start it. What I exactly did was: start up ser (without mysql.so modulo at ser.cfg), and started mysql database with just one table ... obviously when I try to execute "# ser_mysql.sh create", this returns me the following error because I don't have the mysql.so configured in the ser.cfg
"ERROR 1064 (42000) at line 7: You have an error inyour SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY '47serro11'' at line 1"
The problem is that when I configure the mysql.so at ser.cfg with the line '"lodmodule "/usr/local/lib/ser/modules/mysql.so"' and start again the ser server, the following error appears:
"ERROR: bad config file (1 errors)"
Even if you could create the mysql tables with the ser_mysql.sh I wouldn't be able to run ser with the mysql support. What am i doing wrong ?
-- Felipe Martins Linux System Administrator Tep Solution Provider Mundivox Communications Rua Lauro Muller, 116/Sala 505 RJ - Brasil - 22290-906 Tel.: 55 21 3820-8839 Fax.: 55 21 3820-8844
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Felipe I had the same symptoms which may be the same cause.
The makefile excludes mysql so mysql.so does not get built/installed.
I removed the exclusion, made all + made install and it was cured.
(Though curiously I had to reboot the linux first to clear mysql which seem to be hung up.)
Chris
-----Original Message----- From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Felipe Martins Sent: 08 December 2004 12:26 To: serusers@lists.iptel.org Subject: Re: [Serusers] SER MySQL Support Error !!!
Hello All,
Does anyone know something about the error messages i'm receiving ? I looked for it all over the net and find nothing .. any help will be in hand ...
On Tue, 7 Dec 2004 10:23:57 -0300 Felipe Martins fmartins@mundivox.com wrote:
Hello Everybody,
I am using ser with mysql to authenticate my users, well, i'm trying
to use, i'm having an erro message when I start it. What I exactly did was: start up ser (without mysql.so modulo at ser.cfg), and started mysql database with just one table ... obviously when I try to execute "# ser_mysql.sh create", this returns me the following error because I don't have the mysql.so configured in the ser.cfg
"ERROR 1064 (42000) at line 7: You have an error inyour SQL syntax; check
the manual that corresponds to your MySQL server version for the right syntax to use near 'BY '47serro11'' at line 1"
The problem is that when I configure the mysql.so at ser.cfg with the line
'"lodmodule "/usr/local/lib/ser/modules/mysql.so"' and start again the ser server, the following error appears:
"ERROR: bad config file (1 errors)"
Even if you could create the mysql tables with the ser_mysql.sh I wouldn't
be able to run ser with the mysql support. What am i doing wrong ?
-- Felipe Martins Linux System Administrator Tep Solution Provider Mundivox Communications Rua Lauro Muller, 116/Sala 505 RJ - Brasil - 22290-906 Tel.: 55 21 3820-8839 Fax.: 55 21 3820-8844
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Hi everybody,
I found the problem, the problem was that I wasn't using libmysqlclient.so.10, the moment I configured it, the problem stopped, thanks for the information, ideas and patience.
On Wed, 8 Dec 2004 11:41:40 -0000 "Cannes" mail@cannes.f9.co.uk wrote:
Felipe I had the same symptoms which may be the same cause.
The makefile excludes mysql so mysql.so does not get built/installed.
I removed the exclusion, made all + made install and it was cured.
(Though curiously I had to reboot the linux first to clear mysql which seem to be hung up.)
Chris
-----Original Message----- From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Felipe Martins Sent: 08 December 2004 12:26 To: serusers@lists.iptel.org Subject: Re: [Serusers] SER MySQL Support Error !!!
Hello All,
Does anyone know something about the error messages i'm receiving ? I looked for it all over the net and find nothing .. any help will be in hand ...
On Tue, 7 Dec 2004 10:23:57 -0300 Felipe Martins fmartins@mundivox.com wrote:
Hello Everybody,
I am using ser with mysql to authenticate my users, well, i'm trying
to use, i'm having an erro message when I start it. What I exactly did was: start up ser (without mysql.so modulo at ser.cfg), and started mysql database with just one table ... obviously when I try to execute "# ser_mysql.sh create", this returns me the following error because I don't have the mysql.so configured in the ser.cfg
"ERROR 1064 (42000) at line 7: You have an error inyour SQL syntax; check
the manual that corresponds to your MySQL server version for the right syntax to use near 'BY '47serro11'' at line 1"
The problem is that when I configure the mysql.so at ser.cfg with the line
'"lodmodule "/usr/local/lib/ser/modules/mysql.so"' and start again the ser server, the following error appears:
"ERROR: bad config file (1 errors)"
Even if you could create the mysql tables with the ser_mysql.sh I wouldn't
be able to run ser with the mysql support. What am i doing wrong ?
-- Felipe Martins Linux System Administrator Tep Solution Provider Mundivox Communications Rua Lauro Muller, 116/Sala 505 RJ - Brasil - 22290-906 Tel.: 55 21 3820-8839 Fax.: 55 21 3820-8844
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-- Felipe Martins Linux System Administrator Tep Solution Provider Mundivox Communications Rua Lauro Muller, 116/Sala 505 RJ - Brasil - 22290-906 Tel.: 55 21 3820-8839 Fax.: 55 21 3820-8844
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.807 / Virus Database: 549 - Release Date: 07/12/2004
Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.807 / Virus Database: 549 - Release Date: 07/12/2004
The message say "lodmodule" is this a typo in the email message you sent or the actual command in your config file. If the later then this is most likely the problem. The command is loadmodule.
-Steve
Felipe Martins wrote:
Hello All,
Does anyone know something about the error messages i'm receiving ? I looked for it all over the net and find nothing .. any help will be in hand ...
On Tue, 7 Dec 2004 10:23:57 -0300 Felipe Martins fmartins@mundivox.com wrote:
Hello Everybody,
I am using ser with mysql to authenticate my users, well, i'm trying to use, i'm having an erro message when I start it. What I exactly did was: start up ser (without mysql.so modulo at ser.cfg), and started mysql database with just one table ... obviously when I try to execute "# ser_mysql.sh create", this returns me the following error because I don't have the mysql.so configured in the ser.cfg
"ERROR 1064 (42000) at line 7: You have an error inyour SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY '47serro11'' at line 1"
The problem is that when I configure the mysql.so at ser.cfg with the line '"lodmodule "/usr/local/lib/ser/modules/mysql.so"' and start again the ser server, the following error appears:
"ERROR: bad config file (1 errors)"
Even if you could create the mysql tables with the ser_mysql.sh I wouldn't be able to run ser with the mysql support. What am i doing wrong ?
-- Felipe Martins Linux System Administrator Tep Solution Provider Mundivox Communications Rua Lauro Muller, 116/Sala 505 RJ - Brasil - 22290-906 Tel.: 55 21 3820-8839 Fax.: 55 21 3820-8844
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Cannes -
Chris -
Felipe Martins -
Steve Blair