ispconfig with mysql 5.7

Discussion in 'Installation/Configuration' started by hatted, Feb 28, 2016.

  1. hatted

    hatted New Member

    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
     
    Last edited: Feb 28, 2016
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. hatted

    hatted New Member

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

    hatted New Member

    should I sql_mode=NO_ENGINE_SUBSTITUTION to both MySQL servers?
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  6. hatted

    hatted New Member

    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/
     
  7. hatted

    hatted New Member

    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] []
     
  8. ztk.me

    ztk.me Active Member

  9. hatted

    hatted New Member

    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?
     
  10. ztk.me

    ztk.me Active Member

    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.
     
    Last edited: Mar 19, 2016
  11. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    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.
     
    ztk.me likes this.
  12. hatted

    hatted New Member

    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
    [email protected]:/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
    [email protected]:/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?
     
  13. hatted

    hatted New Member

    I just want to try if unison work in client web folder but got following error.
    [email protected]:/var/www/bean.com# touch a.txt
    touch: cannot touch ‘a.txt’: Permission denied​

    Just wonder why I cannot create file by root account?
     
  14. ztk.me

    ztk.me Active Member

    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.
     
  15. hatted

    hatted New Member

    but the folder belongs to root.

    [email protected]:/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


    [email protected]:/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
     
  16. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page