Problème d'installation et d'initialisation de base de données

waarpr66
Tags: #<Tag:0x00006ee8ec1c2958>

(alaa) #1

Bonjour,

J’ai installé le serveur waarp-r66server via les archives autonomes sur un serveur Centos 7, j’ai réussi à déployer les serveurs waarp (server1 et server 2 comme dans la demo).
Par contre, je n’ai pas trouvé de la doc pour installer le GatewayFTP waarp à partir des archives.

De ce fait, j’ai essayé l’installation par le dépôt RHEL 6 des package rpm. Sauf qu’après l’installation des packages, et quand j’essaie d’initialiser la base de données :
waarp-r66server server1 initdb

J’ai ce type d’erreurs dans la log :

13/12/2018/10:07:44.916 ERROR [org.waarp.common.database.DbSession] [main] org.waarp.common.database.DbSession.error(DbSession.java:275) : SQLException: NULL not allowed for column “BUSINESS”; SQL statement:
INSERT INTO HOSTCONFIG (BUSINESS,ROLES,ALIASES,OTHERS,UPDATEDINFO,HOSTID) VALUES (?,?,?,?,?,?) [23502-197] SQLState: 23502VendorError: 23502
13/12/2018/10:07:44.917 ERROR [org.waarp.common.database.DbRequest] [main] org.waarp.common.database.DbRequest.select(DbRequest.java:124) : SQL Exception Request:select TRANSFERINFO from RUNNER where SPECIALID = -9223372036854775808 Table “RUNNER” not found; SQL statement:
select TRANSFERINFO from RUNNER where SPECIALID = -9223372036854775808 [42102-197]
13/12/2018/10:07:44.918 ERROR [org.waarp.common.database.DbSession] [main] org.waarp.common.database.DbSession.error(DbSession.java:275) : SQLException: Table “RUNNER” not found; SQL statement:
select TRANSFERINFO from RUNNER where SPECIALID = -9223372036854775808 [42102-197] SQLState: 42S02VendorError: 42102
13/12/2018/10:07:44.919 ERROR [org.waarp.common.database.DbRequest] [main] org.waarp.common.database.DbRequest.query(DbRequest.java:191) : SQL Exception Request:ALTER TABLE RUNNER ADD COLUMN IF NOT EXISTS TRANSFERINFO LONGVARCHAR NOT NULL DEFAULT ‘{}’ AFTER FILEINFO Table “RUNNER” not found; SQL statement:
ALTER TABLE RUNNER ADD COLUMN IF NOT EXISTS TRANSFERINFO LONGVARCHAR NOT NULL DEFAULT ‘{}’ AFTER FILEINFO [42102-197]
13/12/2018/10:07:44.920 ERROR [org.waarp.common.database.DbSession] [main] org.waarp.common.database.DbSession.error(DbSession.java:275) : SQLException: Table “RUNNER” not found; SQL statement:
ALTER TABLE RUNNER ADD COLUMN IF NOT EXISTS TRANSFERINFO LONGVARCHAR NOT NULL DEFAULT ‘{}’ AFTER FILEINFO [42102-197] SQLState: 42S02VendorError: 42102
13/12/2018/10:07:44.921 ERROR [org.waarp.openr66.server.ServerInitDatabase] [main] org.waarp.openr66.server.ServerInitDatabase.upgradedb(ServerInitDatabase.java:289) : Database schema is not up to date: you must run ServerInitDatabase with the option -upgradeDb
13/12/2018/10:07:44.921 ERROR [org.waarp.openr66.configuration.FileBasedConfiguration] [main] org.waarp.openr66.configuration.FileBasedConfiguration.setConfigurationInitDatabase(FileBasedConfiguration.java:2138) : Cannot load Database configuration
13/12/2018/10:07:44.921 ERROR [org.waarp.openr66.server.ServerInitDatabase] [main] org.waarp.openr66.server.ServerInitDatabase.main(ServerInitDatabase.java:122) : Needs a correct configuration file as first argument

