EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

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

Subject: Re: Having trooble setting up CSS archive engine with mySQL
From: David Michel <[email protected]>
To: "Kasemir, Kay" <[email protected]>
Cc: EPICS mailing list <[email protected]>
Date: Tue, 13 Dec 2016 09:57:11 +0000
Ha! the password was indeed wrong... it worked fine with the added $archive... silly mistake!

Another thing: the config and engine tool are used on the same machine as where the database is running - I had to change the org.csstudio.archive.rdb/url setting to use 'localhost' rather than the machine's actual IP address to make it work.

Many thanks
David



On 12 December 2016 at 17:41, Kasemir, Kay <[email protected]> wrote:
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 Kasemir, Kay
References:
Having trooble setting up CSS archive engine with mySQL David Michel
Re: Having trooble setting up CSS archive engine with mySQL Kasemir, Kay

Navigate by Date:
Prev: Re: Having trooble setting up CSS archive engine with mySQL Kasemir, Kay
Next: Re: Having trooble setting up CSS archive engine with mySQL Kasemir, Kay
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <20162017  2018  2019  2020  2021  2022  2023  2024 
Navigate by Thread:
Prev: Re: Having trooble setting up CSS archive engine with mySQL Kasemir, Kay
Next: Re: Having trooble setting up CSS archive engine with mySQL Kasemir, Kay
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <20162017  2018  2019  2020  2021  2022  2023  2024 
ANJ, 13 Dec 2016 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·