[Users] dbtext again?

Daniel-Constantin Mierla daniel at voice-system.ro
Fri Nov 18 12:52:44 CET 2005


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 at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: version
Url: http://lists.kamailio.org/pipermail/users/attachments/20051118/2cf3c12c/attachment.txt 


More information about the Users mailing list