[Devel] Trying Oracle module -- still struggling

[Juan Carlos Castro y Castro]

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