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