[Asterisk-Users] res_odbc app_realtime

[Matthew Boehm]

You must have some old code. That is not RealTime enabled code that you
posted. RealTime works differently.

Matthew
----- Original Message ----- 
From: "Race Vanderdecken" <asterisk at vanderdecken.com>
To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"
<asterisk-users at lists.digium.com>
Sent: Monday, October 18, 2004 10:33 AM
Subject: RE: [Asterisk-Users] res_odbc app_realtime


> Hmmm,
>
> I have been working on similar. I thought that while some of the SIP
> information is in the database there are still parameters Asterisk is
> looking for in the sip.conf.
>
> Looking at the code just now chan_sip.c first looks to the sip.conf to
> obtain settings. Once Asterisk sip channel has opened sip.conf and is
> reading things the code then turns to the DB to read items. The DB reads
> are sprinkled around the file.
>
> Bad Example:
>
> /*--- find_user: Locate user by name */
> static struct sip_user *find_user(char *name)
> {
>         struct sip_user *u = NULL;
>
>         u = userl.users;
>         while(u) {
>                 if (!strcasecmp(u->name, name)) {
>                         break;
>                 }
>                 u = u->next;
>         }
> #ifdef MYSQL_USERS
>         if (!u) {
>                 u = mysql_user(name);
>         }
> #endif /* MYSQL_USERS */
>         return(u);
> }
>
>
> So, if sip.conf is not there, Asterisk will not read the DB tables,
> because the code to read the DB tables is inside the code to read the
> sip.conf information.
>
>
> I hope this helps.
>
> If you need code changes, please let me know. My fees are reasonable and
> I like doing very small, 4-40 hour, projects.
>
> Race Vanderdecken
>
>
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com
> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Michael
> Baird
> Sent: 15 October 2004 15:30
> To: asterisk-users at lists.digium.com
> Subject: [Asterisk-Users] res_odbc app_realtime
>
> Hello, I've been trying to move some of my static configs into a MySQL
> database. I have been trying with sip.conf and voicemail.conf, can't
> seem to get it to work although it says it is loading the config via
> res_odbc fine. Here's what I did, if someone can't point out my error, I
> would be grateful.
>
> Setup up UnixODBC, verified I could connect to my database through it,
> with the test application, all worked fine.
>
> I then setup res_odbc.conf in /etc/asterisk, like so
> [mysql]
> dsn => MySQL-voicemail
> username => dbuser
> password => dbpass
> pre-connect => yes
>
> I setup /etc/asterisk/extconfig.conf with the following info.
> [settings]
> ; file.conf => driver,database[,table]
> sip.conf => odbc,accounting,sipusers
>
> I removed sip.conf from /etc/asterisk
>
> I setup my database called accounting, with data in the table sipusers
>
> sipusers table layout
>
> name | host | context | ipaddr | port | regseconds | callerid | username
> | md5secret
>
> Then I start up asterisk with asterisk -vvvv and see the following
>
> Oct 15 15:18:54 NOTICE[1077037376]: config.c:556 ast_config_register:
> Registered Config Engine odbc
>   == Parsing '/etc/asterisk/extconfig.conf': Found
>   == Binding sip.conf to mysql/accounting/sipusers
> res_config_odbc loaded.
>
> Which looks good I think, until the end, and chan_sip.so fails to load
> and sip doesn't run.
>
> [chan_sip.so] => (Session Initiation Protocol (SIP))
>   == Parsing '/etc/asterisk/sip.conf': Not found (No such file or
> directory)
> Oct 15 15:23:21 NOTICE[1077037376]: chan_sip.c:8432 reload_config:
> Unable to load config sip.conf, SIP disabled
>
> I tried setting up voicemail.conf with similar errors, both voicemail
> and sip work fine when accessed from flatfiles.
>
> Regards
> Michael Baird
>
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>


----------------------------------------------------------------------------
----


> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users