Impossible sh Restore.db Servicedesk
Hi,
I've tried to restore a database from the old server debian 8.5 32 bits to a new server Debian 8.5 32 bits .. but I didn't get any result.
Can you help me ? I'm still looking for the solution.
I copy the console comands here.
I hope your answer as soon as possible, thx
root@HD:/opt/ServiceDesk/bin# sh restoreData.sh -c /opt/ServiceDesk/backup/backup_postgres_9241_database_02_09_2017_19_15/backup_postgres_9241_database_02_09_2017_19_15_part_1.data
*********************************************************************************
Restore DB Setup Wizard
*********************************************************************************
Execute Restore DB Utility from command prompt
For Windows users :
bin>restoreData -c [backup file]
For Linux users :
bin]#sh restoreData.sh -c [backup file]
*********************************************************************************
FYI [SEVERE]: Please don't kill this utility until the operation is completed
feb 10, 2017 4:52:49 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
Información: rootDir :: /opt/ServiceDesk/../
Exception while forming the url: null and getting the stream. /opt/ServiceDesk/../server/default/conf/buildInfo.xml (No existe el fichero o el directorio)
java.io.FileNotFoundException: /opt/ServiceDesk/../server/default/conf/buildInfo.xml (No existe el fichero o el directorio)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at sun.net.www.protocol.file.FileURLConnection.connect(Unknown Source)
at sun.net.www.protocol.file.FileURLConnection.getInputStream(Unknown Source)
at java.net.URL.openStream(Unknown Source)
at com.adventnet.nms.util.XMLDataReader.load(XMLDataReader.java:260)
at com.adventnet.nms.util.XMLDataReader.load(XMLDataReader.java:306)
at com.adventnet.nms.util.XMLDataReader.<init>(XMLDataReader.java:67)
at com.adventnet.servicedesk.server.utils.CommonUtil.getNode(CommonUtil.java:24)
at com.adventnet.servicedesk.server.utils.SDDataManager.readBuildData(SDDataManager.java:96)
at com.adventnet.servicedesk.server.utils.SDDataManager.<init>(SDDataManager.java:66)
at com.adventnet.servicedesk.server.utils.SDDataManager.getInstance(SDDataManager.java:85)
at com.adventnet.servicedesk.tools.RestoreSDBackupUtil.<init>(RestoreSDBackupUtil.java:91)
at com.adventnet.servicedesk.tools.RestoreSDBackup.<init>(RestoreSDBackup.java:99)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:115)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:323)
/opt/ServiceDesk/../server/default/conf/buildInfo.xml (No existe el fichero o el directorio)
java.lang.NullPointerException
at com.adventnet.servicedesk.server.utils.CommonUtil.getNode(CommonUtil.java:36)
at com.adventnet.servicedesk.server.utils.CommonUtil.getNode(CommonUtil.java:25)
at com.adventnet.servicedesk.server.utils.SDDataManager.readBuildData(SDDataManager.java:96)
at com.adventnet.servicedesk.server.utils.SDDataManager.<init>(SDDataManager.java:66)
at com.adventnet.servicedesk.server.utils.SDDataManager.getInstance(SDDataManager.java:85)
at com.adventnet.servicedesk.tools.RestoreSDBackupUtil.<init>(RestoreSDBackupUtil.java:91)
at com.adventnet.servicedesk.tools.RestoreSDBackup.<init>(RestoreSDBackup.java:99)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:115)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:323)
java.lang.NullPointerException
at com.adventnet.servicedesk.server.utils.CommonUtil.getNodeAsHash(CommonUtil.java:70)
at com.adventnet.servicedesk.server.utils.SDDataManager.readBuildData(SDDataManager.java:97)
at com.adventnet.servicedesk.server.utils.SDDataManager.<init>(SDDataManager.java:66)
at com.adventnet.servicedesk.server.utils.SDDataManager.getInstance(SDDataManager.java:85)
at com.adventnet.servicedesk.tools.RestoreSDBackupUtil.<init>(RestoreSDBackupUtil.java:91)
at com.adventnet.servicedesk.tools.RestoreSDBackup.<init>(RestoreSDBackup.java:99)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:115)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:323)
feb 10, 2017 4:52:50 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
Información: Going to set the standAlone param as : true
feb 10, 2017 4:52:50 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
Información: Going to reset rootDir using server.dir
Are you restoring this data in 'Production build' ?: Type 'Y' (or) 'N'. To cancel the restore type 'Q' and Enter ::y
Extracting backup file....
feb 10, 2017 4:52:52 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
Información: rootDir :: .
feb 10, 2017 4:52:52 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
Información: netutilsData :: {RELEASE={version=9.2}, BUILD={number=9241}}
feb 10, 2017 4:52:52 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
Información: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager Plus}}
Please wait extracting backup file
Please wait extracting backup file
feb 10, 2017 4:52:59 PM com.zoho.framework.utils.FileUtils copyFile
Información: Entered into copyFile :: sourceFile :: [./server/default/conf/SnmpConfigurations.xml], destinationFile :: [./server/default/conf/SnmpConfigurations_1486741979388.xml]
feb 10, 2017 4:52:59 PM com.zoho.framework.utils.FileUtils copyFile
Información: Entered into copyFile :: sourceFile :: [./SnmpConfigurations.xml], destinationFile :: [./server/default/conf/SnmpConfigurations.xml]
*************************************************************./backup_info.xml
Backpup data : Thu Feb 09 19:15:30 CET 2017
Database name : servicedesk
Total Tables : 1434
Database Server : postgres
Build Number : 9241
Backupid : 1486664130106
*************************************************************
feb 10, 2017 4:52:59 PM com.adventnet.persistence.service.DatabaseFactory loadConfigurationAndPopulateAsPersistenceConfigurations
Información: DataSourceConfiguration file URL is file:/opt/ServiceDesk/./server/default/conf/datasource-configuration.xml
feb 10, 2017 4:52:59 PM com.adventnet.persistence.service.DatabaseFactory loadConfigurationAndPopulateAsPersistenceConfigurations
Información: Service file URL is file:/opt/ServiceDesk/./server/default/conf/jboss-service.xml
feb 10, 2017 4:53:06 PM com.adventnet.persistence.service.DatabaseFactory getDSProperties
Información: Coming Out of getDSProperties
feb 10, 2017 4:53:06 PM com.adventnet.persistence.service.DatabaseFactory validateDataSource
Información: connectionURL :: jdbc:postgresql://localhost:65432/servicedesk
feb 10, 2017 4:53:06 PM com.adventnet.persistence.PersistenceInitializer getDBParamsFilePath
Información: Reading null/conf/database_params.conf
feb 10, 2017 4:53:06 PM com.adventnet.ds.DefaultDataSourcePlugIn initialize
Información: ConnectionPoolParams :: minSize :: [20], maxSize :: [1], idleTimeout :: [1.800 seconds], blockingTimeout :: [30 seconds]
feb 10, 2017 4:53:06 PM com.adventnet.ds.DefaultDataSourcePlugIn getDataSource
Información: DataSourceorg.jboss.resource.adapter.jdbc.WrapperDataSource@1704745
feb 10, 2017 4:53:06 PM com.adventnet.persistence.PersistenceInitializer createArchiveAdapter
Información: Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter
feb 10, 2017 4:53:06 PM com.adventnet.persistence.PersistenceInitializer createArchiveAdapter
Información: Storage Adapter class ::: null
feb 10, 2017 4:53:06 PM com.adventnet.db.api.RelationalAPI <clinit>
Grave: haltjvm.on.dbcrash is set to [false]
feb 10, 2017 4:53:06 PM com.adventnet.db.adapter.Jdbc20DBAdapter getShutDownStrings
Información: shutDownStrings :: []
feb 10, 2017 4:53:06 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
Información: Loading the function patterns from the file :: [null/conf/Persistence/postgres_functionpatterns.txt]
feb 10, 2017 4:53:06 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
Grave: Exception occurred while parsing the file :: [null/conf/Persistence/postgres_functionpatterns.txt]
java.io.FileNotFoundException: null/conf/Persistence/postgres_functionpatterns.txt (No existe el fichero o el directorio)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20DBAdapter.java:2057)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.java:213)
at com.adventnet.db.adapter.postgres.PostgresDBAdapter.initialize(PostgresDBAdapter.java:116)
at com.adventnet.persistence.PersistenceInitializer.initializeRelationalAPI(PersistenceInitializer.java:447)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:466)
at com.adventnet.persistence.PersistenceInitializer.initializeDBAndDBProps(PersistenceInitializer.java:339)
at com.adventnet.persistence.service.DatabaseFactory.startDB(DatabaseFactory.java:568)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:290)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:116)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:323)
feb 10, 2017 4:53:06 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
Grave: Error while trying to instantiate SQLGenerator :: {0}
java.io.FileNotFoundException: null/conf/Persistence/postgres_functionpatterns.txt (No existe el fichero o el directorio)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20DBAdapter.java:2057)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.java:213)
at com.adventnet.db.adapter.postgres.PostgresDBAdapter.initialize(PostgresDBAdapter.java:116)
at com.adventnet.persistence.PersistenceInitializer.initializeRelationalAPI(PersistenceInitializer.java:447)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:466)
at com.adventnet.persistence.PersistenceInitializer.initializeDBAndDBProps(PersistenceInitializer.java:339)
at com.adventnet.persistence.service.DatabaseFactory.startDB(DatabaseFactory.java:568)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:290)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:116)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:323)
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.PostgresSQLGenerator setEncryptionAlgorithm
Información: Encryption algorithm used :: [aes256]
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.PostgresSQLGenerator setEncryptionS2kMode
Información: Encryption s2k-mode used :: [1]
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer initialize
Información: db.home ::: ./pgsql
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer initialize
Información: dataDirectory :: /opt/ServiceDesk/pgsql/data
feb 10, 2017 4:53:07 PM com.adventnet.persistence.PersistenceInitializer initializeRelationalAPI
Información: DataSourcePlugIn is initialized successfully
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.AbstractRestoreHandler doRestoreSanityTesting
Información: Restore process fully completed.
feb 10, 2017 4:53:07 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
Información: Template replaced url :: jdbc:postgresql://localhost:65432/servicedesk
feb 10, 2017 4:53:07 PM com.adventnet.persistence.PersistenceInitializer getDBParamsFilePath
Información: Reading null/conf/database_params.conf
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer checkForPgIsReadybinary
Información: /opt/ServiceDesk/./pgsql/bin/pg_isready isExists :: true
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer executeCommand
Información: Command to be executed [/opt/ServiceDesk/./pgsql/bin/pg_isready, --host, localhost, --port, 65432, --username, postgres]
localhost:65432 - accepting connections
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer isPgReady
Información: pg_isready returning status :: 0
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer validateDataDirectory
Información: Validating data_directory path with running server.
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer executeCommand
Información: hostAddress of localhost is 127.0.0.1
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer executeCommand
Información: Command to be executed :::: [/opt/ServiceDesk/pgsql/bin/psql, -U, postgres, -p, 65432, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w]
feb 10, 2017 4:53:07 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer executeCommand
Información: Command to be executed [/opt/ServiceDesk/pgsql/bin/psql, -U, postgres, -p, 65432, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w]
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer validateDataDirectory
Información: dataDirectory path from server :: /opt/ServiceDesk/pgsql/data
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.postgres.PostgresDBAdapter setUpDB
Información: DB server already running in :: ./pgsql
feb 10, 2017 4:53:08 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
Información: Template replaced url :: jdbc:postgresql://localhost:65432/servicedesk
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer executeCommand
Información: hostAddress of localhost is 127.0.0.1
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer executeCommand
Información: Command to be executed :::: [/opt/ServiceDesk/pgsql/bin/psql, -U, postgres, -p, 65432, -h, 127.0.0.1, -c, CREATE DATABASE "servicedesk", -d, postgres, -w]
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer executeCommand
Información: Command to be executed [/opt/ServiceDesk/pgsql/bin/psql, -U, postgres, -p, 65432, -h, 127.0.0.1, -c, CREATE DATABASE "servicedesk", -d, postgres, -w]
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer createDB
Información: ErrorStream ::: ERROR: database "servicedesk" already exists
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.postgres.PostgresDBAdapter createDB
Información: createDB returns ::: true
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.postgres.PostgresDBAdapter validateVersion
Información: Postgres version ::: 9.2.4
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.Jdbc20DBAdapter getDBProps
Información: splitConnectionURL :: {Port=65432, url_props_delimiter=&, urlWithoutProps=jdbc:postgresql://localhost:65432/servicedesk, jdbcurl_props_separator=?, DBName=servicedesk, Server=localhost
feb 10, 2017 4:53:08 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
Información: Template replaced url :: jdbc:postgresql://localhost:65432/servicedesk
feb 10, 2017 4:53:08 PM com.adventnet.db.adapter.postgres.PostgresDBAdapter checkAndCreatePostgresExtensions
Información: Going to create postgres extensions if not exists ...
Active DB Server = postgres
Database connectionProp : null
feb 10, 2017 4:53:14 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
Información: Loading the function patterns from the file :: [null/conf/Persistence/postgres_functionpatterns.txt]
feb 10, 2017 4:53:14 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
Grave: Exception occurred while parsing the file :: [null/conf/Persistence/postgres_functionpatterns.txt]
java.io.FileNotFoundException: null/conf/Persistence/postgres_functionpatterns.txt (No existe el fichero o el directorio)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20DBAdapter.java:2057)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.java:213)
at com.adventnet.db.adapter.postgres.PostgresDBAdapter.initialize(PostgresDBAdapter.java:116)
at com.adventnet.servicedesk.tools.ConnectionUtil.getDBAdapter(ConnectionUtil.java:195)
at com.adventnet.servicedesk.tools.ConnectionUtil.getConnection(ConnectionUtil.java:60)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:292)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:116)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:323)
feb 10, 2017 4:53:14 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
Grave: Error while trying to instantiate SQLGenerator :: {0}
java.io.FileNotFoundException: null/conf/Persistence/postgres_functionpatterns.txt (No existe el fichero o el directorio)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20DBAdapter.java:2057)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.java:213)
at com.adventnet.db.adapter.postgres.PostgresDBAdapter.initialize(PostgresDBAdapter.java:116)
at com.adventnet.servicedesk.tools.ConnectionUtil.getDBAdapter(ConnectionUtil.java:195)
at com.adventnet.servicedesk.tools.ConnectionUtil.getConnection(ConnectionUtil.java:60)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:292)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:116)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:323)
feb 10, 2017 4:53:14 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
Grave: Exception occured while initializing datasource.
feb 10, 2017 4:53:14 PM com.adventnet.db.adapter.postgres.PostgresSQLGenerator setEncryptionAlgorithm
Información: Encryption algorithm used :: [aes256]
feb 10, 2017 4:53:14 PM com.adventnet.db.adapter.postgres.PostgresSQLGenerator setEncryptionS2kMode
Información: Encryption s2k-mode used :: [1]
feb 10, 2017 4:53:14 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer initialize
Información: db.home ::: ./pgsql
feb 10, 2017 4:53:14 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer initialize
Información: dataDirectory :: /opt/ServiceDesk/pgsql/data
Database started
java.lang.NullPointerException
at java.io.File.<init>(Unknown Source)
at com.adventnet.servicedesk.tools.RestoreSDBackupUtil.getRestoreStatusDetails(RestoreSDBackupUtil.java:629)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:315)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:116)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:323)
Unable to restore database : null
null
feb 10, 2017 4:53:14 PM com.adventnet.persistence.PersistenceInitializer stopDB
Información: Going to stop the DBServer
feb 10, 2017 4:53:14 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
Información: Template replaced url :: jdbc:postgresql://localhost:65432/servicedesk
root@HD:/opt/ServiceDesk/bin# io.FileNotFoundException: null/conf/Persistence/postgres_functionpatterns.txt Unable to restore database : null
bash: io.FileNotFoundException:: no se encontró la orden