OpenDBX/Configuration

From Linuxnetworks
Jump to: navigation, search


Parameter for different OpenDBX backends. The common parameter are:

host 
Name or IP address of the database server
port 
Port the database server is listening to (optional)
database 
Name of the database which contains tables, views, etc.
user 
Name of the user account used for authentication
password 
String of characters used as secret for authentication

Depending on the backend there are variations:

firebird backend

database 
Path to the database file (.gdb) in the filesystem. On Unix-like systems this might be /var/lib/firebird2/data/dbname.gdb for example, on Windows the path may look like C:\Program files\Firebird\data\dbname.gdb

mssql backend

host 
Name or IP address of the database server or the name of a configuration section in the freetds.conf file

mysql backend

host 
Name or IP address of the database server or the path to the socket of a locally installed MySQL server, e.g. /var/run/mysql/mysql.socket

odbc backend

host 
Depends on the used ODBC driver. May be a name or IP address or a configuration section in the odbc.ini file
database 
May be optional if specified in the odbc.ini file
user 
May be optional if specified in the odbc.ini file or not used
password 
May be optional if specified in the odbc.ini file or not used

oracle backend

port 
Port (usually 1521) is mandatory

pgsql backend

Does only use the default semantic for the parameter

sqlite backend

host 
Path to the directory where the database is stored, e.g. /path/to/directory/ on Unix-like filesystems or C:\Program files\SQLite\data\ (notice the trailing slash or backslash)
port 
Not used as SQLite does only support local database access
database 
Name of the database file in the filesystem
user 
Not used, SQLite depends on the filesystem permissions
password 
Not used

sqlite3 backend

host 
Path to the directory where the database is stored, e.g. /path/to/directory/ on Unix-like filesystems or C:\Program files\SQLite\data\ (notice the trailing slash or backslash)
port 
Not used as SQLite does only support local database access
database 
Name of the database file in the filesystem
user 
Not used, SQLite depends on the filesystem permissions
password 
Not used

sybase backend

host 
Name or IP address of the database server or the name of a configuration section in the freetds.conf file