Sachant, que j’ai pris les mêmes fichier que la démo et je n’ai pas obtenu ces erreurs lors de la configuration avec les archives autonomes.

Pourriez-vous m’aider à résoudre ce problème SVP?
Merci de votre retour.

Cordialement,


(Bruno Carlin) #2

Bonsoir,

Quel SGBD utilisez vous ?
Pouvez vous poster le bloc <db>...</db> du fichier de confiuration server.xml de votre serveur (fichier /etc/waarp/conf.d/server1/server.xml) ?

Merci


(alaa) #3

Bonjour,

J’ai gardé la base H2 par défaut, voici le contenu de server.xml (Server1) :

<config>
  <identity>
    <hostid>server1</hostid>
    <sslhostid>server1-ssl</sslhostid>
    <cryptokey>/etc/waarp/certs/cryptokey.des</cryptokey>
    <authentfile></authentfile>
  </identity>
  <server>
    <serveradmin>admin</serveradmin>
    <serverpasswd>5a4b7c6a66065cbb622acefec8c3a302</serverpasswd>
    <usenossl>true</usenossl>
    <usessl>true</usessl>
    <httpadmin>/usr/share/waarp/r66-admin</httpadmin>
    <admkeypath>/etc/waarp/certs/adminkey.jks</admkeypath>
    <admkeystorepass>password</admkeystorepass>
    <admkeypass>password</admkeypass>
    <checkaddress>False</checkaddress>
    <checkclientaddress>False</checkclientaddress>
    <multiplemonitors>1</multiplemonitors>
  </server>
  <network>
    <serverport>6666</serverport>
    <serversslport>6667</serversslport>
    <serverhttpport>8067</serverhttpport>
    <serverhttpsport>8066</serverhttpsport>
  </network>
  <ssl>
    <keypath>/etc/waarp/certs/key.jks</keypath>
    <keystorepass>password</keystorepass>
    <keypass>password</keypass>
    <trustkeypath>/etc/waarp/certs/trustkey.jks</trustkeypath>
    <trustkeystorepass>password</trustkeystorepass>
    <trustuseclientauthenticate>True</trustuseclientauthenticate>
  </ssl>
  <directory>
    <serverhome>/var/lib/waarp/server1</serverhome>
    <in>in</in>
    <out>out</out>
    <arch>arch</arch>
    <work>work</work>
    <conf>conf</conf>
  </directory>
  <rest>
    <restaddress>127.0.0.1</restaddress>
    <restport>8088</restport>
    <restssl>true</restssl>
    <restauthenticated>true</restauthenticated>
    <resttimelimit>3000</resttimelimit>
    <restsignature>true</restsignature>
    <restsigkey>/etc/waarp/certs/restsigning.key</restsigkey>
    <restmethod>
      <restname>ALL</restname>
      <restcrud>CRUD</restcrud>
    </restmethod>
    <restmethod>
      <restname>Bandwidth</restname>
      <restcrud>CRUD</restcrud>
    </restmethod>
    <restmethod>
      <restname>Information</restname>
      <restcrud>CRUD</restcrud>
    </restmethod>
    <restmethod>
      <restname>Server</restname>
      <restcrud>CRUD</restcrud>
    </restmethod>
    <restmethod>
      <restname>Control</restname>
      <restcrud>CRUD</restcrud>
    </restmethod>
  </rest>
  <limit>
    <serverthread>8</serverthread>
    <clientthread>80</clientthread>
    <memorylimit>4000000000</memorylimit>
    <runlimit>10000</runlimit>
    <delaycommand>5000</delaycommand>
    <delayretry>10000</delayretry>
    <timeoutcon>10000</timeoutcon>
  </limit>
  <db>
    <dbdriver>h2</dbdriver>
    <dbserver>jdbc:h2:/var/lib/waarp/server1/db/waarp;MODE=ORACLE;AUTO_SERVER=TRUE</dbserver>
    <dbuser>waarp</dbuser>
    <dbpasswd>waarp</dbpasswd>
  </db>
    <business>
        <businessid>fw-client</businessid>
    </business>
</config>