[Urgent Help Needed] Problem With Roundcube & Database

R

rabbihossain

New member
Joined
Sep 4, 2012
Messages
4
Hi, I am Rabbi Hossain. I am new here. I am having some problem with my Directadmin.
Currently, I am using the custombuild of directadmin. I have tried the to open roundcube and got this error.
DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator
Click to expand...
I have searched for fix in directadmin help site. And found this site link ->http://help.directadmin.com/item.php?id=206

And I ran these commands
Code: 
cd /usr/local/directadmin/custombuild
./build roundcube

and "./build roundcube" gave me this output.

Code: 
[root@srv1 custombuild]# ./build roundcube
mail-header-patch=yes is set in the options.conf, but is not required with this php version.
To enable the X-Mail header, set mail.add_x_header to 1 in your php.ini
cp: `/var/www/html/roundcube/logs' and `/var/www/html/roundcubemail-0.8.1/logs' are the same file
cp: `/var/www/html/roundcube/temp' and `/var/www/html/roundcubemail-0.8.1/temp' are the same file
Editing roundcube configuration...
Roundcube 0.8.1 has been installed successfully.
PHP Warning:  PHP Startup: Unable to load dynamic library './suhosin.so' - ./suhosin.so: cannot open shared object file: No such file or directory in Unknown on line 0
MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SHOW COLUMNS FROM session]
[Native code: 1286]
[Native message: Unknown table engine 'InnoDB']


Warning: array_diff(): Argument #2 is not an array in /var/www/html/roundcubemail-0.8.1/installer/rcube_install.php on line 372
MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SHOW COLUMNS FROM users]
[Native code: 1286]
[Native message: Unknown table engine 'InnoDB']


Warning: array_diff(): Argument #2 is not an array in /var/www/html/roundcubemail-0.8.1/installer/rcube_install.php on line 372
MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SHOW COLUMNS FROM cache]
[Native code: 1286]
[Native message: Unknown table engine 'InnoDB']


Warning: array_diff(): Argument #2 is not an array in /var/www/html/roundcubemail-0.8.1/installer/rcube_install.php on line 372
MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SHOW COLUMNS FROM contacts]
[Native code: 1286]
[Native message: Unknown table engine 'InnoDB']


Warning: array_diff(): Argument #2 is not an array in /var/www/html/roundcubemail-0.8.1/installer/rcube_install.php on line 372
MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SHOW COLUMNS FROM contactgroups]
[Native code: 1286]
[Native message: Unknown table engine 'InnoDB']


Warning: array_diff(): Argument #2 is not an array in /var/www/html/roundcubemail-0.8.1/installer/rcube_install.php on line 372
MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SHOW COLUMNS FROM contactgroupmembers]
[Native code: 1286]
[Native message: Unknown table engine 'InnoDB']


Warning: array_diff(): Argument #2 is not an array in /var/www/html/roundcubemail-0.8.1/installer/rcube_install.php on line 372
MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SHOW COLUMNS FROM identities]
[Native code: 1286]
[Native message: Unknown table engine 'InnoDB']


Warning: array_diff(): Argument #2 is not an array in /var/www/html/roundcubemail-0.8.1/installer/rcube_install.php on line 372
WARNING: Database schema needs to be updated!
Missing table 'cache_index'
Missing table 'cache_thread'
Missing table 'cache_messages'
Missing table 'dictionary'
Missing table 'searches'

Do you want to run the update queries to get the schmea fixed? (y/N)
y
MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: TRUNCATE TABLE `messages`;
]
[Native code: 1286]
[Native message: Unknown table engine 'InnoDB']

PHP Warning:  PHP Startup: Unable to load dynamic library './suhosin.so' - ./suhosin.so: cannot open shared object file: No such file or directory in Unknown on line 0
This instance of Roundcube is up-to-date.
Have fun!

After that I tried to run Roundcube again. But It didn't start and gave me the same error like the first quote. What should I do now?? Please help me now.
 
Are you sure mysql is running correctly on your server?
 
scsi said:
Are you sure mysql is running correctly on your server?
Click to expand...
yes MySQL is running correctly. I can manage database through PhpMyAdmin and I am also running a Forum on the server. It is working without any problem.
 
This is a bit weird, but I have had the same problem on one of my servers today.
InnoDB stopped working after a mysql restart, mysql version 5.1.65 .

You should check your mysql logs first, it would say someting about the ib_logfiles.

If it is:

I have fixed it with the following commands:
service mysqld stop (stop it first!)
mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak
service mysqld start (give it some time to preserve the logfiles)
 
Something is definitely not working right with your mysql. Check the mysql error logs. Make sure you didnt disable innodb in my.cnf too.

The problem is:

Code: 
Unknown table engine 'InnoDB'
 
You must log in or register to reply here.
Back
Top