SnapArchiver execution error

General Installation
1

Hi,

I have installed Tango 8, well running, on Xubuntu.
I have installed ArchivingRoot 15.4.2, HDB and TDB, well running also.
To install the snap archiving and create the ‘snap’ data base, i execute the script $ARCHIVING_ROOT/db/create-SNAPDB-MyISAM.sql
No sample script for installation of snap DS furnished, so i have exported, from an existing and well running data base tango,
the selected properties from the ‘device’ ‘property_device’ and ‘property_class’ tables.
I precise that the snap archiving is well running on this another host..

While executing SnapArchiver, i have the following messages (see bellow 1-DS 2-Atkpanel) containing errors.
[i]For information :

  • SnapExtractor and SnapManager are running ok
  • i tried with different values : 127.0.0.1 (or localhost) , 127.0.1.1 (or pc-planck15 my hostname)..
  • i can only connect to the my sql server with host=localhost
    access authorized with «mysql -h localhost -u snapbrowser -p»
    access denied with «mysql -h pc-planck15 -u snapbrowser -p» whatever user is root, snapbrowser, snapmanager, snaparchiver…[/i]

Any idea, any help will be appreciated.
Thanks
JCM

1-execution of the DS

SnapArchiver() create archiving/snap/snaparchiver.1
################

Snapshot

################
Host from Device Properties : pc-planck15
Name from Device Properties : snap
Schema from Device Properties : snap
User from Device Properties : snaparchiver
Password from Device Properties : snaparchiver
Is Rac from Default : false
############################
DataBaseApi.connect_auto oracle: snaparchiver@pc-planck15
connection to oracle KO
DataBaseApi.connect_auto MySQL: snaparchiver@pc-planck15
mysql URL jdbc:mysql://pc-planck15/snap?autoReconnect=true
connection to MySQL KO
log4j:WARN No appenders could be found for logger (archiving/snap/snaparchiver.1).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See Apache log4j 1.2 - Frequently Asked Technical Questions for more info.
Ready to accept request

2-AtkPanel

Status dans ATKpanel de archiving/snap/snaparchiver.1 :

Message : ARCHIVING ERROR : : CONNECTION FAILED !
[1] :
Reason : Erreur d’E/S: The Network Adapter could not establish the connection
Severity : WARNING
Description : Erreur d’E/S: The Network Adapter could not establish the connection
Origin : java.sql.SQLRecoverableException
[2] :
Reason : Failed while executing DataBaseApi.connect_oracle() method…
Severity : PANIC
Description : The loggin parameters (host, database name, user, password) seem to be wrong…

  • URL: jdbc:oracle:thin:@pc-planck15:1521:snap
  • user: snaparchiver
  • password: snaparchiver
    Origin : java.sql.SQLRecoverableException
    [3] :
    Reason : Failed while executing DataBaseApi.connect_auto() method…
    Severity : PANIC
    Description : Failed while connecting to the Oracle archiving database
    Origin : fr.soleil.archiving.snap.api.tools.SnapshotingException
    [4] :
    Reason : Failed while executing DataBaseApi.connect_auto() method…
    Severity : PANIC
    Description : Failed while connecting to the archiving database
    Origin : fr.soleil.archiving.snap.api.tools.SnapshotingException
    [5] :
    Reason : Could not create connection to database server. Attempted reconnect 3 times. Giving up.
    Severity : WARNING
    Description : Could not create connection to database server. Attempted reconnect 3 times. Giving up.
    Origin : com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
    [6] :
    Reason : Failed while executing DataBaseApi.connect_mysql() method…
    Severity : PANIC
    Description : The loggin parameters (host, database name, user, password) seem to be wrong…
    Origin : com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
    [7] :
    Reason : Failed while executing DataBaseApi.connect_auto() method…
    Severity : PANIC
    Description : Failed while connecting to the MySQL archiving database
    Origin : fr.soleil.archiving.snap.api.tools.SnapshotingException
    [8] :
    Reason : Failed while executing DataBaseApi.connect_auto() method…
    Severity : PANIC
    Description : Failed while connecting to the archiving database
    Origin : fr.soleil.archiving.snap.api.tools.SnapshotingException
2

Hi,

