New subject: [Serusers] SER MySQL Support Error !!!

8 Dec 2004

Chris, 

	I'm using a pre compiled version 0.8.14 ... there's is no make point to make all
& make install the software, maybe because I downloaded the wrong version, or a very
old version... I've tried to download it again from the above links listed in the
site:

ftp://ftp.berlios.de/pub/ser/latest/
ftp://ftp.berlios.de/pub/ser/

But it doesn't download, maybe the link is down ...
My Mysql is working fine (version 4.0.22) but I'm a little bit confused about the
version to make all & make install ser. Could you send me you ser version or the
program itself if it's a different one ?

Thanks in Advance

Begin forwarded message:

Date: Wed, 8 Dec 2004 11:41:40 -0000
From: "Cannes" &lt;mail(a)cannes.f9.co.uk&gt;
To: "'Felipe Martins'" &lt;fmartins(a)mundivox.com&gt;om>,
&lt;serusers(a)lists.iptel.org&gt;
Subject: RE: [Serusers] SER MySQL Support Error !!!

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(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of Felipe Martins
Sent: 08 December 2004 12:26
To: serusers(a)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 &lt;fmartins(a)mundivox.com&gt; 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(a)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(a)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

-- 
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

Fw: [Serusers] SER MySQL Support Error !!!