Annexe 1: Configuration file

The configuration file contains the mandatory parametres allowing you to connect your database. The file config.php created by the installation procedure is stored in the bin directory.

• qti_dbsystem defines the database type you will use. Possible values are (in lower case!):
  • mysql for MySQL 5 or above
  • mysql4 for MySQL 4.x
  • mssql for SQL Server/Express 2000 or above
  • pg for PostgreSQL 7.x or above
  • oci for Oracle/Oracle express 9 or above
  • ibase for InterBase Firebird 2.0 or above
  • sqlite for SQLite 3.0 or above
  • db2 for IBM DB2
• qti_host defines the name of the database server. In most cases (when your database server is on the same hardware that your webserver), this will be localhost
• qti_database defines the name of your database.
• qti_port is the host port to connect the database. In most case, you must let it empty. If you use PostgreSQL it's usually 5432 .
• qti_dsn is the Database System Name (odbc name) allowing to connect the database via odbc. Let it empty unless you use Microsoft Access database or if you don't have the php specific resources. If a DSN is defined, database name and port will be useless.
• qti_prefix defines the prefix of the tables in your database. This is used if you plan to have serveral QuickTicket applications on the same database
• qti_user is the user in your database. This user must be granted to select, insert, delete, update.
• qti_pwd is the user's password.
• qti_install is the installation date.

Important

If you edit your configuration file manually, don't forget to add the variable qti_install and assigne it the date value. Without this variable, your board will return to the installation wizard and ask you to save your configuration file again.

Previous | Next