Experimental Physics and
Industrial Control System

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

Replies:

Re: Having trooble setting up CSS archive engine with mySQL David Michel

References:

Having trooble setting up CSS archive engine with mySQL David Michel

Navigate by Date:

Prev: Re: 答复: 答复: MVME5500 and turbo-pmac-vme-ultralite Oleg A. Makarov

Next: Re: Having trooble setting up CSS archive engine with mySQL David Michel

Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <2016>  2017  2018  2019  2020  2021  2022  2023  2024 

Navigate by Thread:

Prev: Having trooble setting up CSS archive engine with mySQL David Michel

Next: Re: Having trooble setting up CSS archive engine with mySQL David Michel

Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <2016>  2017  2018  2019  2020  2021  2022  2023  2024