EPICS Home EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

Format page
for printing


Search Tech-talk
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: "[email protected]" <[email protected]>
Date: Wed, 14 Dec 2016 10:06:09 +0000
Yes, and I have a user set up as such:

CREATE USER 'report'@'%' IDENTIFIED BY '$report';
GRANT ALL PRIVILEGES ON * . * TO 'report'@'%';

I would have thought the '%' allows this user account to access the database from any IP, right?

However, I still get an error when connecting from another machine:

mysql -h 192.168.41.3 -u report -p archive
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.41.3' (111)


David



On 13 December 2016 at 13:52, Kasemir, Kay <[email protected]> wrote:
Hi:

> On Dec 13, 2016, at 4:57 AM, David Michel <[email protected]> wrote:
> 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.

You will eventually need to configure your Mysql server to allow remote access.
You can of course configure the archive and execute the archive engine on the same machine that runs MySQL, but it’s likely that you’ll also want to look at the data, and the clients might not all run on that same host. So at least some read-only account needs to be added to provide read access.

-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
Re: Having trooble setting up CSS archive engine with mySQL Kasemir, Kay
Re: 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: OPI Display (workbench) ?? Patard Charles-Henri
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: Re: Having trooble setting up CSS archive engine with mySQL Kasemir, Kay
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 
ANJ, 14 Dec 2016 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·