database sermyadmin+opensips

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

database sermyadmin+opensips

troxlinux
Hi list, I have problems annexing the sermyadmin database with
opensips, I show them my configuration with opensips to see where I
have the error:

#DEFAULT_DB_URL="mysql://sermyadmin:baco2@localhost/sermyadmin"
modparam("presence|presence_xml|group|permissions|auth_db|uri_db|usrloc",
"db_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")
modparam("domain", "db_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")
modparam("domain", "db_mode", 1)
modparam("auth_db", "password_column", "ha1")
modparam("auth_db", "password_column_2", "ha1b")
modparam("presence_xml", "force_active", 1)
modparam("presence", "max_expires", 3600)
modparam("presence", "server_address", "sip:192.168.10.3:5060")
modparam("permissions", "db_mode", 1)
modparam("permissions", "trusted_table", "trusted")
modparam("group", "group_column", "grp")
modparam("avpops", "avp_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")
modparam("avpops", "avp_table", "usr_preferences")


opensipsctrlrc

DBNAME=sermyadmin

# database path used by dbtext or db_berkeley
# DB_PATH="/usr/local/etc/opensips/dbtext"

## database read/write user

DBRWUSER=sermyadmin

## password for database read/write user
DBRWPW="baco2"

## database read only user
DBROUSER=sermyadmin

## password for database read only user
DBROPW=baco2


log openser

Mar 16 11:02:47 twoxserver /sbin/opensips[9238]:
ERROR:core:db_check_table_version: invalid version 1 for table
watchers found, expected 3
Mar 16 11:02:47 twoxserver /sbin/opensips[9238]:
ERROR:presence:mod_init: error during table version check
Mar 16 11:02:47 twoxserver /sbin/opensips[9238]: ERROR:core:init_mod:
failed to initialize module presence
Mar 16 11:02:47 twoxserver /sbin/opensips[9238]: ERROR:core:main:
error while initializing modules

some idea where my error can be?

regardss

--
rickygm

http://gnuforever.homelinux.com

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: database sermyadmin+opensips

Flavio Goncalves-2
database sermyadmin+opensips
Hi Ricky,
 
It is an old definition in the presence tables. Delete the presence related tables and recreate them with the mysql scripts in the opensips source code. /scripts/mysql/.... It is fixed in the newest version.
 
Flavio


From: troxlinux [mailto:[hidden email]]
Sent: Mon 16/03/2009 14:26
To: [hidden email]
Cc: Flávio Eduardo de Andrade
Subject: database sermyadmin+opensips

Hi list, I have problems annexing the sermyadmin database with
opensips, I show them my configuration with opensips to see where I
have the error:

#DEFAULT_DB_URL="mysql://sermyadmin:baco2@localhost/sermyadmin"
modparam("presence|presence_xml|group|permissions|auth_db|uri_db|usrloc",
"db_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")
modparam("domain", "db_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")
modparam("domain", "db_mode", 1)
modparam("auth_db", "password_column", "ha1")
modparam("auth_db", "password_column_2", "ha1b")
modparam("presence_xml", "force_active", 1)
modparam("presence", "max_expires", 3600)
modparam("presence", "server_address", "sip:192.168.10.3:5060")
modparam("permissions", "db_mode", 1)
modparam("permissions", "trusted_table", "trusted")
modparam("group", "group_column", "grp")
modparam("avpops", "avp_url", "mysql://sermyadmin:baco2@localhost/sermyadmin")
modparam("avpops", "avp_table", "usr_preferences")


opensipsctrlrc

DBNAME=sermyadmin

# database path used by dbtext or db_berkeley
# DB_PATH="/usr/local/etc/opensips/dbtext"

## database read/write user

DBRWUSER=sermyadmin

## password for database read/write user
DBRWPW="baco2"

## database read only user
DBROUSER=sermyadmin

## password for database read only user
DBROPW=baco2


log openser

