Author Topic: Error  (Read 259 times)

Offline L0LIpOp

  • Newbie
  • *
  • Posts: 2
Error
« on: June 08, 2020, 08:55:55 PM »
After I follow the tutorial https://www.digitalocean.com/community/tutorials/how-to-install-your-own-webmail-client-with-roundcube-on-ubuntu-16-04 I got an error after running
 mysql -u roundcube -p roundcubemail < /var/www/roundcube/SQL/mysql.initial.sql

ERROR 1064 (42000) at line 212: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio n for the right syntax to use near 'system (name, value) VALUES ('roundcube-version', '2016112200')' at line 1

Offline alec

  • Hero Member
  • *****
  • Posts: 1,200
Re: Error
« Reply #1 on: June 09, 2020, 02:10:16 AM »
Don't install 1.3.0, use most recent version.

Offline L0LIpOp

  • Newbie
  • *
  • Posts: 2
Re: Error
« Reply #2 on: June 09, 2020, 08:58:15 AM »
Thank you for your reply. What to do in this stage of installation? There is a tutorial how to install Roundcube the latest version without giving any errors?
« Last Edit: June 09, 2020, 09:18:42 AM by L0LIpOp »

Offline Mailman

  • Jr. Member
  • **
  • Posts: 11
Re: Error
« Reply #3 on: June 12, 2020, 12:49:42 AM »
Here's a quick install howto for Ubuntu 18.04, and it's based on a clean install of the server.

Code: [Select]
# Prerequisites for Ubuntu 18.04
sudo apt install mariadb-server postfix dovecot-imapd dovecot-sieve dovecot-managesieved dovecot-solr\
 apache2 libapache2-mod-php7.2 php7.2 php7.2-mysql php-pear php-net-smtp php7.2-intl php-net-idna2 php-net-ldap3\
 php-mdb2 php-mail php-mail php-mail-mime php7.2-gd php-imagick php7.2-ldap php7.2-zip libidn2-0 composer git node-less

# Roundcube download
wget https://github.com/roundcube/roundcubemail/releases/download/1.4.6/roundcubemail-1.4.6-complete.tar.gz
# Web part
sudo tar xzf roundcubemail-1.4.6-complete.tar.gz -C /var/www/
sudo mv /var/www/roundcubemail* /var/www/roundcubemail
sudo chown -R www-data:www-data /var/www/roundcubemail
sudo sed -i 's/\/var\/www\/html/\/var\/www\/roundcubemail/g' /etc/apache2/sites-enabled/000-default.conf
sudo cp /var/www/roundcubemail/config/config.inc.php.sample /var/www/roundcubemail/config/config.inc.php
# Database
sudo mysql -e"create database roundcube CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;use roundcube;grant all privileges on roundcube.* to 'roundcube'@'localhost' IDENTIFIED BY 'FILL-IN-YOUR-PASSWORD';"
sudo mysql -e "USE roundcube; SOURCE /var/www/roundcubemail/SQL/mysql.initial.sql;"
# PHP
sudo sed -i 's/date.timezone = /date.timezone = Europe\/Amsterdam/g' /etc/php/7.2/apache2/php.ini # Use your location
sudo systemctl reload apache2.service