[Serusers] Using CPL with SER questions

[steve]

I just pasted this straight in to the mysql client whilst connected to the
ser  db

CREATE TABLE IF NOT EXISTS cpl ( user VARCHAR(50) NOT NULL PRIMARY KEY,
cpl_xml BLOB, cpl_bin BLOB, UNIQUE (user));

The table now exists.

Cheers....

Steve

> -----Original Message-----
> From: Bogdan-Andrei IANCU [mailto:iancu at fokus.fraunhofer.de] 
> Sent: Friday 21 May 2004 17:26
> To: steve; SER Mailing List
> Subject: Re: [Serusers] Using CPL with SER questions
> 
> Hi Steve,
> 
> to create the table required by cpl-c, please referee to 
> modules/cpl-c/init.mysql (add this table to ser DB).
> 
> about adding CPL scripts, use FIFO commands. Take an look in 
> modules/cpl-c/cpl_loader.c to find detailed about available 
> cmds and their syntax.
> 
> Bogdan
> 
> steve wrote:
> 
> >Hi,
> >I have ser running with the cpl-c module and would like to store the 
> >cpl scripts in the ser mysql db as in the recent thread 
> "CPL-C and call 
> >forward on busy or no answer"
> >
> >In my config I have used the following modparams for the CPL module:
> >
> >modparam("cpl-c","cpl_db","mysql://ser:heslo@labbox-b.noclan.
> lab/ser")
> >modparam("cpl-c","cpl_table","cpl")
> >modparam("cpl-c","cpl_dtd_file","/usr/local/etc/ser/cpl-00.dtd")
> >
> >I have made a dtd file based on the draft and ser runs ok.
> >
> >My question is how do I put the cpl scripts in the ser mysql db?
> >
> >The ser db was created when I ran the ser_mysql.sh script and I will 
> >need to create the cpl table in mysql. Is there a script or 
> a standard 
> >way of doing this for CPL support?
> >
> >Thanks in advance.....
> >
> >
> >Steve.
> >
> >
> >_______________________________________________
> >Serusers mailing list
> >serusers at lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers
> >
> >  
> >
> 
> 
> ______________________________________________________________
> __________
> This message has been checked for all known viruses by the 
> CitC Virus Scanning Service powered by SkyLabs. For further 
> information visit http://www.citc.it
> 
> ___
>