Author Topic: Tons of errors on latestest version (Read 4432 times)

Gorf · « **on:** December 22, 2009, 12:48:51 AM »

So I finally managed to get Roundcube installed and I get a ton of errors on the main page:

Warning: Error writing to log file /home/*user*/public_html/whootis.net/www/logs/errors; Please check permissions in /home/*user*/public_html/whootis.net/www/webmail/program/include/main.inc on line 1053

Notice: MDB2 Error: unknown error Query: _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, FROM_UNIXTIME(1261460620), FROM_UNIXTIME(1261460620))] [Native code: 0] in /home/*user*/public_html/whootis.net/www/webmail/program/include/bugs.inc on line 86
DB Error in /home/*user*/public_html/whootis.net/www/webmail/program/include/rcube_mdb2.php (627): MDB2 Error: unknown error Query: _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, FROM_UNIXTIME(1261460620), FROM_UNIXTIME(1261460620))] [Native code: 0]

I've given up trying to make the logs work. As a temporary work around I am now just sending them to /tmp and that works. However I can not get rid of these other SQL errors at all. Any thoughts?

System:
CentOS 5.4 i386
Apache 2.2
PHP 5.3.1

rosali · « **Reply #1 on:** December 22, 2009, 01:13:32 AM »

The first error is a permission issue. Apache user does not have write permission on logs folder.

Did you update your database tables? There are SQL scripts in the SQL folder. May be the installer script failed to do the job due to the permission issue on logs folder.

Gorf · « **Reply #2 on:** December 23, 2009, 02:02:30 PM »

This is a brand new installation.

The logs and temp write issue are specifically a RoundCube issue. Several attempts to reproduce the issue in my own code are not successful. I can readily write to the exact same path with my own code without issue.

In fact, if I take the code throwing the error for the logs and run it on my own I have zero issues. However the exact same code in RoundCube throws the error:

    // log_driver == 'file' is assumed here
    if (empty($CONFIG['log_dir']))
      $CONFIG['log_dir'] = INSTALL_PATH.'logs';

    // try to open specific log file for writing
    $logfile = $CONFIG['log_dir'].'/'.$name;
    if ($fp = @fopen($logfile, 'a')) {
      fwrite($fp, $log_entry);
      fflush($fp);
      fclose($fp);
      return true;
    }
    else
      trigger_error("Error writing to log file $logfile Please check permissions", E_USER_WARNING);

As for the database, I will try to redo the install clean again and re-route the temp and logs to /tmp where apparently the RoundCube code can write and see if that makes a difference.

Gorf · « **Reply #3 on:** December 23, 2009, 02:44:35 PM »

I'll be damned.

I redid the install from scratch and everything appears to be hunky-dory now.

*shrug*

Thanks for the help anyway!

neurox · « **Reply #4 on:** January 08, 2010, 09:56:55 AM »

Changing DSN from "mysqli" to "mysql" fixed the MDB2 errors for me.

SKaero · « **Reply #5 on:** January 08, 2010, 10:00:16 AM »

That would only work if your using a mysqli database.

alec · « **Reply #6 on:** January 13, 2010, 02:11:07 AM »

PHP5.3 + mysqli = known problem, but no solution yet. Consider giving me ssh access to your box and I will try to fix this. Currently I'm not using PHP5.3.