Connecting to mysql using ODBC

[actiondave]

Background: Currently using a predictive dialer with pri's.

Have Microsoft SQLServer installed and connected to database using microsoft access for front end and customized reporting.

I want to switch within a few months to Vicidial.

I have installed GoAutodial for testing (and will also install ViciBox) and compare. - probably go with ViciBox as it seems it will be easier to upgrade to newer versions. I have the system working for dialing outbound only using SIP.

My last step is to connect to the mysql databases using ODBC.

I am not very familiar with CentOs or PHP and need help if possible connecting to asterisk/vicidial databases using ODBC to create custom reporting.

Thanks for any help.

___________________________________

Test Machine Setup:

Intel Pentium 4 CPU 2.80GHz

GoAutoDial CE 2.1 is out!
Vicidial SVN 2.4-309a BUILD: 110430-1642
Asterisk 1.4.39.1-vici
Dahdi 2.4.1
CentOS 5.6

[Op3r]

Yes of course!

There are ways to connect to the VICIDIAL database as it uses mySQL.

I believe all you need is a driver for your database connection and also the host address and mysql login info.

If your reporting tool can connect to any mysql databases, then there is no way you cant connect to a vicidial database.

[actiondave]

Yes, I'm sure I can somehow. But not sure how to connect from my windows machine to the Vicidial server.

Does remote networking for mysql need to be turned on somehow to allow the odbc from my windows machine to connect?

And is the server 192.168.1.2 as is set with goautodial with port 3306?

just need a little extra help with this as I am very new with linux

-thanks for any help as I am stumped with this connection.

[Op3r]

yes

on default goautodial the username cron and pass 1234 can be used to connect to the mysql service remotely. This username is used by the vicidial for database asterisk.

[actiondave]

thanks for the help. as i kept "digging" around in goautodial i had to change the status of the firewall to accept the connection.

thanks again