Author Topic: DSN (write): NOT OK(DB Error: unknown error)  (Read 9877 times)

Offline ishvir

  • Newbie
  • *
  • Posts: 5
DSN (write): NOT OK(DB Error: unknown error)
« on: March 28, 2008, 03:15:12 AM »
Hi

I am trying to install RC01 using RC Installer on the domain http://www.llb.co.za

I went to:
http://www.llb.co.za/installer/index.php?_step=2

MySQL details are as under:
MySQL database onex2yco_RoundCube to MySQL user onex2yco_rc.

This all appears in CPanel as under:
onex2yco_RoundCube
Users in RoundCube
onex2yco_rc (Privileges: ALL PRIVILEGES)
Connection Strings
Perl  $dbh = DBI->connect("DBI:mysql:onex2yco_RoundCube:localhost","onex2yco_rc","");
PHP  $dbh=mysql_connect ("localhost", "onex2yco_rc", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("onex2yco_RoundCube");

Moving to Step 3: Updating and uploading new versions of main.inc.php and db.inc.php
(http://www.llb.co.za/installer/index.php?_step=3)


I get the errors as under for each variation of PEAR:DB and PEAR::MDB2:

With Backend: PEAR::DB
Check config files
main.inc.php: OK
db.inc.php: OK
Check configured database settings
Backend: PEAR::DB
DSN (write): NOT OK(DB Error: unknown error)
Make sure that the configured database extists and that the user as write privileges
DSN: mysql://onex2yco_rc:123456789@localhost/onex2yco_RoundCube


With Backend: PEAR::MDB2
Check config files
main.inc.php: OK
db.inc.php: OK
Check configured database settings
Backend: PEAR::MDB2
DSN (write): NOT OK(MDB2 Error: not found)
Make sure that the configured database extists and that the user as write privileges
DSN: mysql://box:123456789@localhost/box
There are known problems with MDB2 running on PHP 4. Try setting db_backend to 'db' instead


Please help, thanks,
Ishvir

Offline vartanjean

  • Newbie
  • *
  • Posts: 2
correct
« Reply #1 on: September 17, 2008, 09:15:30 AM »
On terminal pear install MDB2_Driver_mysql