Roundcube Community Forum

 

Calendar Problem

Started by y2050, October 18, 2017, 04:24:46 AM

Previous topic - Next topic

y2050

Hi This is my first post here sorry if its not in roght place Im not sure.

I installed Kolab calendar 3.3.4 on Roundcube 1.3.1. CentOS6, and have a problem:
For any event I want to add in Calendar I got eeror: An Error occurred! Failed to save Changes.
Could you please help to solve this problem?

SKaero

Did you follow the install instructions in the README file? 

y2050

I guess yes.


There was an error on installation step 4: mysql roundcubemail < drivers/database/SQL/mysql.initial.sql
on restoring database I got warning session table already exist.

SKaero

Well without the database changes it obvious that you'd get the storage error. What happened when you tried to import the calendar sql file?

y2050

When I try to import calendar sql I will got this errors:

#mysql --user=da_admin --password="123456" da_roundcube < /var/www/html/roundcubemail-1.3.1/SQL/mysql.initial.sql
Warning: Using a password on the command line interface can be insecure.
ERROR 1050 (42S01) at line 8: Table 'session' already exists

# mysql --user=da_admin --password="123456" da_roundcube < /var/www/html/roundcubemail-1.3.1/SQL/mysql.initial.sql
Warning: Using a password on the command line interface can be insecure.
ERROR 1050 (42S01) at line 20: Table 'users' already exists

# mysql --user=da_admin --password="123456" da_roundcube < /var/www/html/roundcubemail-1.3.1/SQL/mysql.initial.sql
Warning: Using a password on the command line interface can be insecure.
ERROR 1050 (42S01) at line 37: Table 'cache' already exist


when I delete 'session' table and run again I will got same error for next table.And Im confused about it ;D

SKaero

You need to run the initial mysql file in the calendar plugin folder not the one for the Roundcube database.

y2050

Thankd you so much ;D.it worked after changing path:
# mysql --user=da_admin --password="123456" da_roundcube < /var/www/html/roundcube/plugins/calendar/drivers/kolab/SQL/mysql.initial.sql

y2050

I got new issue.

After plugin installed and I test it, I cant check mail, or preview from inbox/send items. this error will appear on click emai:

chrome:
x.x.x.x(Server IP) is currently unable to handle this request.
HTTP ERROR 500

its blank on firfox

SKaero

If I had to guess you mess up something in your Roundcube database while trying to reload the Roundcube database. If you can it may not be a bad idea to start from scratch to avoid such problems.

y2050

I really appritiate your help.

This is going to be more complicated for me. I tried installation steps in 2 other similar server and got exactly same problem. Reinstall plugin or roundcube was not helped, I tried to restore roundcubedb and one time I run the initial mysql of roundcube: mysql --user=da_admin --password="123456" da_roundcube < /roundcube/SQL/mysql.initial.sql with no result.

Only when I removing 'calendar', line from roundcube/config/config.inc.php and calendar disappears users can check mail.
What could be problem?

SKaero

Whats in the Roundcube error log?

y2050

Hi again and excuseme for comeback late, it was personal problems.
I will appritiate for help.

Error on: /var/www/html/roundcube/logs/errors
PHP Fatal error:  Class 'Sabre\VObject\Property\Text' not found in /var/www/html/roundcubemail-1.3.1/plugins/libcalendaring/libvcalendar.php on line 1432

and on libvcalendar.php line 1432 there is just a "{" charachter.

SKaero

You need to do step 2 in the install instructions:

2. Install the dependencies with Composer

(This has to be done from the Roundcube root directory)

  $ cd /<path-to-roundcube>
  $ php composer.phar require sabre/vobject 3.3.3

Download the composer.phar script from https://getcomposer.org

y2050

I download https://getcomposer.org/composer.phar to /<path-to-roundcube> as you said.
then run:php composer.phar require sabre/vobject 3.3.3   and got this error:

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20131226/php_ldap.dll' - /usr/local/lib/php/extensions/no-debug-non-zts-20131226/php_ldap.dll: cannot open shared object file: No such file or directory in Unknown on line 0
./composer.json has been updated
Loading composer repositories with package information                                                 Updating dependencies (including require-dev)         Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - pear/net_ldap2 v2.2.0 requires ext-ldap * -> the requested PHP extension ldap is missing from your system.
    - pear/net_ldap2 v2.2.0 requires ext-ldap * -> the requested PHP extension ldap is missing from your system.
    - Installation request for pear/net_ldap2 (installed at v2.2.0) -> satisfiable by pear/net_ldap2[v2.2.0].

  To enable extensions, verify that they are enabled in your .ini files:
    - /usr/local/lib/php.ini
    - /usr/local/lib/php.conf.d/50-webapps.ini
  You can also run `php --ini` inside terminal to see which files are used by PHP in CLI mode.

Installation failed, reverting ./composer.json to its original content.


So I enabled this: "extension=php_ldap.dll" on php.ini. and did not fount anything important on 50-webapps.ini
and restart httpd service but problem not solved and got the error again.

SKaero

It looks like you'd need to recompile PHP with the ldap module since its not installed.