Dear Forum
At the risk of being banned for life from LQ, i'd like to ask a question concerning the phpBB installation under Mac OS X, I'm posting here because I believe my problem is not system specific, but rather general. I'm tying to install phpBB and connect it to SQLite. I'm running the installation script in the browser, and it appears php is able to locate SQLite (indicated by "available"). On the next page of the installation form what do I need to enter in the fields?:
Code:
Database type: SQLite
Database server hostname or DSN: /absolute/path/to/DB/file.db
Database server port: [I leave it empty]
Database name: test_tbl
Database username: ??
Database password: ??
Prefix for table in database: phpbb_
This is the message i get:
Code:
Could not connect to the database, see error message below.
not an error
The table should be available:
Code:
me @ ~/Sites/mybboard $ sqlite3 mybboard.db
SQLite version 3.4.0
Enter ".help" for instructions
sqlite> .tables
test_tbl
sqlite>
It should be writable for my server Apache.
Code:
me @ ~/Sites/mybboard $ ls -l
total 8
-rw-r--r-- 1 _www staff 2048 20 Dez 18:47 mybboard.db
me @ ~/Sites/mybboard $
I'm not quite sure about the following:
- Do I need to have sqlite3 running somewhere in a shell that the connection can be established?
- Does the directory containing the DB need to be writable for www?
- What's the required chmod setting for mybboard.db
- Where/how are "Database username" and "Database password" set? I never had to set a password, when I created the DB, so I understand it should work, when I leave the password field blank, not?
Thanks for any feedback and not banning me from LQ.