V6.0 And Mysql

[mehdi_h]

Hi

 

Does the V6.0 support to dialout using mysql?

If yes is the connetion string the same as the V7.0?

 

 

Thank you.

 

Mh

[SupportTeam]

v6 does support external OutDial database sources, but if you are going to be using the external Dialout DB then we recommend using v7.

 

The connection strings will be different. v7 uses ADO.NET data providers string, whereas v6 uses DAO.

[mehdi_h]

Thank you.

 

following your previous advise, I have installed mysql on aother server on the same LAN as the VG server.(VG7)

I have setup the config.xml to point the the IP adresse of that new server. I have set the user id, and password in the database privilege but VG seems not to be able to open the connection.

 

Any Idea please ?

 

Tkx

Mh

 

db config OutDialQue_Database = sams

003900.125 5 db config OutDialQue_ConnectString = Database="$DATABASE";Data Source="192.168.1.126";User Id="moussa";Password="moussa";

003900.125 5 db config OutDialQue_SqlPrefix = SELECT

003900.125 5 db config OutDialQue_SqlSuffix = LIMIT 1

003900.125 5 db config OutDialQue_PortToUse_LinkField =

003900.125 5 db config zConfigXml_sDialer_OutDialQue_PortToUse_LinkField = ID (default for provider = MySql.Data.MySqlClient)

003900.125 5 0 vgDb_ProviderInvariant Db_Open call

003900.125 5 0 Db_Open GetFactory call [MySql.Data.MySqlClient]

003900.140 5 0 Db_Open sDbName=[sams]

003900.140 5 0 Db_Open CreateConnection call

003900.187 5 0 Db_Open CreateConnection returned. conn=MySql.Data.MySqlClient.MySqlConnection, this=ktlib.vgDb.vgDb_ProviderInvariant

003900.187 5 0 Db_Open sConnString [Database="$DATABASE";Data Source="192.168.1.126";User Id="moussa";Password="moussa";] => [Database="sams";Data Source="192.168.1.126";User Id="moussa";Password="moussa";]

003900.203 5 0 Db_Open conn.Open call

003915.250 5 0 Db_Open conn.Open : Unable to connect to any of the specified MySQL hosts.

003915.250 5 0 Db_CreateTables start. Database=[sams]

003915.250 5 0 sql create database command read from [C:\Program Files\VoiceGuide\system\setup\Db_Create_MySql.Data.MySqlClient.sql]

003915.250 5 dial CreateTableStructureSqlCommand:

CREATE TABLE CallQue

(

ID Int AUTO_INCREMENT PRIMARY KEY,

GUID BINARY(16),

PhoneNumber VARCHAR(100),

PhoneNumberPrefix VARCHAR(100),

ActivateTime DateTime,

AnswerTimeout Int,

CampaignName VARCHAR(100),

[SupportTeam]

Please .ZIP up and post the entire vgEngine trace capturing the system startup.

 

Are you able to confirm ADO.NET connectivity to the MySQL DB on 192.168.1.126 using any other app?

[mehdi_h]

got it! it was only a problem of port in the windows firewall.

had to open the 3306 port in the exception tab.

 

tkx you