Roundcube Community Forum

Third Party Contributions => API Based Plugins => Topic started by: y2050 on October 18, 2017, 04:24:46 AM

Title: Calendar Problem
Post by: y2050 on October 18, 2017, 04:24:46 AM

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?

Title: Re: Calendar Problem
Post by: SKaero on October 18, 2017, 12:28:23 PM

Did you follow the install instructions in the README file? 

Title: Re: Calendar Problem
Post by: y2050 on October 19, 2017, 03:05:26 AM

I guess yes.
(https://img2.brain3.photobox.com/5509896933f93291d6bf3e0569fa3ee37c80a159cf39bbb3f1a6a5a121e1ff395fb2a881.jpg)

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.

Title: Re: Calendar Problem
Post by: SKaero on October 19, 2017, 02:20:40 PM

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?

Title: Re: Calendar Problem
Post by: y2050 on October 21, 2017, 09:50:58 AM

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

Code: [Select]

#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

Title: Re: Calendar Problem
Post by: SKaero on October 21, 2017, 11:58:15 AM

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

Title: Re: Calendar Problem
Post by: y2050 on October 22, 2017, 05:54:45 AM

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

Title: Re: Calendar Problem
Post by: y2050 on October 22, 2017, 10:41:28 AM

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

Title: Re: Calendar Problem
Post by: SKaero on October 22, 2017, 01:21:01 PM

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.

Title: Re: Calendar Problem
Post by: y2050 on October 23, 2017, 06:03:45 AM

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:

Code: [Select]

mysql --user=da_admin --password="123456" da_roundcube < /roundcube/SQL/mysql.initial.sql with no result.

Only when I removing

Code: [Select]

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

Title: Re: Calendar Problem
Post by: SKaero on October 23, 2017, 10:09:55 AM

Whats in the Roundcube error log?

Title: Re: Calendar Problem
Post by: y2050 on November 20, 2017, 06:12:30 AM

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

Error on: /var/www/html/roundcube/logs/errors

Code: [Select]

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.

Title: Re: Calendar Problem
Post by: SKaero on November 20, 2017, 07:42:22 AM

You need to do step 2 in the install instructions:

Code: [Select]

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


Title: Re: Calendar Problem
Post by: y2050 on November 20, 2017, 08:38:46 AM

I download https://getcomposer.org/composer.phar to /<path-to-roundcube> as you said.
then run:

Code: [Select]

php composer.phar require sabre/vobject 3.3.3   and got this error:

Code: [Select]

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.

Title: Re: Calendar Problem
Post by: SKaero on November 20, 2017, 08:53:19 AM

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

Title: Re: Calendar Problem
Post by: y2050 on November 21, 2017, 04:13:07 AM

I recomplied with no success.
Should I copy dll from somewhere to server?

Code: [Select]

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

Code: [Select]

# rpm -qa | egrep "(ldap)"
openldap-2.4.40-16.el6.x86_64

Title: Re: Calendar Problem
Post by: SKaero on November 21, 2017, 10:52:59 AM

What OS are you running?

Title: Re: Calendar Problem
Post by: y2050 on November 23, 2017, 02:06:12 AM

Its CentOS-6-64bit, and I dont know why its looking for dll file!

Title: Re: Calendar Problem
Post by: SKaero on November 23, 2017, 02:41:02 PM

Have you installed php-ldap?

Title: Re: Calendar Problem
Post by: y2050 on November 25, 2017, 10:09:08 AM

I guess yes:

Code: [Select]

rpm -qa | egrep "(ldap|sasl)"
cyrus-sasl-devel-2.1.23-15.el6_6.2.x86_64
openldap-2.4.40-16.el6.x86_64
cyrus-sasl-lib-2.1.23-15.el6_6.2.x86_64
cyrus-sasl-2.1.23-15.el6_6.2.x86_64But in php:

Code: [Select]

# php -i | egrep "^(ldap|sasl)" -i
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

Title: Re: Calendar Problem
Post by: SKaero on November 25, 2017, 02:31:55 PM

There is a "php-ldap" package that has the module for php, you need to install it.

Title: Re: Calendar Problem
Post by: y2050 on November 26, 2017, 07:02:36 AM

Thanks again. I found there was a limit on yum.conf and removed exclude= php* so I installed php-ldap with yum.
But the dll problem is not solved:

Code: [Select]

# 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


Title: Re: Calendar Problem
Post by: SKaero on November 27, 2017, 01:28:12 AM

If you added the php_ldap.dll manually you should remove it since it clearly pointing to a file that doesn't exist.

Title: Re: Calendar Problem
Post by: y2050 on November 27, 2017, 08:44:17 AM

No I didnt add, there is no file in this path.

Title: Re: Calendar Problem
Post by: SKaero on November 27, 2017, 02:02:10 PM

Then find where "no-debug-non-zts-20131226/php_ldap.dll" is referenced in your php.ini config and remove it.