[asterisk-users] Help Please - Asterisk MYSQL interface seems to be eating data

[Al Baker]

I must be overlooking it, I pulled up the electronic version and 
searched for and read every instance where ODBC was mentioned and I 
could not find a single place where it said
ODBC was to be the only or even the best method.  If so I would never 
ever have gone down this road :(

Quote "And according to the O'Reilly book ODBC is the way to go."

Roderick A. Anderson wrote:
> Steve Totaro wrote:
>   
>> A quote from Tilghman Lesher from a previous post.
>>
>> "That's fine, but I have had the most horrid results using any distribution-
>> supplied ODBC drivers.  The best results are obtained by source-compiling
>> the latest ODBC drivers, whether they be the MySQL ODBC Connector 3.51 or
>> PsqlODBC.  UnixODBC is fairly safe to use from distribution channels, however."
>>     
>
> And according to the O'Reilly book ODBC is the way to go.
>
> Though they use PostgreSQL for their examples and Asterisk is installed 
> on a CentOS system the instructions are really good.  Getting it to work 
> with MySQL should be pretty simple and I'm sure on-line resources for 
> doing this are be out there.
>
> <soapbox>
> Personally I never use MySQL except in cases where I am under extreme 
> duress.  Therefore I tried and tossed trixbox, AsteriskNOW, and 
> freeePBX.  Yes I know I can get around the database engine issue but 
> that is what a distribution should be for: no hacking (or at least 
> not-too-much) required.
>
> It is now CentOS 5, Asterisk from source, PostgreSQL (on another system) 
> and hand edited (for now anyway) *.conf files.  Maybe AsteriskGUI later.
> </soapbox>
>
>
> Rod
>