Hello,
I am trying to use Asulpunto Unicentaopos to integrate my local Point Of Sale software with my Magento website.
I have installed the extension with no issues. However, I can't seem to get it to connect to my database. I know the connection to the database is okay from my server, as I used a PHP script to query my database from my server and it works fine.
I am formatting my hostname in two different ways:
123.456.78.90:3306
With this configuration, I get this set of errors:
2017-03-22T12:55:57+00:00 DEBUG (7): Asulpunto_Unicentaopos_Model_Unicentaoposapi::_checkApplicationTest Connection Failed
2017-03-22T13:03:23+00:00 DEBUG (7): Asulpunto_Unicentaopos_Helper_Data::getUnicentaOposConnection ERROR Getting Connetion URL:123.456.78.90:3306 DBNAME:unicenta Login:unicenta Password:mypassword
2017-03-22T13:03:23+00:00 DEBUG (7): Asulpunto_Unicentaopos_Helper_Data::getUnicentaOposConnectionSQLSTATE[HY000] [2005] Unknown MySQL server host '123.456.78.90:3306' (2)
2017-03-22T13:03:27+00:00 DEBUG (7): Asulpunto_Unicentaopos_Model_Unicentaoposapi::checkActivateSHOW TABLES: IS EMPTY
2017-03-22T13:04:35+00:00 DEBUG (7): Asulpunto_Unicentaopos_Model_Unicentaoposapi::checkActivateSHOW TABLES: Array
123.456.78.90
With this configuration, I get this error:
2017-03-22T13:06:21+00:00 DEBUG (7): Asulpunto_Unicentaopos_Model_Unicentaoposapi::_checkApplicationTest Connection Failed
Again, I am able to connect to the database from my server with no issues outside of Magento.
Any and all suggestions would be great!
