Author Topic: Calendar Problem  (Read 4476 times)

Offline y2050

  • Jr. Member
  • **
  • Posts: 13
Calendar Problem
« 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?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,536
    • http://SKaero.com/
Re: Calendar Problem
« Reply #1 on: October 18, 2017, 12:28:23 PM »
Did you follow the install instructions in the README file? 

Offline y2050

  • Jr. Member
  • **
  • Posts: 13
Re: Calendar Problem
« Reply #2 on: October 19, 2017, 03:05:26 AM »
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.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,536
    • http://SKaero.com/
Re: Calendar Problem
« Reply #3 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?

Offline y2050

  • Jr. Member
  • **
  • Posts: 13
Re: Calendar Problem
« Reply #4 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

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,536
    • http://SKaero.com/
Re: Calendar Problem
« Reply #5 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.

Offline y2050

  • Jr. Member
  • **
  • Posts: 13
Re: Calendar Problem
« Reply #6 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

Offline y2050

  • Jr. Member
  • **
  • Posts: 13
Re: Calendar Problem
« Reply #7 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

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,536
    • http://SKaero.com/
Re: Calendar Problem
« Reply #8 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.

Offline y2050

  • Jr. Member
  • **
  • Posts: 13
Re: Calendar Problem
« Reply #9 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?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,536
    • http://SKaero.com/
Re: Calendar Problem
« Reply #10 on: October 23, 2017, 10:09:55 AM »
Whats in the Roundcube error log?

Offline y2050

  • Jr. Member
  • **
  • Posts: 13
Re: Calendar Problem
« Reply #11 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.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,536
    • http://SKaero.com/
Re: Calendar Problem
« Reply #12 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

Offline y2050

  • Jr. Member
  • **
  • Posts: 13
Re: Calendar Problem
« Reply #13 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.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,536
    • http://SKaero.com/
Re: Calendar Problem
« Reply #14 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.