Hi,
I have a fresh installation - VPS.
Initially the webmail is working correctly. It stops to work after any kind of update. What am I missing?
I'm getting an error when trying to open the roundcube:
ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
I reconstructed the VPS several time in order test and i'm getting to the same point each time i'm doing any updates.
It works at the beginning - after reconstruction.
Initially I wanted to change php to 7.3. and update DirectAdmin.. and each time I tried it stopped to work.
Details of the installation are to find below.
And webmail stops to work. (Tried all the options I could find: https://help.directadmin.com/item.php?id=206..
Can you help me?
Now after reconstruction i’m simply running build roundcube:
/usr/local/directadmin/custombuild# ./build roundcube
/usr/local/mysql/bin/mysqlshow: Access denied for user 'da_admin'@'localhost' (using password: YES)
Inserting data to mysql and creating database/user for roundcube...
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_roundcube'@'localhost' (using password: YES)
Database created, da_roundcube password is XXXXXXX
Editing roundcube configuration...
Replacing mod_php5 with mod_php7 in .htaccess
Roundcube 1.3.2 has been installed successfully.
Executing database schema update.
ERROR: SQLSTATE[HY000] [1045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)Error 500: Error connecting to database: SQLSTATE[HY000] [1045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)
root@server922456:/usr/local/directadmin/custombuild# ./build roundcube
/usr/local/mysql/bin/mysqlshow: Access denied for user 'da_admin'@'localhost' (using password: YES)
Inserting data to mysql and creating database/user for roundcube...
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_roundcube'@'localhost' (using password: YES)
Database created, da_roundcube password is XXXXXXXX
Editing roundcube configuration...
Replacing mod_php5 with mod_php7 in .htaccess
Roundcube 1.3.2 has been installed successfully.
Executing database schema update.
ERROR: SQLSTATE[HY000] [1045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)Error 500: Error connecting to database: SQLSTATE[HY000] [1 045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)
------------------------------------------
Initial settings:
Debian9
Version: DirectAdmin v.1.52.1
cat options.conf:
#PHP Settings
php1_release=7.0
php1_mode=php-fpm
php2_release=no
php2_mode=php-fpm
opcache=no
htscanner=no
php_ini=no
php_timezone=Europe/Warsaw
php_ini_type=production
ioncube=no
zend=no
suhosin=no
x_mail_header=yes
#MySQL Settings
mysql=5.6
mariadb=10.0
mysql_inst=no
mysql_backup=yes
mysql_backup_gzip=no
mysql_backup_dir=/usr/local/directadmin/custombuild/mysql_backups
mysql_force_compile=no
#WEB Server Settings
webserver=apache
http_methods=GET:HEAD
OST
litespeed_serialno=trial
modsecurity=no
modsecurity_ruleset=comodo
apache_ver=2.4
apache_mpm=auto
mod_ruid2=no
userdir_access=yes
harden_symlinks_patch=yes
use_hostname_for_alias=no
redirect_host=server922456
redirect_host_https=no
#WEB Applications Settings
phpmyadmin=yes
phpmyadmin_ver=4
squirrelmail=no
roundcube=yes
webapps_inbox_prefix=no
#ClamAV-related Settings
clamav=no
clamav_exim=yes
modsecurity_uploadscan=no
proftpd_uploadscan=no
pureftpd_uploadscan=no
suhosin_php_uploadscan=no
#Mail Settings
exim=no
eximconf=no
eximconf_release=4.5
blockcracking=no
easy_spam_fighter=no
spamd=no
sa_update=daily
dovecot=yes
dovecot_conf=yes
pigeonhole=no
#FTP Settings
ftpd=pureftpd
#Statistics Settings
awstats=no
webalizer=yes
#CustomBuild Settings
custombuild=2.0
autover=no
bold=yes
clean=yes
cleanapache=yes
clean_old_tarballs=yes
clean_old_webapps=yes
downloadserver=files24.directadmin.com
#Cronjob Settings
cron=no
cron_frequency=weekly
email=[email protected]
notifications=yes
da_autoupdate=no
updates=no
webapps_updates=yes
#CloudLinux Settings
cloudlinux=no
cloudlinux_beta=no
cagefs=no
#Advanced Settings
autoconf=yes
automake=yes
libtool=yes
curl=yes
new_pcre=no
---------------------------------
service mysqld status
● mysqld.service - MySQL database server
Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2020-04-06 11:18:04 CEST; 45min ago
Main PID: 2190 (mysqld_safe)
Tasks: 33 (limit: 4915)
CGroup: /system.slice/mysqld.service
├─2190 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/
└─2290 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/dat
Apr 06 11:18:04 server922456 systemd[1]: mysqld.service: Main process exited, code=killed, status=9/KIL
Apr 06 11:18:04 server922456 systemd[1]: Stopped MySQL database server.
Apr 06 11:18:04 server922456 systemd[1]: mysqld.service: Unit entered failed state.
Apr 06 11:18:04 server922456 systemd[1]: mysqld.service: Failed with result 'timeout'.
Apr 06 11:18:04 server922456 systemd[1]: Started MySQL database server.
Apr 06 11:18:05 server922456 mysqld_safe[2190]: 200406 11:18:05 mysqld_safe Logging to '/usr/local/mysq
Apr 06 11:18:05 server922456 mysqld_safe[2190]: 200406 11:18:05 mysqld_safe Starting mysqld daemon with
lines 1-16/16 (END)
I have a fresh installation - VPS.
Initially the webmail is working correctly. It stops to work after any kind of update. What am I missing?
I'm getting an error when trying to open the roundcube:
ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
I reconstructed the VPS several time in order test and i'm getting to the same point each time i'm doing any updates.
It works at the beginning - after reconstruction.
Initially I wanted to change php to 7.3. and update DirectAdmin.. and each time I tried it stopped to work.
Details of the installation are to find below.
And webmail stops to work. (Tried all the options I could find: https://help.directadmin.com/item.php?id=206..
Can you help me?
Now after reconstruction i’m simply running build roundcube:
/usr/local/directadmin/custombuild# ./build roundcube
/usr/local/mysql/bin/mysqlshow: Access denied for user 'da_admin'@'localhost' (using password: YES)
Inserting data to mysql and creating database/user for roundcube...
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_roundcube'@'localhost' (using password: YES)
Database created, da_roundcube password is XXXXXXX
Editing roundcube configuration...
Replacing mod_php5 with mod_php7 in .htaccess
Roundcube 1.3.2 has been installed successfully.
Executing database schema update.
ERROR: SQLSTATE[HY000] [1045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)Error 500: Error connecting to database: SQLSTATE[HY000] [1045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)
root@server922456:/usr/local/directadmin/custombuild# ./build roundcube
/usr/local/mysql/bin/mysqlshow: Access denied for user 'da_admin'@'localhost' (using password: YES)
Inserting data to mysql and creating database/user for roundcube...
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_roundcube'@'localhost' (using password: YES)
Database created, da_roundcube password is XXXXXXXX
Editing roundcube configuration...
Replacing mod_php5 with mod_php7 in .htaccess
Roundcube 1.3.2 has been installed successfully.
Executing database schema update.
ERROR: SQLSTATE[HY000] [1045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)Error 500: Error connecting to database: SQLSTATE[HY000] [1 045] Access denied for user 'da_roundcube'@'localhost' (using password: YES)
------------------------------------------
Initial settings:
Debian9
Version: DirectAdmin v.1.52.1
cat options.conf:
#PHP Settings
php1_release=7.0
php1_mode=php-fpm
php2_release=no
php2_mode=php-fpm
opcache=no
htscanner=no
php_ini=no
php_timezone=Europe/Warsaw
php_ini_type=production
ioncube=no
zend=no
suhosin=no
x_mail_header=yes
#MySQL Settings
mysql=5.6
mariadb=10.0
mysql_inst=no
mysql_backup=yes
mysql_backup_gzip=no
mysql_backup_dir=/usr/local/directadmin/custombuild/mysql_backups
mysql_force_compile=no
#WEB Server Settings
webserver=apache
http_methods=GET:HEAD
OSTlitespeed_serialno=trial
modsecurity=no
modsecurity_ruleset=comodo
apache_ver=2.4
apache_mpm=auto
mod_ruid2=no
userdir_access=yes
harden_symlinks_patch=yes
use_hostname_for_alias=no
redirect_host=server922456
redirect_host_https=no
#WEB Applications Settings
phpmyadmin=yes
phpmyadmin_ver=4
squirrelmail=no
roundcube=yes
webapps_inbox_prefix=no
#ClamAV-related Settings
clamav=no
clamav_exim=yes
modsecurity_uploadscan=no
proftpd_uploadscan=no
pureftpd_uploadscan=no
suhosin_php_uploadscan=no
#Mail Settings
exim=no
eximconf=no
eximconf_release=4.5
blockcracking=no
easy_spam_fighter=no
spamd=no
sa_update=daily
dovecot=yes
dovecot_conf=yes
pigeonhole=no
#FTP Settings
ftpd=pureftpd
#Statistics Settings
awstats=no
webalizer=yes
#CustomBuild Settings
custombuild=2.0
autover=no
bold=yes
clean=yes
cleanapache=yes
clean_old_tarballs=yes
clean_old_webapps=yes
downloadserver=files24.directadmin.com
#Cronjob Settings
cron=no
cron_frequency=weekly
email=[email protected]
notifications=yes
da_autoupdate=no
updates=no
webapps_updates=yes
#CloudLinux Settings
cloudlinux=no
cloudlinux_beta=no
cagefs=no
#Advanced Settings
autoconf=yes
automake=yes
libtool=yes
curl=yes
new_pcre=no
---------------------------------
service mysqld status
● mysqld.service - MySQL database server
Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2020-04-06 11:18:04 CEST; 45min ago
Main PID: 2190 (mysqld_safe)
Tasks: 33 (limit: 4915)
CGroup: /system.slice/mysqld.service
├─2190 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/
└─2290 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/dat
Apr 06 11:18:04 server922456 systemd[1]: mysqld.service: Main process exited, code=killed, status=9/KIL
Apr 06 11:18:04 server922456 systemd[1]: Stopped MySQL database server.
Apr 06 11:18:04 server922456 systemd[1]: mysqld.service: Unit entered failed state.
Apr 06 11:18:04 server922456 systemd[1]: mysqld.service: Failed with result 'timeout'.
Apr 06 11:18:04 server922456 systemd[1]: Started MySQL database server.
Apr 06 11:18:05 server922456 mysqld_safe[2190]: 200406 11:18:05 mysqld_safe Logging to '/usr/local/mysq
Apr 06 11:18:05 server922456 mysqld_safe[2190]: 200406 11:18:05 mysqld_safe Starting mysqld daemon with
lines 1-16/16 (END)
