ispconfig with mysql 5.7

I can install MySQL 5.5 and PHP 5.6 in Debian 8.2 with ispconfig successfully. but now I installed MySQL 5.7 by following the https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ and PHP 7. When I install the ispconfig in the last step without any errors, but I found it only install 5 tables in the db. Is it working with MySQL 5.5 only, but not working with MySQL 5.7?

aps_instances
aps_instances_settings
aps_packages
aps_settings
attempts_login


###############
## mysql step
# wget http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.deb
# dpkg -i mysql-apt-config_0.6.0-1_all.deb
#### select install all MySQL tools and utilities

# apt-get update
# apt-get install mysql-server
# service mysql status
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled)
Active: active (running) since Fri 2016-02-26 12:50:38 HKT; 8s ago
Main PID: 1809 (mysqld_safe)
CGroup: /system.slice/mysql.service
├─1809 /bin/sh /usr/bin/mysqld_safe
└─2064 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=/var/...

Feb 26 12:50:36 server14a.a.com mysqld_safe[1809]: 2016-02-26T04:50:36.901795Z mysqld_safe Logging to '/var/log/mys...log'.

Feb 26 12:50:36 server14a.a.com mysqld_safe[1809]: 2016-02-26T04:50:36.986701Z mysqld_safe Starting mysqld daemon w...mysql


#### check mysql version
# mysql -uroot -p --version
mysql Ver 14.14 Distrib 5.7.11, for Linux (x86_64) using EditLine wrapper

 

Yes, I install PHP 7 by following your page as above. Should I install PHP 7 after installed ISPconfig first?

 

should I sql_mode=NO_ENGINE_SUBSTITUTION to both MySQL servers?

 

Great. It works. Now both servers database sync. I created an account in server1 and now both servers dbispconfig1 sync. However, I found there is nothing in dbispconfig2. It is normal?


However, I cannot run unison. It has error.

Failed [www/clients/client3/web3/cgi-bin]: No user web3
Failed [www/clients/client3/web3/private]: No user web3
Failed [www/clients/client3/web3/tmp]: No user web3
Failed [www/clients/client3/web3/webdav]: No user web3
3% 00:00 ETAFailed [www/php-fcgi-scripts/web3]: No user web3
100% 00:00 ETAFailed [www/clients/client3/web3/web]: No user web3​

I found that the passwd in both server are not sync. do I need to setup unison to sync myself like this website?
http://www.linuxtutorial.co.uk/install-and-configure-unison-ubuntu-ispconfig3/

 

also, I can connect FTP but not able to list directory. I tried both Active and Passive connection. I can connect to the DB from pureftp config file. I also find the user in the dbispconfig -> ftpusers

Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [INFO] New connection from 10.0.5.1
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [auth] [TLS]
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [INFO] SSL/TLS: Enabled TLSv1/SSLv3 with AES256-GCM-SHA384, 256 secret bits cipher
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [user] [domainwww]
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [pass] [<*>]
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [INFO] domainwww is now logged in
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [opts] [UTF8 ON]
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [pbsz] [0]
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [prot] [P]
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [pwd] []
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [type]
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [pasv] []
Mar 19 01:40:26 server14a pure-ftpd: ([email protected]) [DEBUG] Command [mlsd] []
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [INFO] New connection from 10.0.5.1
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [auth] [TLS]
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [INFO] SSL/TLS: Enabled TLSv1/SSLv3 with AES256-GCM-SHA384, 256 secret bits cipher
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [user] [domainwww]
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [pass] [<*>]
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [INFO] domainwww is now logged in
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [opts] [UTF8 ON]
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [pbsz] [0]
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [prot] [P]
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [pwd] []
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [type]
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [pasv] []
Mar 19 01:40:46 server14a pure-ftpd: ([email protected]) [DEBUG] Command [mlsd] []​

 

If the linux users are not synced, there's no way it can work.
You pobably can adopt most steps from the following howto to your setup
https://www.howtoforge.com/installi...tabase-cluster-on-debian-6.0-with-ispconfig-3

Take special attention to the last page
https://www.howtoforge.com/installi...ase-cluster-on-debian-6.0-with-ispconfig-3-p5

 

