Hi guys,
I'm only just getting started with OpenSer 1.0.0 (from the tarball) and I'd like to use the dbtext option. However, it seems the sc.dbtext doesnt really generate good files. OpenSER reports:
0(0) AUTH module - initializing 0(0) AUTH_DB module - initializing
Content of [version] table_name(str) table_version(int) subscriber:3 location:6 aliases:6
Content of result table_version(int) 3
Content of result table_version(int) 6 0(0) register_udomain(): Invalid table version (use ser_mysql.sh reinstall) 0(0) domain_fixup(): Error while registering domain ERROR: error -1 while trying to fix configuration
I've used the template database files Daniel provided as well, they result in the same fault.
openser.cfg notes: modparam("usrloc", "db_mode", 2) modparam("auth_db", "calculate_ha1", yes) modparam("auth_db", "password_column", "password") modparam("auth_db", "user_column", "username") modparam("auth_db", "domain_column", "domain") modparam("usrloc|auth_db", "db_url", "dbtext:///ext/pbx/lib/openser/dbtext")
I'm probably using wrong database files, but I couldn't find any proper samples so far. Suggestions anyone ?
Thanks, Florian
Hello,
the table version must be populated initially with some values, and the sc.dbtext didn't do it. Please replace the file 'version' from the dbtext database directory with the attached one.
I have committed on the cvs so now sc.dbtext writes the required data when the table 'version' is created.
Cheers, Daniel
On 11/18/05 10:36, Florian Overkamp wrote:
Hi guys,
I'm only just getting started with OpenSer 1.0.0 (from the tarball) and I'd like to use the dbtext option. However, it seems the sc.dbtext doesnt really generate good files. OpenSER reports:
0(0) AUTH module - initializing 0(0) AUTH_DB module - initializing
Content of [version] table_name(str) table_version(int) subscriber:3 location:6 aliases:6
Content of result table_version(int) 3
Content of result table_version(int) 6 0(0) register_udomain(): Invalid table version (use ser_mysql.sh reinstall) 0(0) domain_fixup(): Error while registering domain ERROR: error -1 while trying to fix configuration
I've used the template database files Daniel provided as well, they result in the same fault.
openser.cfg notes: modparam("usrloc", "db_mode", 2) modparam("auth_db", "calculate_ha1", yes) modparam("auth_db", "password_column", "password") modparam("auth_db", "user_column", "username") modparam("auth_db", "domain_column", "domain") modparam("usrloc|auth_db", "db_url", "dbtext:///ext/pbx/lib/openser/dbtext")
I'm probably using wrong database files, but I couldn't find any proper samples so far. Suggestions anyone ?
Thanks, Florian
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
table_name(str) table_version(int) subscriber:5 reserved:1 phonebook:1 pending:4 missed_calls:2 location:1001 aliases:1001 grp:2 event:1 active_sessions:1 acc:2 config:1 silo:3 realm:1 domain:1 uri:1 server_monitoring:1 server_monitoring_agg:1 trusted:1 usr_preferences:2 usr_preferences_types:1 admin_privileges:1 calls_forwarding:1 speed_dial:2 dbaliases:1 gw:3 gw_grp:1 lcr:1
Hi Daniel,
Daniel-Constantin Mierla wrote:
the table version must be populated initially with some values, and the sc.dbtext didn't do it. Please replace the file 'version' from the dbtext database directory with the attached one.
I have committed on the cvs so now sc.dbtext writes the required data when the table 'version' is created.
Hmmcool, I checked that script out and regenerated my databases. The version table is now filled like you've shown, but openser still aborts as show below. Any idea's ?
Thanks for your help!
Florian
0(0) AUTH module - initializing 0(0) AUTH_DB module - initializing
Content of [version] table_name(str) table_version(int) subscriber:5 reserved:1 phonebook:1 pending:4 missed_calls:2 location:1001 aliases:1001 grp:2 event:1 active_sessions:1 acc:2 config:1 silo:3 realm:1 domain:1 uri:1 server_monitoring:1 server_monitoring_agg:1 trusted:1 usr_preferences:2 usr_preferences_types:1 admin_privileges:1 calls_forwarding:1 speed_dial:2 dbaliases:1 gw:3 gw_grp:1 lcr:1
Content of result table_version(int) 5
Content of result table_version(int) 1001
Content of result table_version(int) 1001
Content of [location] username(str) domain(str,null) contact(str,null) received(str,null) expires(int,null) q(double,null) callid(str,null) cseq(int,null) last_modified(int,null) replicate(int,null) state(int,null) flags(int) user_agent(str) 0(0) preload_udomain(): Error while doing db_query 0(0) register_udomain(): Error while preloading domain 'location' 0(0) domain_fixup(): Error while registering domain ERROR: error -1 while trying to fix configuration
Hello,
On 11/18/05 18:50, Florian Overkamp wrote:
Hi Daniel,
Daniel-Constantin Mierla wrote:
the table version must be populated initially with some values, and the sc.dbtext didn't do it. Please replace the file 'version' from the dbtext database directory with the attached one.
I have committed on the cvs so now sc.dbtext writes the required data when the table 'version' is created.
Hmmcool, I checked that script out and regenerated my databases. The version table is now filled like you've shown, but openser still aborts as show below. Any idea's ?
A column was missing in definition of 'location' (as well in 'aliases') table. I will send the sc.dbtext attached to a direct mail, so you can test it before the pserver CVS gets synchronized on sourceforge.
Cheers, Daniel
Thanks for your help!
Florian
0(0) AUTH module - initializing 0(0) AUTH_DB module - initializing
Content of [version] table_name(str) table_version(int) subscriber:5 reserved:1 phonebook:1 pending:4 missed_calls:2 location:1001 aliases:1001 grp:2 event:1 active_sessions:1 acc:2 config:1 silo:3 realm:1 domain:1 uri:1 server_monitoring:1 server_monitoring_agg:1 trusted:1 usr_preferences:2 usr_preferences_types:1 admin_privileges:1 calls_forwarding:1 speed_dial:2 dbaliases:1 gw:3 gw_grp:1 lcr:1
Content of result table_version(int) 5
Content of result table_version(int) 1001
Content of result table_version(int) 1001
Content of [location] username(str) domain(str,null) contact(str,null) received(str,null) expires(int,null) q(double,null) callid(str,null) cseq(int,null) last_modified(int,null) replicate(int,null) state(int,null) flags(int) user_agent(str) 0(0) preload_udomain(): Error while doing db_query 0(0) register_udomain(): Error while preloading domain 'location' 0(0) domain_fixup(): Error while registering domain ERROR: error -1 while trying to fix configuration
Hi Daniel,
Daniel-Constantin Mierla wrote:
Hmmcool, I checked that script out and regenerated my databases. The version table is now filled like you've shown, but openser still aborts as show below. Any idea's ?
A column was missing in definition of 'location' (as well in 'aliases') table. I will send the sc.dbtext attached to a direct mail, so you can test it before the pserver CVS gets synchronized on sourceforge.
Yes, I've confirmed that your new version allows for the script to generate databases that openser will run properly with (at least it starts and keeps running). Now to tinker with the config :-)
Thanks for your help!
Best regards, Florian
-
Daniel-Constantin Mierla -
Florian Overkamp -
Florian Overkamp