[OpenSER-Users] Possible problem with script presence-create.sql
Hello, I'm a new user of openser. (I use openser 1.3.1-3+b1 from package of debian testing) I want to use the module of presence. If I refer to documentation I read that I have to use presence_xml-create.sql to create the tables. But I can't find it. I use the script presence-create.sql which seems to replace it. I create a table named xcap but the module need xcaps, if I create the same table renamed xcaps that work well. I think there is a mistake of naming of the table xcap(s). I take a look to 1.3.x of your repository and I see the same thing in the sql script. Thank you for your job. Best regards. Florent le Saout. Créez votre adresse électronique prénom.nom@laposte.net 1 Go d'espace de stockage, anti-spam et anti-virus intégrés.
On Wednesday 21 May 2008, Florent Le Saout wrote:
I'm a new user of openser. (I use openser 1.3.1-3+b1 from package of debian testing) I want to use the module of presence. If I refer to documentation I read that I have to use presence_xml-create.sql to create the tables. But I can't find it. I use the script presence-create.sql which seems to replace it. I create a table named xcap but the module need xcaps, if I create the same table renamed xcaps that work well. I think there is a mistake of naming of the table xcap(s). I take a look to 1.3.x of your repository and I see the same thing in the sql script.
Thank you for your job.
Hi Florent, there are some small errors present in the presence modules documentation. The docs state that the table name is "xcaps", but the correct name is "xcap". This is also the default name. If you don't specify "xcaps" in the configuration, the modules should work just fine. The database script name is also not correct. Thank you for the report, Henning
Hi Florent, Indeed the name of the script was wrong in the documentation and I have fixed it. The name of the xcap table was not misspelled as 'xcaps'. /The module requires 1 table in OpenSER database: xcap. / You probably refer to the line with the example of how to set the xcap table name module parameter: / 'modparam("presence_xml", "xcap_table", "xcaps")'. / This should be used if you what the table to have a different name, and of course, you should use the same when creating the database table. Thanks and regards, Anca Henning Westerholt wrote:
On Wednesday 21 May 2008, Florent Le Saout wrote:
I'm a new user of openser. (I use openser 1.3.1-3+b1 from package of debian testing) I want to use the module of presence. If I refer to documentation I read that I have to use presence_xml-create.sql to create the tables. But I can't find it. I use the script presence-create.sql which seems to replace it. I create a table named xcap but the module need xcaps, if I create the same table renamed xcaps that work well. I think there is a mistake of naming of the table xcap(s). I take a look to 1.3.x of your repository and I see the same thing in the sql script.
Thank you for your job.
Hi Florent,
there are some small errors present in the presence modules documentation. The docs state that the table name is "xcaps", but the correct name is "xcap". This is also the default name. If you don't specify "xcaps" in the configuration, the modules should work just fine. The database script name is also not correct.
Thank you for the report,
Henning
On Monday 26 May 2008, Anca Vamanu wrote:
Indeed the name of the script was wrong in the documentation and I have fixed it. The name of the xcap table was not misspelled as 'xcaps'. /The module requires 1 table in OpenSER database: xcap. / You probably refer to the line with the example of how to set the xcap table name module parameter: / 'modparam("presence_xml", "xcap_table", "xcaps")'. / This should be used if you what the table to have a different name, and of course, you should use the same when creating the database table.
Thank you Anca for the clarification, and the fix. Henning
participants (3)
-
Anca Vamanu -
Florent Le Saout -
Henning Westerholt