Realtime SIP + Oracle

Asterisk Asterisk Support
1

Hi everyone!
We have a situation which is not being easy to solve.

We have already running Realtime Queue working with Oracle.
Now we want to use Realtime SIP too.

But, even after create the table in Oracle, Asterisk returns these erros:
[Sep 19 09:22:49] WARNING[3209]: res_config_odbc.c:1177 require_odbc: Realtime table SIPPEERS@asterisk_oracle requires column ‘name’, but that column does not exist!
[Sep 19 09:22:49] WARNING[3209]: res_config_odbc.c:1177 require_odbc: Realtime table SIPPEERS@asterisk_oracle requires column ‘ipaddr’, but that column does not exist!
[Sep 19 09:22:49] WARNING[3209]: res_config_odbc.c:1177 require_odbc: Realtime table SIPPEERS@asterisk_oracle requires column ‘port’, but that column does not exist!
[Sep 19 09:22:49] WARNING[3209]: res_config_odbc.c:1177 require_odbc: Realtime table SIPPEERS@asterisk_oracle requires column ‘regseconds’, but that column does not exist!
[Sep 19 09:22:49] WARNING[3209]: res_config_odbc.c:1177 require_odbc: Realtime table SIPPEERS@asterisk_oracle requires column ‘defaultuser’, but that column does not exist!
[Sep 19 09:22:49] WARNING[3209]: res_config_odbc.c:1177 require_odbc: Realtime table SIPPEERS@asterisk_oracle requires column ‘fullcontact’, but that column does not exist!
[Sep 19 09:22:49] WARNING[3209]: res_config_odbc.c:1177 require_odbc: Realtime table SIPPEERS@asterisk_oracle requires column ‘regserver’, but that column does not exist!
[Sep 19 09:22:49] WARNING[3209]: res_config_odbc.c:1177 require_odbc: Realtime table SIPPEERS@asterisk_oracle requires column ‘useragent’, but that column does not exist!
[Sep 19 09:22:49] WARNING[3209]: res_config_odbc.c:1177 require_odbc: Realtime table SIPPEERS@asterisk_oracle requires column ‘lastms’, but that column does not exist!

The columns exist and I’ve already tried a lot of changes to see if could get it working. And nothing with success so far.

Have anyone had a similar situation or can give some help?

Thanks in advance.

2

Just a guess, but with some database engines, the database, table, and field/column names are case-sensitive. Is the table name in the database in all caps?

3

I’ve tried in both formats… Upercase and lowercase…
Both table name and columns names.

4

Not finding all those columns usually means that the table couldn’t be found. Does the user in question have access to the table?

Can you use the isql tool logged in as the the same user Asterisk would use and do a select?

1 Like
5

You might try fully specifying the tablespace ie system, sys or user …

select name from system.emp where …

6

Can you post your extconfig.conf file?

7

Don’t know about sip, an aside pjsip+ realtime doesn’t work with oracle.

https://issues.asterisk.org/jira/browse/ASTERISK-25281
https://issues.asterisk.org/jira/browse/ASTERISK-25281