[SOLVED] MySQL 64 bit package

Post here if you are a new Porteus member and you're looking for some help.
petr.name
Ronin
Ronin
Posts: 2
Joined: 15 May 2014, 18:41
Distribution: Porteus 3.0
Location: Ostrava

[SOLVED] MySQL 64 bit package

Post#1 by petr.name » 15 May 2014, 18:58

Hi there, I am running Porteus 3.0 64b and tried setup and run MySQL 64bit package downloaded from pkgs.org mysql-5.6.17-x86_64-1gds.txz (Slackware 14.1) and also tried mysql-5.5.27-x86_64-1.txz (Slackware 14.0) but struggling with some settings and errors still.
Do you know about some preconfigured MySQL 64b package for Porteus 3.0 64b?
Last edited by petr.name on 24 May 2014, 21:44, edited 1 time in total.

User avatar
fanthom
Moderator Team
Moderator Team
Posts: 5667
Joined: 28 Dec 2010, 02:42
Distribution: Porteus Kiosk
Location: Poland
Contact:

Re: MySQL 64 bit package

Post#2 by fanthom » 15 May 2014, 19:48

Slackware switched to mariadb so i would suggest using it (if possible in your setup).
Please add [Solved] to your thread title if the solution was found.

cttan
Shogun
Shogun
Posts: 333
Joined: 26 Jan 2011, 16:15
Distribution: Porteus 3.2 and 4.0 64bit KDE
Location: Malaysia

Re: MySQL 64 bit package

Post#3 by cttan » 16 May 2014, 06:47

Hi petr.name,

I have downloaded MySQL from http://ponce.cc/porteus/x86_64/modules-14.0/database/ but I think currently it is removed.

This is my script to start LAMP on my system.

Code: Select all

#!/bin/bash
echo "***************************************************"
echo "* Apache2, PHP and MySQL Setup and Initialization *"
echo "***************************************************"
# httpd packages and deps
activate /mnt/sdb1/useful_mods_xzm/apr-1.4.6-x86_64-1.xzm
activate /mnt/sdb1/useful_mods_xzm/apr-util-1.5.1-x86_64-1.xzm
activate /mnt/sdb1/useful_mods_xzm/db44-4.4.20-x86_64-3.xzm
activate /mnt/sdb1/useful_mods_xzm/httpd-2.4.6-x86_64-1_slack14.0.xzm
activate /mnt/sdb1/useful_mods_xzm/pcre-8.12-x86_64-1.xzm
# mysql packages and deps
activate /mnt/sdb1/useful_mods_xzm/libaio-0.3.109-x86_64-1.xzm
activate /mnt/sdb1/useful_mods_xzm/mysql-5.5.29-x86_64-1_slack14.0.xzm
# php packages and deps
activate /mnt/sdb1/useful_mods_xzm/enchant-1.6.0-x86_64-1.xzm
activate /mnt/sdb1/useful_mods_xzm/aspell-0.60.6-x86_64-1.xzm
activate /mnt/sdb1/useful_mods_xzm/net-snmp-5.7.2-x86_64-2.xzm
activate /mnt/sdb1/useful_mods_xzm/libmcrypt-2.5.8-x86_64-1.xzm
activate /mnt/sdb1/useful_mods_xzm/t1lib-5.1.2-x86_64-3.xzm
activate /mnt/sdb1/useful_mods_xzm/php-5.4.20-x86_64-1.xzm
sleep 2
# run install_db sciprt
/usr/bin/mysql_install_db
sleep 1
echo "Setting up MySQL ... Please be patient."
echo "* Setting up permissions on MySQL."
# settings up permission for folders
chown -R mysql:mysql /var/lib/mysql
chown -R mysql:mysql /var/run/mysql
ln -s /var/run/mysql/mysql.sock /tmp/mysql.sock
# Maybe you should uncomment this line when you run the first time. /etc/my-medium.cnf is sample config for medium size database.
#cp /etc/my-medium.cnf /etc/my.cnf
cp /mnt/sdb1/lamp/my.cnf /etc/.
sleep 1
echo "* Starting MySQL server."
while (true); do
  chmod 755 /etc/rc.d/rc.mysqld 
  /etc/rc.d/rc.mysqld start
  sleep 2
  if (pgrep mysqld) then
      break
  fi
done
sleep 1
##echo "* Starting Apache Web Server - CGI Mode."
echo "* Starting Apache Web Server ..."
# add user and setting permission for folders
mkdir -p /usr/var/
chmod 777 /usr/var
mkdir -p /srv/httpd/htdocs/avaya
chmod 777 /srv/httpd/htdocs/avaya
useradd www-data
usermod www-data -G www-data
chown -R www-data.www-data /var/www
# use find command to look for the sample http and php config files provided
cp -a /mnt/sdb1/lamp/httpd.conf /etc/httpd/.
cp -a /mnt/sdb1/lamp/php.ini /etc/httpd/.
sleep 1
while (true); do
  chmod 755 /etc/rc.d/rc.httpd
  /etc/rc.d/rc.httpd start
  sleep 2
  if (pgrep httpd) then
      break
  fi
done
# open localhost using your browser and you should see "It Works!" if everything is set correctly.
opera http://localhost/
exit

petr.name
Ronin
Ronin
Posts: 2
Joined: 15 May 2014, 18:41
Distribution: Porteus 3.0
Location: Ostrava

Re: MySQL 64 bit package

Post#4 by petr.name » 24 May 2014, 21:43

MariaDB (slackyd mariadb) works for me. Thanks

Post Reply