18 Nov
2005
18 Nov
'05
9:36 a.m.
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
18 Nov
18 Nov
12:52 p.m.
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(a)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
5:50 p.m.
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
6:11 p.m.
Hello,
On 11/18/05 18:50, Florian Overkamp wrote:
Hi Daniel,
Daniel-Constantin Mierla wrote:
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
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
8:10 p.m.
Hi Daniel,
Daniel-Constantin Mierla wrote:
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
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.
6953
days inactive
6953
days old
4 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Florian Overkamp -
Florian Overkamp