I'm starting in aaPanel. I loved this panel. But, I have a problem with Roundcube. Steps: install 'one-clik deployment' - RoundCube install SSL.... ok Install mail DNS with app MAIL SERVER.... ok Error with database.... =( logs: DB Error: [1146] Table 'serv_bond_mail.session' doesn't exist (SQL Query: SELECT vars , ip , changed , now() AS ts, CASE WHEN changed < now() - INTERVAL 600 SECOND THEN 1 ELSE 0 END AS expired FROM session WHERE sess_id = 'xxxxxx') in /www/wwwroot/mail.bondcoisa.com/program/lib/Roundcube/rcube_db.php on line 566 (GET /) DB Error: [1146] Table 'serv_mail.session' doesn't exist (GET /) DB Error: [1146] Table 'serv_mail.session' doesn't exist (SQL Query: INSERT INTO session ( sess_id , vars , ip , changed ) VALUES ('xxxxxxx', 'MjoianF1ZXJ5X3VpX2NvbG9yc...7aToyO3M6MTA6InNtYWxs...WSI7', '201.19.111.141', now())) in /www/wwwroot/mail.bondcoisa.com/program/lib/Roundcube/rcube_db.php on line 566 (GET /) test telnet: Can anybody help me?

aaP_lordproducoesdigitais Hello, it prompts that the table in the database does not exist, have you made any changes? If it is a brand new RoundCube, it is recommended to check whether the database is normal and try to manually test a test database. If you try to delete the RoundCube site normally, is it possible to delete the data of the site and create it again? Be careful to delete after backup

aaPanel_Kern It's all empty. No emails. I already did this on another domain and it didn't work. But I can try again.

aaP_lordproducoesdigitais Is there mail in the mail server? Do suggest any errors?

aaPanel_Kern this? I'm using this one.

Mail Server Error

aaPanel_Kern

aaP_lordproducoesdigitais
yes

aaP_lordproducoesdigitais

aaPanel_Kern Is this problem unrelated to database access privileges? Could I create a new database for the email server (different from the website) and with a new password for this new database?

aaPanel_Kern

aaP_lordproducoesdigitais
The database will be automatically created during one-click deployment

aaP_lordproducoesdigitais

aaPanel_Kern yes.
So it's a configuration issue with OpenLiteSpeed

aaPanel_Kern

aaP_lordproducoesdigitais
Hello,
Check whether the configuration of the roundcube is correct? 135roundcubemail.com to your domain name
Modify this file:
/www/wwwroot/135roundcubemail.com/config/config.inc.php
Add the following:
$config['enable_installer'] = true;
Then the browser accesses: http://135roundcubemail.com/installer/?_step=1

aaP_lordproducoesdigitais

aaPanel_Kern ok. just minute

aaP_lordproducoesdigitais

aaPanel_Kern

DNS_PROBE_POSSIBLE

aaPanel_Kern

aaP_lordproducoesdigitais
look
135roundcubemail.com replace to your domain name

aaP_lordproducoesdigitais

aaPanel_Kern I didn't understand

aaP_lordproducoesdigitais

aaPanel_Kern

aaP_lordproducoesdigitais
Modify this file:
/www/wwwroot/135roundcubemail.com/config/config.inc.php
Add the following:
$config['enable_installer'] = true;

Please follow the instructions on the website to operate

aaP_lordproducoesdigitais

aaPanel_Kern OK I understand!!
There's a lot to install

