GenDBWiki/AdministratorDocumentation/GenDBInstallationFAQ

Frequently asked questions (FAQ) about installing and setting up GenDB 2.2

Database setup and requirements

• The installation fails due to insufficient permissions on the database server for "gendb@localhost".

  The installation systems creates several user accounts on the database server. It does not specify the host name to allow the web server and command line script to be used within a network (e.g. a dedicated database server and a dedicated web server). The default setup of MySQL often already contains an account for "%@localhost". This account has precedence over the ones generated by the installation system (see also the MySQL privilege system documentation). You have to remove this account prior to installing GenDB 2.2.

Downloads during the installation

• During the installation a number of files are downloaded. What are these files ?

  The GOPArc component stores a number of classification schemes and information about metabolic pathways from the KeGG database. The license for these information does not allow us to bundle the files with GenDB 2.2. The installation system has to download the to build the GOPArc database. The files are:

• COG and KOG from NCBI ([1])
• the compound, enzyme and reaction files from KeGG ligand database ([2])
• the reference maps from the KeGG pathway database ([3])
• I already have these files. How can i skip the download ?

 The current release does not support skipping the download if the files are already available. Some of the files have to be postprocessed during the installation (e.g. correct headers for the COG blastable database). The GOPArc component also expects the files to be available in certain locations within the installation directory. But we may change the download and conversion scripts in a later release to support locally available files.

Changing configuration after installation

• I need to change some settings after the installation.

  The installation system provides a script called "reconfigure_module". It enables administrators to change the configuration settings done at installation time. See also the next two FAQs.

• I want to move the databases to another server.

  Moving the database to another server requires several configuration changes:

• changing the database server name for the project management component by the "reconfigure_module" script.
• the name is also stored in the project management database itself and has to be changed manually

 The project management allows the various project database to be stored on several database servers. Each project database is associated with a database host in the project management database. If the databases are moved to another server, this information has to be updated, too. We recommend to use DNS aliases ("CNAME") for the database server(s). Moving the database to another machine only requires changing the alias in the DNS configuration.

• I have moved the sequences databases ("nr", "nt", etc.) to another directory. How can I change the pathes withi GenDB 2.2 ?

 Unfortunatly changing the pathes at one single location is not possible. For every blast tool that is used in a GenDB project the location of the blastable database file is stored in the project database itself. If you have to move the database files to another location, you have to change the pathes in  all GenDB project databases. We may provide a script for this later. You also have to change the configuration of the GenDB component with the "reconfigure_module" script, since it is used for setting up new project and the default tools, including the pathes to the blastable databases.