Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

[eldon99]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

Scott,

Thank you so much! Greatly appreciated.

[Scot - ScotsScripts.com]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

Here are the two install files I have, I updated them for 5.22. No promises they work, and no real idea how they work!

[eldon99]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

I have been working on following this wonderful tutorial from Emma (my hats off to you for such hard work). I was able to find the installmiva.sh script, but I cannot find the installmivaservice.sh script. Does anyone who has followed the tutorial have a copy by chance?

[RayYates]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

Credit goes to Emma for mivascript.org

[eldon99]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

Rick, Ray and Emma,

Thank you as Ray put it for having that site up in the past. I love this community, it is a huge help.

So, I just remembered: WayBackMachine!!!
http://web.archive.org/web/201410180...nd_ubuntu.html

[Rick Wilson]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

We're definitely agreeable and willing to also assist in getting the .org back up if we can help.

[RayYates]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

It seems mivascript.org is offline, permanently or temporarily I can not say. Mivascript.org was a great resource and I personally implimented many of the techniques posted there. I want express my gratitude and thanks.

Perhaps if Emma is still following this thread and Rick Wilson is agreeable, the we can provide space for a new Article on MivaScript.com in the MS Advanced section of the webiste.

What do you think Emma? Would you be willing to add some content?

[Rick Wilson]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

We didn't own mivascript.org, and whoever did let it lapse. Have you tried googling that string?

[eldon99]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

Well, the page I had bookmarked in the past and try to visit was mivascript.org, not mivascript.com:

http://mivascript.org/install_miva_e...on_ubuntu.html

[Rick Wilson]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

Or did you mean to go to mivascript.com?

[Rick Wilson]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

It's definitely not out, thanks for notifying us that it's down. We'll get it fixed.

[eldon99]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

So here is the link: http://mivascript.org/install_miva_e...on_ubuntu.html

It looks like the mivascript.org site is down (hopefully not out). Will we see the above tutorial again, or is there a way I can get a copy? I remember bookmarking this for future reference, and now I am ready to take the plunge and the page is gone.

Any assistance is greatly appreciated.

Regards,

Eldon

[Scot - ScotsScripts.com]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

Related question- I'm trying to set up miva merchant in a new virtual host. I'm not sure about the email stuff, does the virtual host have email setup already? How would I create a new email address? I didn't install squirrel mail or any of that stuff, the tutorial said I didn't need to, but now I'm wondering.

[Scot - ScotsScripts.com]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

I finally got it to work.

First, I followed Emma's instructions (part 1) from this post:

http://extranet.mivamerchant.com/forums/showthread.php?102728-Tip-Can-t-connect-to-local-MySQL-server-through-socket-var-lib-mysql-mysql-sock

One note, I think it's important to first turn off mysql then restart it after the editing of the file is done. The first time I tried this and and tried to restart it after I updated the file all sorts of bad things happened.

service mysql stop
[ edit the file ]
service mysql start

Good Result- the miva script appears to be able to interact with the mysql table I created in phpmyadmin.

Bad Result - phpmyadmin and ispconfig are now both broken, however...

Fixing PHPMyAdmin:

Follow Emma's instructions for fixing PHPMyAdmin from this post (part 2):

http://extranet.mivamerchant.com/forums/showthread.php?102728-Tip-Can-t-connect-to-local-MySQL-server-through-socket-var-lib-mysql-mysql-sock

The only difference is that you want to edit a different file:

nano /usr/share/phpmyadmin/config.inc.php

and copy the following into it, changing 'localhost' with your server IP address:

/**
* MySQL hostname or IP address
*
* @global string $cfg['Servers'][$i]['host']
*/
$cfg['Servers'][$i]['host'] = 'localhost';

(simple things can be confusing to someone new to this like me, such as, do you leave the single quotes in or not? Yes. For example, if your ip is 123.123.123.123, it looks like '123.123.123.123')


Fixing ISPConfig:

And I feel pretty good being able to add something useful to this conversation all on my own.

Create (or edit if you have it) this file:

nano /usr/local/ispconfig/server/lib/config.inc.local.php

and add this line to it:

$conf['db_host'] = 'localhost';

change 'localhost' to your ip, in my case:

$conf['db_host'] = '125.215.193.50';

Then reload ISPConfig in your browser and it should work (it did for me.)

So now after a week of this stuff, it looks like I have a working miva server where everything is operating normally. I'm going head off to a tequila bar now.

One last note: when I restarted the server ISPConfig and PHPMyAdmin were broken again. I had to apply Emma's symlink again to get them to work (ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock)

I was able to make this link appear permanent by editing the rc.local file like this:

nano /etc/rc.local

Then add the symlink line to it and save:

ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock

Noobie Observation: After you restart the server and everything looks like it's done restarting, it actually takes a few more moments before everything works, around 30 seconds in my case. I tried to load ispconfig and phpadmin right after the server went up and the IP was not found. After a few moments of "what?" I tried again and all was well.

[Scot - ScotsScripts.com]

Re: Install Miva Empresa + Mysql5 + Apache2 Suexec + Php5 on Ubuntu

Mysql is definitely running, there is no doubt about that.

I've changed the permissions to the mysql folder to 777 just to make sure.

Still get:

MvOPEN: Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Is that file, /var/lib/mysql/mysql.sock, supposed to exist? It's not there, although in my research I've read that it's not always there, that it comes and goes as mysql needs it.

In another post Emma said to edit the my.cnf file - "search for 'socket = /var/run/mysqld/mysqld.sock' occurences and change with 'socket = /var/lib/mysql/mysql.sock'"

I tried that earlier but all it did was make it so I couldn't start or stop mysql and broke ispconfig and phpmyadmin. Although I'm tempted to try it again and this time stop mysql before I make those changes to see if there's any difference.

Mysql logs: there are no entries in the /var/log/mysql/error.log file that pertain to this; I just tried the miva script after changing permissions but the latest error log entry comes from 20 minutes before when I turned the machine on, and it's a [Note] entry that says "/usr/sbin/mysqld: ready for connections."

Any more troubleshooting, ideas, tips are more than welcome. Keep in my that I'm learning ubuntu from scratch here and I've only been messing with it for a week.