Navigation

Changeset 6230

Timestamp:

07/31/08 09:51:36 (4 months ago)

Author:

ethans

Message:

Adds sqlite3 cdr support. Closes #2981

Files:

r2614	r6230
29	29	define ("PASS", $amp_conf["AMPDBPASS"]);
30	30	define ("DBNAME", "asteriskcdrdb");
31		define ("DB_TYPE", ~~"mysql"~~); // mysql or postgres
	31	define ("DB_TYPE", $amp_conf["AMPDBENGINE"]); // mysql or postgres
32	32
33	33
…	…
52	52	$datasource = 'pgsql://'.USER.':'.PASS.'@'.HOST.'/'.DBNAME;
53	53	}
	54	else if (DB_TYPE == "sqlite3")
	55	{
	56	/* on centos this extension is not loaded by default */
	57	if (! extension_loaded('sqlite3') && ! extension_loaded('SQLITE3'))
	58	dl('sqlite3.so');
	59
	60	if (! @require_once('DB/sqlite3.php') )
	61	{
	62	die_freepbx("Your PHP installation has no PEAR/SQLite3 support. Please install php-sqlite3 and php-pear.");
	63	}
	64
	65	$datasource = "sqlite3:///asteriskcdr.db?mode=0666";
	66	$options = array(
	67	'debug' => 4,
	68	'portability' => DB_PORTABILITY_NUMROWS
	69	);
	70	}
54	71	else
55	72	{
56	73	$datasource = DB_TYPE.'://'.USER.':'.PASS.'@'.HOST.'/'.DBNAME;
57	74	}
	75	if($options)
	76	$db = DB::connect($datasource,$options); // attempt connection with options (sqlite3)
	77	else
	78	$db = DB::connect($datasource); // attempt connection
58	79
59		~~$db = DB::connect($datasource); // attempt connection~~
60
61	80	if(DB::isError($db))
62	81	{