Install problem sqlite, mssql
Hello,
I tried to install tikiwiki using the following environment:
tikiwiki: version 1.9.9,installed in d:\tikiwiki
php: version 5.2.5 build 3790, installed in d:\php
webserver: iis6, called mywebserver
sql-server: mssql-server 2005, called mydbserver
sqlite: version 3.5.4
MSSQL:
database: tikiwiki
user: tikiwiki
sql-server authentification
db_owner
MSSQL problem:
when I try to run the tiki installation using the following enties in the install-form:
Database type: mssql
host: mydbserver
user: tikiwiki
password:XXX
database name: tikiwiki
I allways get the error:
Tiki cannot find a database connection
I just tried a lot of combinations of host , databasename, schema name etc. but I cannot find the correct entries.
- Has anyone an idea which entries I have to make to get a connection to the sqlserver ?
- It just would be fine if somone has an idea how I can display more details of the error ?
SQLITE problem:
I also tried to use sqlite3 as backend database. I created the database in the file d:\sqlite\tikiwiki.db.
When I start the installation with the following entries:
Database type:sqllite
host:d:\sqlite\tikiwiki.db
user:
password:
database name:d:\sqlite\tikiwiki.db
I get the next page of the installation process where I can select the profile to create.
When I select "Default installation profile" and click create I get the following error:
Warning: fopen(db/tiki--.sql) [function.fopen]: failed to open stream: No such file or directory in D:\TikiWiki\tiki-install.php on line 47 Fatal: Cannot open db/tiki--.sql
When I edit the tiki-install.php script and replace the line process_sql_file('tiki-'. $dbversion .....) by
process_sql_file(tiki-1.9-sqlite.sql',$db_tiki) I get the following error:
Fatal error: Call to a member function Execute() on a non-object in D:\TikiWiki\tiki-install.php
Has anyone an idea how I can run tiki using mssql or sqlite 3.5.4
thank you in advance for any ideas
manfred