Installation of LAMP on Leap 42.3, Gnome Desktop.

English Applications
#1

Hi all,

Trying to install ‘cubecart’ an e-commerce application. Requires LAMP. While installing LAMP with help of an article from TechRepublic which explains installation on openSUSE Leap. It installs ‘appache2’ first and after installing, setting it up and testing, it goes on to install ‘mariadb’ which is a substitute for ‘mysql’. In the old days when I first took fancy to ‘linux’ from LSF & BLFS, there used to be a separate package ‘mysql’. But it seems openSUSE has gone on to ‘mariadb’ substitution. I am not an expert to ask why. I am sure the planners must have a reason for it.
Then other packages required are installed: php5, php5-mysql & apache2-mod_php5.
My problem is that the youtube demo (by linuxhelp.com) for installation of ‘cubecart’ requires the good old mysql prompt. For example:


root@linuxhelp:# mysql -u root -p
Enter Password
..............................................
(Some lines)
mysql>

With ‘mariadb’ substitution an empty database is already created by the name of ‘mariadb’. But ‘linuxhelp.com’ would work with a different database named ‘cubecart’ which is created by the following code:


mysql> create database cubecart;
Query OK 1 row affected (0.05 sec)

mysql>

And the demo keeps working with ‘mysql>’ prompt throughout. But with ‘mariadb’, I do not get this prompt.

I do not know how to get and install ‘pure’ mysql. If I install it from sources, will it fit into the LAMP configuration?

Guidance shall be most appreciated.

Regards,

RSP2

#2

You don’t need to install MySQL for Cubecart to work, MariaDB is a 100% compatible substitute.

Here is an example of how to create a database, user and start the Cubecart setup:


mysql -u root -p
create database cubecart;
grant all privileges on cubecart.* TO 'cooluser'@'localhost' identified by 'coolpassword';
flush privileges;
exit

As you can imagine, you need to change cooluser to something sensible and password to something you remember, these will be used during the Cubecart installation.

You’ll want to make sure these modules are installed - if you do not, the installation will error with HTTP 500; php5-ctype php5-json php5-mbstring php5-mysql php5-mcrypt php5-gd php5-curl php5-zip

If you install php5 or apache php module after installing Apache, it may not be activated and it won’t parse PHP but will offer to download it, in that case run; a2enmod php5 ; systemctl restart apache2

Your Cubecart installation will require a bunch of directories to be writable:


backup/cache/
cache/skin/
files/
images/
images/cache/
images/logos/
images/source/
includes/
includes/extra/
language/

It’s easiest if you change the ownership of these directories to wwwrun (and all files inside them) with chown -R wwwrun /path/to/cubecart/directorythatneedspermissions

After this you can point your browser to your Apache webserver and the cubecart directory and it should guide you through the installation. DB server is naturally localhost, db cubecart and user what you put in earlier.

#3

Mariadb is a fork of MySQL by the creators of MySQL. Commands are the same. So invoke

mysql -u root -p

But, I don’t know what you did to setup mariadb/mysql. If nothing, then first run

mysql_secure_installation

as root.
Another suggestion: install phpMyAdmin after this. Then go http://localhost/phpMyAdmin or http://ip-addr-of-host/phpMyAdmin. Log in and you can create databases, users, modify permissions etc. Even run queries

BTW: openSUSE packagemanagement works with "patterns’’ packages. Select the LAMP pattern in YaST’s softwaremanager and it will do the job for you incl all needed for a LAMP server. It will also install a YaST2 module for setting up your webserver.

#4

Thanks a lot to Miuku & Knurpht for their very clear guidance.

Shall do likewise.

Regards,

RSP2