asterisk users - Aug 2005 - odbc realtime update problem

I'm experimenting with realtime (CVS HEAD), but using odbc to a 
third-party database (progress) instead of mysql.

Following the instructions on voip-info, I created a table for voicemail 
called rtvm with the following fields:

CREATE TABLE `rtvm` (
  `uniqueid` int(11) NOT NULL auto_increment,
  `customer_id` int(11) NOT NULL default '0',
  `context` varchar(50) NOT NULL default '',
  `mailbox` int(5) NOT NULL default '0',
  `password` varchar(4) NOT NULL default '0',
  `fullname` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `pager` varchar(50) NOT NULL default '',
  `stamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`uniqueid`),
  KEY `mailbox_context` (`mailbox`,`context`)
) ;

I manually created a record in the database and fired up asterisk. Wow! 
it actually worked !

But. (There had to be a but) - when it came to update, there was a 
problem. If I tried to change the password, I got an error, and the 
database was not updated:

update_odbc : SQL execute error

After an afternoon of chasing all sorts of dead-ends (permissions etc) I 
finally changed the uniqueid from an int to a character field, and it 
all updates ok now.

Now, is this a problem with res_odbc, the linux odbc client or the sql 
server itself ?

Julian.

Julian Lyndon-Smith wrote:
> After an afternoon of chasing all sorts of dead-ends (permissions etc) I 
> finally changed the uniqueid from an int to a character field, and it 
> all updates ok now.
> 
> Now, is this a problem with res_odbc, the linux odbc client or the sql 
> server itself ?
	Must be cause I am using res_config_mysql and my uniqueid field is an 
INT and everything works great.

-Matthew

Hi,

I am having problems on getting the second line to work on a Polycom 301,

this is the phone.cfg file,
the * box is 192.168.1.8 and the phone is 192.168.1.18
I am not 100% sure about what the reg.x.address should be,
with this setting I only get the line number to work,
the second just gives me busy signal, and its extension is not available.
I also tried 203@192.168.1.18 and 203 as the reg.2.address parameter but 
without success,
the 203 extension setting in Asterisk is a clon of the 200 except for 
the id and the port, (that matches this conf file)


<PHONE_CONFIG>
        <OVERRIDES
        reg.1.displayName="FD1"
        reg.1.label="L1"
        reg.1.address="192.168.1.18"
        reg.1.server.1.address="192.168.1.8"
        reg.1.server.1.port="5060"
        reg.1.auth.userId="200"
        reg.1.auth.password="123"
        reg.2.displayName="FD2"
        reg.2.label="L2"
        reg.2.address="203@192.168.1.18"
        reg.2.auth.userId="203"
        reg.2.auth.password="123"
        reg.2.server.1.address="192.168.1.8"
        reg.2.server.1.port="5061"/>
</PHONE_CONFIG>

Thanks for any help,

Andres

Is your Asterisk server listening on port 5061? If not, just change the
entry to 5060.

On Wed, 2005-08-31 at 16:36 -0600, Andres Paglayan
wrote:
> Hi,
> 
> I am having problems on getting the second line to work on a Polycom 301,
> 
> this is the phone.cfg file,
> the * box is 192.168.1.8 and the phone is 192.168.1.18
> I am not 100% sure about what the reg.x.address should be,
> with this setting I only get the line number to work,
> the second just gives me busy signal, and its extension is not available.
> I also tried 203@192.168.1.18 and 203 as the reg.2.address parameter but 
> without success,
> the 203 extension setting in Asterisk is a clon of the 200 except for 
> the id and the port, (that matches this conf file)
> 
> 
> <PHONE_CONFIG>
>         <OVERRIDES
>         reg.1.displayName="FD1"
>         reg.1.label="L1"
>         reg.1.address="192.168.1.18"
>         reg.1.server.1.address="192.168.1.8"
>         reg.1.server.1.port="5060"
>         reg.1.auth.userId="200"
>         reg.1.auth.password="123"
>         reg.2.displayName="FD2"
>         reg.2.label="L2"
>         reg.2.address="203@192.168.1.18"
>         reg.2.auth.userId="203"
>         reg.2.auth.password="123"
>         reg.2.server.1.address="192.168.1.8"
>         reg.2.server.1.port="5061"/>
> </PHONE_CONFIG>
> 
> Thanks for any help,
> 
> Andres
> 
> _______________________________________________
> --Bandwidth and Colocation sponsored by Easynews.com --
> 
> Asterisk-Users mailing list
> Asterisk-Users@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