Author Topic: Roundcube on Snow Leopard Server  (Read 6951 times)

Offline aweirig

  • Jr. Member
  • **
  • Posts: 14
Roundcube on Snow Leopard Server
« on: October 13, 2009, 09:39:22 AM »
Hello,

I'm about to upgrade all of our Mac OS X 10.5 servers to Snow Leopard. One of the servers I need to upgrade is running Roundcube 0.3.

During my tests I found that RC 0.3 is not running on Snow Leopard (with Apple provided Apache, PHP etc configuration).

MySQL on running on a separate Snow Leopard server.

Messages I'm getting in installer:
Deprecated: Assigning the return value of new by reference is deprecated in /Library/WebServer/Documents/roundcubemail-0.3-stable-test/program/lib/MDB2.php on line 392 Deprecated: Assigning the return value of new by reference is deprecated in /Library/WebServer/Documents/roundcubemail-0.3-stable-test/program/lib/MDB2.php on line 2614 Deprecated: Assigning the return value of new by reference is deprecated in /Library/WebServer/Documents/roundcubemail-0.3-stable-test/program/lib/PEAR.php on line 563 Deprecated: Assigning the return value of new by reference is deprecated in /Library/WebServer/Documents/roundcubemail-0.3-stable-test/program/lib/PEAR.php on line 566 DSN (write):  NOT OK(MDB2 Error: connect failed)

I have installed the MySQL GUI Tools and can connect to the MySQL server and the database from the machine I want to run RC on so there shouldn't be any issue at that level.

Looks like a problem with PEAR and MDB2 to me.

Many thanks in advance for your feedback.

Alex

Offline aweirig

  • Jr. Member
  • **
  • Posts: 14
Update: Roundcube 0.3 on Snow Leopard
« Reply #1 on: October 13, 2009, 09:56:08 AM »
I replaced the PEAR.php file with the latest file available on their site and had to add the PEAR5.php file.

All PEAR.PHP related error messages went away.

I also tried replacing MDB2.php and the MDB2 directory with the latest version available but was less lucky since the error messages didn't go away and I still can't connect to MySQL.

Hope this helps in tracking down the source of the problem.

Kind regards,

Alex

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Roundcube on Snow Leopard Server
« Reply #2 on: October 14, 2009, 02:37:14 AM »
Have you tried with the SVN?

Offline aweirig

  • Jr. Member
  • **
  • Posts: 14
Roundcube on Snow Leopard Server
« Reply #3 on: October 15, 2009, 03:03:47 AM »
Hello,

thanks for your reply. I downloaded the latest from svn trunk this morning and still have a problem with MDB2.

In the CHANGELOG file, the first change line says:
- Added server-side e-mail address validation with 'email_dns_check' option (#1485857)

the last line before RELEASE 0.3-stable says:
- Fix rcube_mdb2::affected_rows() (#1486082)

and there are a total of 637 lines in the CHANGELOG file.

In the Installer

Check environment says:
=============================================
Checking PHP version

Version:  OK(PHP 5.3.0 detected)
Checking PHP extensions

The following modules/extensions are required to run RoundCube:

PCRE:  OK
DOM:  OK
Session:  OK
XML:  OK
The next couple of extensions are optional and recommended to get the best performance:

FileInfo:  OK
Libiconv:  OK
Multibyte:  OK
OpenSSL:  OK
Mcrypt:  NOT AVAILABLE(See PHP: Mcrypt Functions - Manual)
GD:  OK
Checking available databases

Check which of the supported extensions are installed. At least one of them is required.

MySQL:  OK
MySQLi:  OK
PostgreSQL:  NOT AVAILABLE(Not installed)
SQLite (v2):  OK
Check for required 3rd party libs

This also checks if the include path is set correctly.

PEAR:  OK
MDB2:  OK
Net_SMTP:  OK
Mail_mime:  OK
iilConnection:  OK
Checking php.ini/.htaccess settings

The following settings are required to run RoundCube:

file_uploads:  OK
session.auto_start:  OK
zend.ze1_compatibility_mode:  OK
mbstring.func_overload:  OK
suhosin.session.encrypt:  OK
The following settings are optional and recommended:

date.timezone:  NOT OK(Could be set)


Test config says:
=============================================
Check config files

main.inc.php:  OK
db.inc.php:  OK
Check if directories are writable

RoundCube may need to write/save files into these directories

temp/:  OK
logs/:  OK
Check configured database settings

DSN (write):  NOT OK(MDB2 Error: connect failed)
Make sure that the configured database exists and that the user has write privileges
DSN: mysql://roundcube:********@dbsrv.technolink.lu/roundcubemail

I'm using the same db.inc.php and main.inc.php that I'm using in my production environment on 10.5.8 (RC 0.3 stable). The MySQL database in my Snow Leopard test environment has been created by restoring a backup from the production environment.

Just to make sure, I have installed the MySQL GUI Tools on the same server I'm trying to run RoundCube and I am able to connect to the MySQL database and do selects, inserts, updates and deletes.

The MySQL version information from MySQL Admin is:
        MySQL Version: MySQL 5.0.82-log via TCP/IP
        Network Name: dbsrv.technolink.lu
        IP: 10.0.0.51

I there is any way I can help you debug the problem in MDB2 please let me know. I can easily produce a trace or log file.

Regards,

Alex

Offline aweirig

  • Jr. Member
  • **
  • Posts: 14
Roundcube 0.3 on Snow Leopard ??
« Reply #4 on: October 28, 2009, 03:57:40 AM »
Anything new on this issue?

Again, I'm more than willing to help in debugging and getting this problem fixed because it's becoming a showstopper for our Mac OS X 10.6 migration.

We have about 1000 users in RC and I don't want to have to switch to SquirrelMail because RC isn't working on 10.6.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Roundcube on Snow Leopard Server
« Reply #5 on: October 28, 2009, 06:15:09 AM »
You should open a ticket on Roundcube Webmail

Offline aweirig

  • Jr. Member
  • **
  • Posts: 14
Roundcube on Snow Leopard Server
« Reply #6 on: October 29, 2009, 09:55:52 AM »

Offline smultronstallet

  • Jr. Member
  • **
  • Posts: 11
Roundcube on Snow Leopard Server
« Reply #7 on: December 15, 2009, 05:43:44 PM »
Have you tried doing a completely pristine install? Fresh MySQL database and RoundCube config files and everything else? This would be helpful to see if it's an upgrade issue from your production RoundCube, or something else with your server. I'd recommend using the full trunk SVN, and not just bits and pieces put on the latest stable (if that's what I understood you said before).