`Checking PHP extensions
The following modules/extensions are required to run Roundcube:

PCRE: OK
DOM: OK
Session: OK
XML: OK
Intl: NOT OK(See https://www.php.net/manual/en/book.intl.php)
JSON: OK
PDO: OK
Multibyte: OK
OpenSSL: OK
Filter: OK
Ctype: OK
The next couple of extensions are optional and recommended to get the best performance:

cURL: OK
FileInfo: OK
Exif: OK
Iconv: OK
LDAP: NOT AVAILABLE(See https://www.php.net/manual/en/book.ldap.php)
GD: OK
Imagick: OK
Zip: OK
Checking available databases
Check which of the supported extensions are installed. At least one of them is required.

MySQL: OK
PostgreSQL: NOT AVAILABLE(See https://www.php.net/manual/en/ref.pdo-pgsql.php)
SQLite: OK
SQLite (v2): NOT AVAILABLE(See https://www.php.net/manual/en/ref.pdo-sqlite.php)
SQL Server (SQLSRV): NOT AVAILABLE(See https://www.php.net/manual/en/ref.pdo-sqlsrv.php)
SQL Server (DBLIB): NOT AVAILABLE(See https://www.php.net/manual/en/ref.pdo-dblib.php)
Oracle: NOT AVAILABLE(See https://www.php.net/manual/en/book.oci8.php)
Check for required 3rd party libs
This also checks if the include path is set correctly.

PEAR: OK
Auth_SASL: OK
Net_SMTP: OK
Mail_mime: OK
GuzzleHttp\Client: OK
Net_LDAP3: OK
Checking php.ini/.htaccess settings
The following settings are required to run Roundcube:

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

date.timezone: NOT OK(not set)
Sorry but your webserver does not meet the requirements for Roundcube!
Please install the missing modules or fix the php.ini settings according to the above check results.
Hint: only checks showing NOT OK need to be fixed.`

aaP_lordproducoesdigitais

aaPanel_Kern Ok,
I can not. Wouldn't there be another way to receive and send emails?

aaPanel_Kern

aaP_lordproducoesdigitais
Hi, openlitespeed php needs to install Intl manually. roundcube can only be used after the installation is complete
You can use other mail clients such as: foxmail, outlook, thunderbird

aaP_lordproducoesdigitais

aaPanel_Kern How to use one of these clients within aapanel?

aaP_lordproducoesdigitais

aaPanel_Kern I can't install anything else on ubuntu.

Error: E: Sub-process /usr/bin/dpkg returned an error code (1)

aaP_lordproducoesdigitais

apt-get install -y php-intl

Reading package lists... Done
Building dependency tree
Reading state information... Done
php-intl is already the newest version (2:7.4+75).
0 upgraded, 0 newly installed, 0 to remove and 9 not upgraded.
17 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
Setting up libapache2-mod-php7.4 (7.4.3-4ubuntu2.15) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package libapache2-mod-php7.4 (--configure):
installed libapache2-mod-php7.4 package post-installation script subprocess returned error exit status 1
Setting up php7.4-mbstring (7.4.3-4ubuntu2.15) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package php7.4-mbstring (--configure):
installed php7.4-mbstring package post-installation script subprocess returned error exit status 1
Setting up dbconfig-common (2.0.13) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package dbconfig-common (--configure):
installed dbconfig-common package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of php-mbstring:
php-mbstring depends on php7.4-mbstring; however:
Package php7.4-mbstring is not configured yet.

