[Devel] Re: [Serdev] Trying Oracle module -- still struggling

[Evan Borgstrom]

	Make sure you have a version table and it's populated with the values 
from ser_mysql.sh, for instance:

+------------+---------------+
| table_name | table_version |
+------------+---------------+
| subscriber |             5 |
+------------+---------------+


-Evan

Juan Carlos Castro y Castro wrote:
> I spiffied up the log message for "Invalid table version" and got the 
> output below. I'd guess the SELECT that gets table versions is failing 
> for some reason. Where would be the best place for me to log all SQL 
> queries that are being made?
> 
> Oct 11 15:49:42 localhost openser[8773]: Maxfwd module- initializing
> Oct 11 15:49:42 localhost openser[8773]: WARNING! This module is 
> experimental and may crash SER or create unexpected results. You use the 
> module at your own risk. Please submit bugs at http://bugs.sip-router.org/
> Oct 11 15:49:42 localhost openser[8773]: auth_db:str_fixup: Invalid 
> 'subscriber' table version 0 - should be 3 (use ser_mysql.sh reinstall)
> Oct 11 15:49:42 localhost openser[8773]: ERROR: fix_expr : fix_actions 
> error
> 
> 
> Juan Carlos Castro y Castro wrote:
> 
>> Any clues? I'm annexing the script I used to create the tables. I've 
>> downloaded the module from 
>> http://cvs.berlios.de/cgi-bin/viewcvs.cgi/ser/experimental/oracle/ and 
>> added it to OpenSER 0.9.5. The schema was adapted from OpenSER's 
>> mysqldb.sh -- notice how I had to let go of lots of "NOT NULL" because 
>> Oracle won't accept empty-string values in NOT NULL fields.
>>
>> Oct 11 15:25:22 localhost openser[6440]: Maxfwd module- initializing
>> Oct 11 15:25:22 localhost openser[6440]: WARNING! This module is 
>> experimental and may crash SER or create unexpected results. You use 
>> the module at your own risk. Please submit bugs at 
>> http://bugs.sip-router.org/
>> Oct 11 15:25:22 localhost openser[6440]: auth_db:str_fixup: Invalid 
>> table version (use ser_mysql.sh reinstall)
>> Oct 11 15:25:22 localhost openser[6440]: ERROR: fix_expr : fix_actions 
>> error 
> 
> _______________________________________________
> Serdev mailing list
> Serdev at iptel.org
> http://mail.iptel.org/mailman/listinfo/serdev