This is an old revision of the document!
For the list of supported operating systems & application versions, refer to: Ahsay Software Compatibility List (SCL)
Please ensure that the following requirements and conditions are met on the MySQL database server.
Make sure that the following packages have to be present on the Linux machine in order for AhsayOBM version 8 to be installed.
AhsayOBM is installed on the MySQL database server using the root account.
Make sure the MySQL database instance is online.
Example: MySQL5.7 on CentOS 7
# service mysqld status Redirecting to /bin/systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since Wed 2019-01-02 11:42:08 HKT; 2h 46min ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Main PID: 16952 (mysqld) CGroup: /system.slice/mysqld.service └─16952 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/my... Jan 02 11:42:00 centos7 systemd[1]: Starting MySQL Server... Jan 02 11:42:08 centos7 systemd[1]: Started MySQL Server.
Check the listening port of the MySQL database instance (default is 3306).
#netstat -pan|more Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 1/systemd tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 21981/java tcp 0 0 192.168.122.1:53 0.0.0.0:* LISTEN 2489/dnsmasq tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1307/sshd tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 1110/cupsd tcp 0 0 127.0.0.1:60024 0.0.0.0:* LISTEN 21981/java tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 15556/master tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN 21981/java tcp 86 0 10.16.30.2:37272 203.186.85.237:443 CLOSE_WAIT 21981/java tcp 86 0 10.16.30.2:49302 40.114.13.14:443 CLOSE_WAIT 21981/java tcp 0 64 10.16.30.2:22 192.168.12.1:55777 ESTABLISHED 14094/sshd: root@pt tcp6 0 0 :::111 :::* LISTEN 1/systemd tcp6 0 0 :::22 :::* LISTEN 1307/sshd tcp6 0 0 ::1:631 :::* LISTEN 1110/cupsd tcp6 0 0 ::1:25 :::* LISTEN 15556/master tcp6 0 0 :::3306 :::* LISTEN 15671/mysqld tcp6 86 0 10.16.30.2:48396 10.16.30.21:443 CLOSE_WAIT 22347/bschJW tcp6 86 0 10.16.30.2:48428 10.16.30.21:443 CLOSE_WAIT 22347/bschJW
The mysqldump utility is installed on the MySQL database server. To locate the mysqldump utility use the whereis command:
#whereis mysqldump mysqldump: /usr/bin/mysqldump /usr/share/man/man1/mysqldump.1.gz
The mysqldump utility is the same version as the MySQL database.
i. mysqldump version
#mysqldump --version mysqldump Ver 10.13 Distrib 5.7.24, for Linux (x86_64)
ii. MySQL database version
mysql> select version(); +-----------+ | version() | +-----------+ | 5.7.24 | +-----------+ 1 row in set (0.00 sec)
i. mysqldump version
# mysqldump --version mysqldump Ver 8.0.11 for Linux on x86_64 (MySQL Community Server - GPL)
ii. MySQL database version
mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.11 | +-----------+ 1 row in set (0.00 sec)