TL 1.8.2 - redmine BTS (sqlite3) issue

[postb99]

Hello,

I have a working redmine served on port 8081, and am using a sqlite3 db. Later I would switch to a Postgresql one I think.

Is the sqlite3 db supported with redmine plugin ?

It seems "sqlite3" keyword isn't, so I changed config param to "sqlite" and have BTS TL connexion failure. What can I do to debug ?

Here is my redmine.cfg.php :

Code: Select all

/** The DB host to use when connecting to the redmine db */
define('BUG_TRACK_DB_HOST', 'http://localhost:8081');

/** The name of the database that contains the redmine tables */
define('BUG_TRACK_DB_NAME', 'redmine');

/** The DB type being used by redMine
 * Check config/database.yml in redMine install directory.
 * values: mysql, mssql, postgres
 */
define('BUG_TRACK_DB_TYPE', 'sqlite');

/** The DB password to use for connecting to the redMine db */
define('BUG_TRACK_DB_USER', '');
define('BUG_TRACK_DB_PASS', '');

define('BUG_TRACK_DB_CHARSET', "UTF-8");
// define('BUG_TRACK_DB_CHARSET',"gb2312");
// define('BUG_TRACK_DB_CHARSET',"UTF-8");


/* link of the web server for redmine */
define('BUG_TRACK_HREF', "http://localhost:8081/issues/show/");
// define('BUG_TRACK_HREF', "http://localhost:3000/issues/show/");

/** link to the bugtracking system, for entering new bugs */
define('BUG_TRACK_ENTER_BUG_HREF',"http://localhost:8081");
// define('BUG_TRACK_ENTER_BUG_HREF',"http://localhost:3000/");

Redmine's database.yml :

Code: Select all

production:
  adapter: sqlite3
  dbfile: db/redmine.db

Thanks,

Barbara

[postb99]

I corrected the config :

Code: Select all

define('BUG_TRACK_DB_HOST', 'c:\xampp\redmine-0.8.4\db\redmine.db'); 

But get :

Code: Select all

sqlite_open() [<a href='function.sqlite-open'>function.sqlite-open</a>]: file is encrypted or is not a database - in C:\xampp\htdocs\testlink\third_party\adodb\drivers\adodb-sqlite.inc.php - Line 164
	[09/Jun/12 12:55:11][ERROR][<nosession>][GUI]
		Connect to Bug Tracker database fails!!! 0 - 
[<<][4a32502f27212374554130][DEFAULT][/testlink/login.php][09/Jun/12 12:55:11][09/Jun/12 12:55:11][took 0.021533 secs]

Going to switch to MySQL instead, abandoning topic.