Thanks reminding, ztk. Do I set this steps to both servers or just server2?
Then open System > Server Config and enable the checkbox "Connect Linux userid to webid" on the "Web" tab:

so now after I enable this, do I need to remove the web3 site and users, and then create a new one again?

 

I didn't try this - to be on the save side, yep do it - but for a 100% answer, some would need to try that on a test-system or ask @till for instance.

Edit: I meant wether recreating the user is needed.

 

Enable "Connect Linux userid to webid" on both servers. A websites the userid during websiite-creation.
You can delete and re-create the website or change the client. Both should create the site with a new user-id.

 

Thanks florian030. I have checked the "Connect Linux userid to webid", and delete and recreate the web, but still the same problem.

# unison
Failed [www/clients/client5/web5/cgi-bin]: No user web5
Failed [www/clients/client5/web5/private]: No user web5
Failed [www/clients/client5/web5/tmp]: No user web5
Failed [www/clients/client5/web5/webdav]: No user web5​

then in server1a

root@server1a:/var/www/bean.com# ls -al
total 36
drwxr-xr-x 9 root root 4096 Mar 20 09:53 .
drwxr-xr-x 3 root root 4096 Mar 20 09:53 ..
drwxr-xr-x 2 web5 client5 4096 Mar 20 09:53 cgi-bin
drwxr-xr-x 2 root root 4096 Mar 20 09:53 log
drwx--x--- 2 web5 client5 4096 Mar 20 09:53 private
drwxr-xr-x 2 root root 4096 Mar 20 09:53 ssl
drwxrwx--- 2 web5 client5 4096 Mar 20 09:53 tmp
drwx--x--x 4 web5 client5 4096 Mar 20 09:53 web
drwx--x--- 2 web5 client5 4096 Mar 20 09:53 webdav​

and server1b

root@server14b:/var/www/redbeanice.com# ls -al
total 36
drwxr-xr-x 9 root root 4096 Mar 20 09:55 .
drwxr-xr-x 3 root root 4096 Mar 20 09:53 ..
drwxr-xr-x 2 root root 4096 Mar 20 09:55 log
drwxr-xr-x 2 root root 4096 Mar 20 09:53 ssl
drwxr-xr-x 2 root root 4096 Mar 20 09:55 .unison.cgi-bin.68d36f30f754761de04c87df7a59988f.unison.tmp
drwxr-xr-x 2 root root 4096 Mar 20 09:55 .unison.private.68d36f30f754761de04c87df7a59988f.unison.tmp
drwxr-xr-x 2 root root 4096 Mar 20 09:55 .unison.tmp.68d36f30f754761de04c87df7a59988f.unison.tmp
drwxr-xr-x 3 root root 4096 Mar 20 10:23 .unison.web.68d36f30f754761de04c87df7a59988f.unison.tmp
drwxr-xr-x 2 root root 4096 Mar 20 09:55 .unison.webdav.68d36f30f754761de04c87df7a59988f.unison.tmp​

Is there anything I missed?

 

I just want to try if unison work in client web folder but got following error.

root@server1a:/var/www/bean.com# touch a.txt
touch: cannot touch ‘a.txt’: Permission denied​

Just wonder why I cannot create file by root account?

 

Is server1b a mirror for webserver? I never played with that setting since I never used ISPConfig on servers having a need of high avail yet.
Permissions on $home-folders for websites can be set immuteable at server web-configuration, perfectly normal.

 

but the folder belongs to root.

root@server1a:/var/www/clients$ ls -al
total 12
drwxr-xr-x 3 root root 4096 Mar 20 09:53 .
drwxr-xr-x 8 root root 4096 Mar 21 10:55 ..
drwxr-xr-x 3 root root 4096 Mar 20 09:53 client5


root@server1a:/var/www/clients/client5$ ls -al
drwxr-xr-x 3 root root 4096 Mar 20 09:53 .
drwxr-xr-x 3 root root 4096 Mar 20 09:53 ..
lrwxrwxrwx 1 root root 30 Mar 20 09:53 bean.com -> /var/www/clients/client5/web5/
drwxr-xr-x 9 root root 4096 Mar 20 09:53 web5