Mar 16 11:02:47 twoxserver /sbin/opensips[9238]:
ERROR:core:db_check_table_version: invalid version 1 for table
watchers found, expected 3
Mar 16 11:02:47 twoxserver /sbin/opensips[9238]:
ERROR:presence:mod_init: error during table version check
Mar 16 11:02:47 twoxserver /sbin/opensips[9238]: ERROR:core:init_mod:
failed to initialize module presence
Mar 16 11:02:47 twoxserver /sbin/opensips[9238]: ERROR:core:main:
error while initializing modules

some idea where my error can be?

regardss

--
rickygm

http://gnuforever.homelinux.com


"Vai contratar um canal E1 ou SIP? Além de oferecermos o melhor preço, na contratação de um canal E1 ou SIP GVT você recebe um desconto no projeto que pode chegar a até 50%". Consulte-nos sobre a viabilidade técnica e econômica".

"Vai contratar um canal de dados? Além de oferecermos o melhor preço, na contratação de um canal de dados corporativo GVT você recebe um desconto no projeto que pode chegar a até 50%". Consulte-nos sobre a viabilidade técnica e econômica".


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: database sermyadmin+opensips

troxlinux
Hi Flavio,  I making it but he gives me an error message:

vim presence-create.sql
[root@twoxserver mysql] #mysql -or root -p sermyadmin <presence-create.sql
Enter password:
ERROR 1062 (23000) at line 1: Duplicate you entry ' presentity' for key 1

presence-create.sql
INSERT INTO version (table_name, table_version) values ('presentity','3');

that appropriate value can give him?

best regards


2009/3/16 Flávio Eduardo de Andrade <[hidden email]>:
> Hi Ricky,
>
> It is an old definition in the presence tables. Delete the presence related
> tables and recreate them with the mysql scripts in the opensips source code.
> /scripts/mysql/.... It is fixed in the newest version.
>
> Flavio
> ________________________________
--
rickygm

http://gnuforever.homelinux.com

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: database sermyadmin+opensips

troxlinux
Hi flavio , flavio erases the five tables according to the opensips
docu but when I want to export the file presence-create.sql it always
shows me the same error:

ERROR 1062 (23000) at line 1: Duplicate entry 'presentity' for key 1

http://www.opensips.org/html/docs/db/db-schema-1.4.x.html#GEN-DB-PRESENTITY

thank you for all your help, but it interests me to run sermyadmin

regardsss

2009/3/16 Flávio Eduardo de Andrade <[hidden email]>:
> Remove all the tables related to presence (About 5). Check inside the
> presence-create.sql
>
> Regards,
>
> Flavio

--
rickygm

http://gnuforever.homelinux.com

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: database sermyadmin+opensips

Bogdan-Andrei Iancu
Hi,

remove from "version" table all the entries related (as name) to the
presence tables you remove. Then run the creation script.

Regards,
Bogdan

troxlinux wrote:

> Hi flavio , flavio erases the five tables according to the opensips
> docu but when I want to export the file presence-create.sql it always
> shows me the same error:
>
> ERROR 1062 (23000) at line 1: Duplicate entry 'presentity' for key 1
>
> http://www.opensips.org/html/docs/db/db-schema-1.4.x.html#GEN-DB-PRESENTITY
>
> thank you for all your help, but it interests me to run sermyadmin
>
> regardsss
>
> 2009/3/16 Flávio Eduardo de Andrade <[hidden email]>:
>  
>> Remove all the tables related to presence (About 5). Check inside the
>> presence-create.sql
>>
>> Regards,
>>
>> Flavio
>>    
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: database sermyadmin+opensips

troxlinux
thank Flavio and Bogdan it work fine ..

regardss

2009/3/17 Bogdan-Andrei Iancu <[hidden email]>:
> Hi,
>
> remove from "version" table all the entries related (as name) to the
> presence tables you remove. Then run the creation script.
>
> Regards,
> Bogdan
>



--
rickygm

http://gnuforever.homelinux.com

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users