phpLedMailer Database Configuration
Documentation Index

The only file you have to manually edit is the config.inc.php file in the root of your phpLedMailer installation. Don't forget that you must renamed config.inc.php-default to config.inc.php before you continue. To edit this file, simply open it with notepad or some type of text editor (actually, notpad may not work very well -- we recommend either TextPad or VIM)

With config.inc.php, you must set the database values depending on what type of database engine you want to use. Don't forget that this must all be contained with <? and ?> tags (for php processing.) Here are some examples:

For MySQL:

$config = array(
	'db'	=> array(
		'type'	=> 'mysqlt', // mysql or mysqlt (transactions)
		'host'	=> 'localhost',
		'user'	=> 'dbuser',
		'pass'	=> 'dbpass',
		'db'	=> 'plm' // your database
	)
);

For PostgreSQL:

$config = array(
	'db'	=> array(
		'type'	=> 'postgres',
		'host'	=> 'localhost',
		'user'	=> 'dbuser',
		'pass'	=> 'dbpass',
		'db'	=> 'plm' // your database
	)
);

For Microsoft SQL Server:

$config = array(
	'db'	=> array(
		'type'	=> 'mssql',
		'host'	=> 'localhost',
		'user'	=> 'dbuser',
		'pass'	=> 'dbpass',
		'db'	=> 'plm' // your database
	)
);

For Oracle:
Oracle configuration assumes you are using the tnsnames.ora method of defining your databases and where they are located.

$config = array(
	'db'	=> array(
		'type'	=> 'oracle', // oracle, or oci8 (the actual driver used)
		'host'	=> '', // leave blank for oracle
		'user'	=> 'dbuser',
		'pass'	=> 'dbpass',
		'db'	=> 'plm' // this is the $ORACLE_SID for your database
	)
);

For SQLite:
(Note: SQLite usage is depreciated due to lack of proper adodb drivers. The schema file provided is out of date and will likely break things.)
If you choose to use SQLite, be sure that your webserver has permission to create and modify files in whatever location you define for the database (the 'db' parameter)
You may also need to manually create the database using sqlite-schema.sql (in the doc/ folder), but this is unlikely. Try installing the database the standard way, and if you get errors, try to using the .sql file provided to populate the database (via the command line tool sqlite.exe, or something similar.)

$config = array(
	'db'	=> array(
		'type'	=> 'sqlite',
		'host'	=> 'localhost',
		'user'	=> 'fakeuser', // not used by sqlite
		'pass'	=> 'fakepass', // not used by sqlite
		// this should be the physical file path to the database file
		'db'	=> urlencode('./plm.db')
	)
);

Copyright Ledscripts.com 2005