dpkg: error processing package php-mbstring (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of php-mail-mime:
php-mail-mime depends on php-mbstring; however:
Package php-mbstring is not configured yet.
Package php7.4-mbstring which provides php-mbstring is not configured yet.

dpkg: error processing package php-mail-mime (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of roundcube-core:
roundcube-core depends on dbconfig-common; however:
Package dbconfig-common is not configured yet.
roundcube-core depends on php-mbstring; however:
Package php-mbstring is not configured yet.
Package php7.4-mbstring which provides php-mbstring is not configured yet.
roundcube-core depends on php-mail-mime (>= 1.10.0); however:
Package php-mail-mime is not configured yet.

dpkg: error processing package roundcube-core (--configure):
dependency problems - leaving unconfigured
Setting up php7.4-pspell (7.4.3-4ubuntu2.15) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package php7.4-pspell (--configure):
installed php7.4-pspell package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of libapache2-mod-php:
libapache2-mod-php depends on libapache2-mod-php7.4; however:
Package libapache2-mod-php7.4 is not configured yet.

dpkg: error processing package libapache2-mod-php (--configure):
dependency problems - leaving unconfigured
Setting up php7.4-sqlite3 (7.4.3-4ubuntu2.15) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package php7.4-sqlite3 (--configure):
installed php7.4-sqlite3 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of roundcube-plugins:
roundcube-plugins depends on roundcube-core (= 1.4.3+dfsg.1-1); however:
Package roundcube-core is not configured yet.

dpkg: error processing package roundcube-plugins (--configure):
dependency problems - leaving unconfigured
Setting up php7.4-gd (7.4.3-4ubuntu2.15) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package php7.4-gd (--configure):
installed php7.4-gd package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of roundcube-plugins-extra:
roundcube-plugins-extra depends on roundcube-core (>= 1.3.8); however:
Package roundcube-core is not configured yet.

dpkg: error processing package roundcube-plugins-extra (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of php-pspell:
php-pspell depends on php7.4-pspell; however:
Package php7.4-pspell is not configured yet.

dpkg: error processing package php-pspell (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of roundcube:
roundcube depends on roundcube-core (= 1.4.3+dfsg.1-1); however:
Package roundcube-core is not configured yet.

dpkg: error processing package roundcube (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of php-sqlite3:
php-sqlite3 depends on php7.4-sqlite3; however:
Package php7.4-sqlite3 is not configured yet.

dpkg: error processing package php-sqlite3 (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of roundcube-sqlite3:
roundcube-sqlite3 depends on php-sqlite3; however:
Package php-sqlite3 is not configured yet.
Package php7.4-sqlite3 which provides php-sqlite3 is not configured yet.

dpkg: error processing package roundcube-sqlite3 (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of php-gd:
php-gd depends on php7.4-gd; however:
Package php7.4-gd is not configured yet.

dpkg: error processing package php-gd (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
libapache2-mod-php7.4
php7.4-mbstring
dbconfig-common
php-mbstring
php-mail-mime
roundcube-core
php7.4-pspell
libapache2-mod-php
php7.4-sqlite3
roundcube-plugins
php7.4-gd
roundcube-plugins-extra
php-pspell
roundcube
php-sqlite3
roundcube-sqlite3
php-gd
E: Sub-process /usr/bin/dpkg returned an error code (1)

...

dpkg --configure -a

Setting up libapache2-mod-php7.4 (7.4.3-4ubuntu2.15) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package libapache2-mod-php7.4 (--configure):
installed libapache2-mod-php7.4 package post-installation script subprocess returned error exit status 1
Setting up php7.4-mbstring (7.4.3-4ubuntu2.15) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package php7.4-mbstring (--configure):
installed php7.4-mbstring package post-installation script subprocess returned error exit status 1
Setting up dbconfig-common (2.0.13) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package dbconfig-common (--configure):
installed dbconfig-common package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of php-mbstring:
php-mbstring depends on php7.4-mbstring; however:
Package php7.4-mbstring is not configured yet.

dpkg: error processing package roundcube-plugins-extra (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevSetting up libapache2-mod-php7.4 (7.4.3-4ubuntu2.15) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package libapache2-mod-php7.4 (--configure):
installed libapache2-mod-php7.4 package post-installation script subprocess returned error exit status 1
Setting up php7.4-mbstring (7.4.3-4ubuntu2.15) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package php7.4-mbstring (--configure):
installed php7.4-mbstring package post-installation script subprocess returned error exit status 1
Setting up dbconfig-common (2.0.13) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing package dbconfig-common (--configure):
installed dbconfig-common package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of php-mbstring:
php-mbstring depends on php7.4-mbstring; however:
Package php7.4-mbstring is not configured yet.

aaP_lordproducoesdigitais

ok, thank you so much for yors time
Finished

aaPanel_Kern

aaP_lordproducoesdigitais
Hello, is the problem solved?

Artwork

Hello everyone,
I have error to set up mail server for my website, any one can solve?
here is screen shot
1) https://gyazo.com/fae3c6c5f638c452bfeed2efec59a436
2} https://gyazo.com/b7c004e995957e6018e6a29f3adc2603
3) https://gyazo.com/8ae9bbc6db45912cc4acc87814e80709

aaPanel_Kern

Hello, is it possible to try to apply using the website?

Artwork