OpenDBX/Configuration
From Linuxnetworks
< OpenDBX
Contents
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