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
Ensure that the sql_mode line in my.cnf file is like this: sql_mode=NO_ENGINE_SUBSTITUTION and that it does not contain STRICT_TRANS_TABLES. And dont install PHP 7 like this, it will cause the system to fail. For PHP 7, see here: https://www.howtoforge.com/tutorial/how-to-install-php-7-on-debian/
Yes, I install PHP 7 by following your page as above. Should I install PHP 7 after installed ISPconfig first?
You can't have installed PHP before you installed ISPCOnfig as the guide tells you to do some of the steps in the ISPConfig UI. It has to be set in the mysql server that is used by ISPConfig.
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 web3I 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
Thats correct, the client5 folder has to be owned by root. Only the "web" folder and a few other sub folders inside www/clients/client5/web5/ are owned by user web5. Your problem seems to be that the ispconfig mirroring is not working yet or you setup the mirror aftre you created sites on server1, the result is that the web5 user is missing in /etc/passwd and /etc/shadow and therefor unison cant sync the files for that user.