we solved the issue by setting dbHost properties to ‘localhost’ into the SnapArchiver class and the SnapArchiver device.
However, it does not satisfy us, since it seems to us that :

  • either dbHost is a constant set to ‘localhost’
  • or dbHost is a variable and we should be able to change it.

So, in the second case, we would like to understand what it the meaning of dbHost ? In particular, it could be used to specify a host for running remote devices or mambo.

Thanks,
JCM

3

This issue can be caused by an incorrect import of snap database from a former installed database.
It could probably be solved with a script to install SNAP DS from scratch.

Actually, a script is given to install HDB DS into ArchivingRoot/doc/sample-hdb-device-installation.sql

There is very few documentation for ArchivingRoot, It would be more usable if similar scripts were given for TDB and SNAP. Does anyone has something like this ?
Thank you.

4

Hi Philippe,

i don’t think so because i had also to force this dbHost in the 2 classes HdbArchiver and TdbArchiver (i well used scripts given in the documentation for ArchivingRoot).
So it is not a problem caused by an incorrect import from a former installed database.

Is there really nobody with any idea ?
Thanks,
JCM

5

Does anyone has any idea how to solve this dbHost issue ?
How should one configure dbHost with Snap archiving system ?

6

it concerns also HDB and TDB archiving systems because i had also to force this dbHost in the 2 classes HdbArchiver and TdbArchiver.

Any idea, any help will be appreciated.
Thanks
JCM

7

Hello. Sorry for the late answer.

First, a reminder:
Concerning snapshot database, the connection information, except for user/password, are read from the SnapManager class properties (whereas it is read from Hdb/Tdbarchiver class properties for HDB/TDB). So, this is where you should write DbHost.

Then, the devices will try to connect to an Oracle database and, if it fails, to a MySQL one (because they don’t know what kind of database it is).

In your case, none of the 2 attempts did work. It seems to work with localhost only, so my first question would be : are you sure to have authorized the communication ports from/to external calls ? Because my first guess is a firewall problem.

Anyway, don’t hesitate to contact me directly by email: raphael.girardot@synchrotron-soleil.fr.
This way, you could send me your device/class properties so that I can help you understanding why it does not work…

Regards,

8

Hi Raphael,

[quote=“girardot”]Hello. Sorry for the late answer.

First, a reminder:
Concerning snapshot database, the connection information, except for user/password, are read from the SnapManager class properties (whereas it is read from Hdb/Tdbarchiver class properties for HDB/TDB). So, this is where you should write DbHost.

[/quote]

it concerns also HDB and TDB archiving systems because i had also to force this dbHost to ‘localhost’ in the 2 HdbArchiver and TdbArchiver classes.
And, for SNAP, i had to force this dbHost to ‘localhost’ into the SnapArchiver class and also in the SnapArchiver device.

[quote=“girardot”]Then, the devices will try to connect to an Oracle database and, if it fails, to a MySQL one (because they don’t know what kind of database it is).

[/quote]

OK, use of a MySQL db so it goes directly to second step.

[quote=“girardot”]In your case, none of the 2 attempts did work. It seems to work with localhost only, so my first question would be : are you sure to have authorized the communication ports from/to external calls ? Because my first guess is a firewall problem.

[/quote]

by checking iptables, no firewall restrictions are registered.
Moreover, all authorizations are given for all hosts in the basic ArchivingRoot configuration file $ARCHIVINGROOT/db/create-SNAPDB-MyISAM.sql

[quote=“girardot”]
Anyway, don’t hesitate to contact me directly by email: raphael.girardot@synchrotron-soleil.fr.
This way, you could send me your device/class properties so that I can help you understanding why it does not work…

Regards,[/quote]

Thanks, i send you, by mail, all the config/install files

9

Hello again.

I searched the information about how the mysql database was configured at soleil, and I found some intersting information, which I guess will help you in your case:

When the mysql database was first installed at soleil, there were some connection problems too.
The solution was to modify the my.cnf in order to allow external connections:

  • comment skip-networking
  • add new parameter bind-address = 0.0.0.0
10

Effectively seems running well by setting the bind-address to 0.0.0.0 value in /etc/mysql/my.cnf.

It is written in the official documentation of MySql that bind-address = * allows any connection IPv4 and IPv6.
So i modified in this way the bind-address.
Running well also !

Thanks a lot !