Experimental Physics and
Industrial Control System

If you run

 ArchiveEngine

and

 ArchiveConfigTool

they use the RDB URL, user, password that's in their built-in plugin_customization.ini.


You best create a settings.ini with your RDB URL, user, password, then call both with

 ArchiveEngine -pluginCustomization /path/to/those/settings.ini -engine ...
 ArchiveConfigTool -pluginCustomization /path/to/those/settings.ini -engine ...

That way, you're sure they talk to the same RDB.



In MySQL, "show databases" should list "archive" as one.
"show engines" might show you what database engines your MySQL setup supports (InnoDB, MyISAM, …).

To dump the engine info from the RDB in MySQL, use

  SELECT * FROM smpl_eng;

Refer to the org.csstudio.archive.rdb/dbd/mysql_schema.txt that you used to create the tables for more.


Still, if you say "I can see it at localhost:4913/main.": Does it list the groups and channels that you wanted to configure?
But they're all disconnected?

-> Then you probably need to set the EPICS CA addr list in your settings.ini

org.csstudio.platform.libs.epics/addr_list=127.0.0.1

is the default, will only look on the local host.

-Kay

On Jun 20, 2013, at 11:39 AM, James F Ross <[email protected]> wrote:
> Hello all,
> I've managed to start an RDB archive engine using an xml file from the old channel archiver setup at STAR.
>
> However, I feel like I'm doing something wrong.  The engine runs on the command line and none of the channels are connected, though I can see it at localhost:4913/main.
>
> Here is how I start it: ./ArchiveEngine -engine CANbusRDB -port 4913
>
> The SNS site documentation has -rdb_url, -rdb_user, and -rdb_password listed as options that should be used, but none of those are listed when I do ArchiveEngine -help and they throw an error when I use them to run the engine. I think they are built in to the plugin_customization.ini file for org.csstudio.archiver.engine, but they may still be needed on the command line.
>
> Another bit of information is that I can't see this engine or RDB when I do a "show engines" or "show databases" from the archive user on mysql.  Perhaps I'm missing something that makes it run on mysql.
>
> Thanks
> James
>