Update /etc/init.d/proxysql

[v0112358]

Hi,
The script /etc/init.d/proxysql for start/stop ProxySQL should be modified for store /var/run/proxysql/proxysql.sock

start() {
  echo -n "Starting ProxySQL: "
	mkdir $DATADIR 2>/dev/null
  getpid
  if [ "X$pid" = "X" ]
   then
                if [ -d /var/run/proxysql ]; then
                        chmod 1777 /var/run/proxysql
                else
                        mkdir /var/run/proxysql && chmod 1777 /var/run/proxysql
                fi
		if [ -f $OLDDATADIR/proxysql.db ]
		then
			if [ ! -f $DATADIR/proxysql.db ]
			then
				mv -iv $OLDDATADIR/proxysql.db $DATADIR/proxysql.db
                                chown proxysql $DATADIR/proxysql.db
			fi
		fi
	 	su - $USER -s /bin/bash -c "proxysql $OPTS"
		if [ "$?" = "0" ]; then
			echo "DONE!"
			return 0
		else
			echo "FAILED!"
			return 1
		fi
	else
		echo "ProxySQL is already running."
		exit 0
	fi
}

Env:

• CentOS 7.6.1810
• Proxysql-2.0.5-1.x86_64

[renecannao]

Assigning to @pondix

[pondix]

The init script is no longer used for the CentOS 7 build - this uses https://github.com/sysown/proxysql/blob/v2.0.7/systemd/system/proxysql.service instead.

Perhaps this still makes sense for CentOS 6 however the logic can still apply to the systemd unit file.

This will be considered for v2.0.8