This project has moved and is read-only. For the latest updates, please go here.

installing and configuring openPDC

Jul 11, 2013 at 4:55 PM
when I try to configure openPDC using (ConfigurationSetupUtility) I get the following

Attempting to set up the initial historian...
Unable to connect to any of the specified MySQL hosts.
Operation failed. Click the back button to try again.

any idea how to work around this problem?

thanks in advance
Karim
Jul 11, 2013 at 6:53 PM
Hello Karim,

I have a few questions to help narrow down the issue.
  1. What version of MySQL are you using?
  2. What version of MySQL Connector/NET are you using?
  3. On the setup screen where you are entering connection parameters for MySQL, there should be a button labeled "Advanced..." After you enter your information, can you click that button and copy the contents of the Connection String and Data Provider String text boxes, then paste them here so I can see them?
Thanks,
Stephen
Jul 11, 2013 at 9:18 PM
thanks Staphen for the replay,

Mysql 5.1.69

MySQL Connector Net 6.2.5

connection string : Allow User Variables=true; Server=localhost; Database=openPDC; Uid=root

data provider string :
AssemblyName={MySql.Data, Version=6.2.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d}; ConnectionType=MySql.Data.MySqlClient.MySqlConnection; AdapterType=MySql.Data.MySqlClient.MySqlDataAdapter

thanks
Karim
Jul 22, 2013 at 12:44 PM
I managed to solve the problem , I just changed the port number of mysql to its deafult value (3306).