Difference between revisions of "Seon Core administrative scripts"

From Seon
Jump to: navigation, search
(seon_archive.sh)
Line 55: Line 55:
 
*is the parameter valid
 
*is the parameter valid
  
The created archive is a valid MySQL dump which can be easily imported with standard MySQL tools (like the "mysqlclient" command line tool). The archive is backed up in the configured [[http://wiki.seon.de/wiki/index.php/Seon_Core_installation#backup|database backup directory]], with a filename
+
The created archive is a valid MySQL dump which can be easily imported with standard MySQL tools (like the "mysqlclient" command line tool). The archive is backed up in the configured [Seon_Core_installation#backup|database backup directory], with a filename
 
  seon_archive.$TIMESTAMP.sql
 
  seon_archive.$TIMESTAMP.sql
 
where "<code>$TIMESTAMP</code>" is a string containing the date- and timestamp when the script was started.
 
where "<code>$TIMESTAMP</code>" is a string containing the date- and timestamp when the script was started.

Revision as of 10:53, 20 August 2013

daxware2seon

If you want to migrate from a Hüngsberg Daxware system to Seon, you can easily use this script to mass-import all partner entries to Seon. Just point the variable "PASSW_DAX" to the appropriate file. Example:

PASSW_DAX=/tmp/passw.dax 

The rest of the script works out-of-the-box if you have a configured Seon system running.

swan2seon.ksh

To mass-import partner entries from SWAN 1.5 database to Seon, the company SSC GmbH created this script which is free to use. You should run this script from a shell where the environment variable "SWAN_HOME" is available. Also check the position of the Seon program "seonped", which is being called in line 68 (also check the echo command on line 67).

seonbackup

This script works without parameters. It checks the configuration file and the backup directory (as given in the configuration panel). If all requirements are fulfilled, a SQL dump will be saved with a timestamp extension in the backup directory. The output of a sample run is:

hostname:/opt/seon/scripts # ./seonbackup 
backup file: /opt/seon/backup/seon.20050113.182639.sql 

So you can re-use the output for further post-processes.

seonrestore

For restoring the Seon database, make sure all Seon processes are stopped. Also make sure the database is up and running. If you are not sure which file you want to restore, start the script without any parameter. It will say something like this:

hostname:/opt/seon/scripts # ./seonrestore 
no backup file as parameter 1 given. choose one of the existing: 
seon.20041015.205850.sql 
seon.20041222.175616.sql 
seon.20050113.182639.sql 

These are the existing database dump files in the backup directory as configured in the configuration panel. If you are sure which file to restore, start the script with the filename as given above as the only parameter.

hostname:/opt/seon/scripts # ./seonrestore seon.20050113.182639.sql 
backup file: /opt/seon/backup/seon.20050113.182639.sql restored 

Now you can safely start the Seon processes again.


seon_archive.sh

This script is intended to keep the MySQL database usage clean and usable. As a mandatory parameter, you must pass the maximum age of entries (in days) for the oldest entries available in the MySQL database. All entries older that this given age are archived. The archived entities are:

  • all logs (incl. vault):
    • receive log
    • send log
    • system log
    • event (aka "script") log
    • archived xERPs
    • directory scanner
  • CRL vault
  • CSR vault

The script dynamically checks if Seon Enteprise is enabled. If this is the case, the script also archives the following entities older than the given age:

  • all jobs
  • all XML entries of archived jobs
  • all plugin logs of archived jobs

The script dynamically verifies the running circumstances:

  • is the database of type "MySQL"
  • is a dump tool correctly configured
  • is a backup directory correctly configured
  • is the parameter valid

The created archive is a valid MySQL dump which can be easily imported with standard MySQL tools (like the "mysqlclient" command line tool). The archive is backed up in the configured [Seon_Core_installation#backup|database backup directory], with a filename

seon_archive.$TIMESTAMP.sql

where "$TIMESTAMP" is a string containing the date- and timestamp when the script was started.