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

[Juan Carlos Castro y Castro]

I do have that table. I replicated everything from mysqldb.sh -- look:

----------------------------------------------------------------------
[root at asterisk1 openser-0.9.5]# sqlplus openser/MYPASSWORD at astoracle

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 11 16:28:29 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from version where table_name = 'subscriber';

TABLE_NAME                                                       
TABLE_VERSION
---------------------------------------------------------------- 
-------------
subscriber                                                                   
5

SQL>
----------------------------------------------------------------------

Evan Borgstrom wrote:

>
>     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
>
>