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 | 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 |
<== 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 |
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 Have you tried to connect with those parameters?
>org.csstudio.archive.rdb/password=archive
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