Re: Having trooble setting up CSS archive engine with mySQL

[David Michel <dmichel76@googlemail.com>]

Just fixed it myself...

Granting the mysql user remote access privileges is not enough. There is a bind-address property in /etc/mysql/my.cnf to set to 0.0.0.0 to access remote connections from any IPs rather than the localhost default of 127.0.0.1

All good now, thanks!

On 14 December 2016 at 10:06, David Michel <dmichel76@googlemail.com> wrote:

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 <kasemirk@ornl.gov> wrote:

Hi:

> On Dec 13, 2016, at 4:57 AM, David Michel <dmichel76@googlemail.com> 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