Hi Nicolas,

the DB upload must be done via the proxy because the DB contains not only the CPL script in XML format, but also in a pre-compiled format of it in binary format. This pre-compiling is done at upload time. You can take it as limitation, but you also have full liberty to implement any transport mechanism for the CPL scripts (from user to server) (like CGI and HTTP) - but on server side, the DB storage must be done via openser.

regarding the docs - you are right, it is a bug there - the module requires a DB module (that's why db_url is mandatory), but this is not properly documented. I will take care of it.

thanks and regards, bogdan

Nicolas Palix wrote:

Hi all,

Is there some limitations ? What about email tag ? The documentation does mention anything.

Futhermore, "db_url" is mandatory but DB module are not mentioned as mandatory in the "Dependencies" section.

Regards,

Le mardi 05 décembre 2006 09:14, Bogdan-Andrei Iancu a écrit :

...

Hi Marvin,

you have two options to upload a CPL script into DB (both require your server up and running)

1. use FIFO/MI command "LOAD_CPL" :

:LOAD_CPL:

username cpl_filename ( openserctl fifo LOAD_CPL sip:user@domain /path/his_cpl_file.xml )

2. use the REGISTER request

http://www.openser.org/docs/modules/1.2.x/cpl-c.html#AEN272

regards, bogdan

Marvin Ottley wrote:

...

Good day all,

I’m trying to use the CPL module and I’m having trouble figuring out how to load the cpl xml script into the cpl database.

Thanks for your pointers

Marvin

---

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users

unfortunately this is necessary as there is the need of pre-compiling the CPL script before using it.

IF you want to rebuild the table (A) used by openser based on another table (B), you should consider minimizing the impact by using something like "last_modified" field in the table B; you should re-build only records modified since the last re-build.

other options will be to have in CPL-C module an auto-compile option - if the compiled format is not found in DB, do it during the first usage and store it in DB.

regards, bogdan

Andreas Sikkema wrote:

On Tuesday 05 December 2006 09:14, Bogdan-Andrei Iancu wrote:

...

( openserctl fifo LOAD_CPL sip:user@domain /path/his_cpl_file.xml )

How would one do this where there are lots (say, thousands) of users? Does this method scale?

Currently I'm rebuilding several tables from a separate database every couple of hours to make sure that the user settings are correct and in sync with my main database. At this moment I just copy data between a couple of tables. If I wanted to start using CPL I'd have to run a command line application for every user. I have this feeling that this might be a little clumsy and not that fast...