Re: Having trooble setting up CSS archive engine with mySQL

["Kasemir, Kay" <kasemirk@ornl.gov>]

Hi:

> seeing this error when running the ArchiveConfigTool:
>    Caused by: java.net.ConnectException: Connection refused
>        at java.net.PlainSocketImpl.socketConnect(Native Method)     

> So, looks like it cannot connect to the database
Correct.

> I have set the database ip, port and db user/password in the plugin_customization.ini as such:
>org.csstudio.archive.rdb/url=jdbc:mysql://192.168.41.3:3306/archive     
>org.csstudio.archive.rdb/user=archive     
>org.csstudio.archive.rdb/password=archive      

Have you tried to connect with those parameters?

I.e. try

  mysql -h 192.168.41.3 -u archive -p 'archive' archive


Possible reasons why it might fail:
Maybe your Mysql doesn't allow remote connections, only 'localhost'.
The examples use '$archive' as a password, including that dollar sign, while you try it with just 'archive' as a password. Maybe that's the wrong password?

-Kay