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: starting Archive Engines |
From: | James F Ross <[email protected]> |
To: | "Kasemir, Kay" <[email protected]> |
Cc: | "[email protected]" <[email protected]> |
Date: | Thu, 20 Jun 2013 15:45:42 -0400 |
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
>