I’m having trouble connecting to a remote db. I setup a MySQL db on my blue host account that I’m hoping I can get asterisk to save the CDR to. I’ve entered what I think are the correct parameters but am getting an error message.
My odic.ini looks like this:
Description = MySQL connection to ‘asterisk’ database
Driver = MySQL
Database = snapfoot_asterisk
Server = 69.xx.xx.xxx
UserName = xxxxxxx
Password = xxxxxxx
Port = 3306
Socket = /var/lib/mysql/mysql.sock
I get this error when I type command: isql -v asterisk-connector
[S1000][unixODBC][MySQL][ODBC 5.1 Driver]Access denied for user ‘root’@‘174-XX-X-XX.spkn.qwest.net’ (using password: YES)
[ISQL]ERROR: Could not SQLConnect
I’ve also just logged into the phpMyAdmin in my Bluehost panel with the exact user and password, so those are good.
And thanks for all the help you guys have been giving, I’ve been in the world of Asterisk/ Linux for only about two weeks now, a lot to wrap my head around. You guys have been great!