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

[Emma]

Hi everyone,

For those who are willing to work with Ubuntu Desktop 10, I wrote a tutorial on how to make it happen.

It's a copy paste tutorial and hopefully it will help others to create a "production-like" environment. My challenge was the following:

1. To be able to add as many virtual hosts (VH) in seconds
2. To be able to access each VH by a domain name (and subdomains: like
proj1.mydomain.com, proj2.mydomain.com)
3. To be able to work and compile each Miva Script project from my Windows 7 machine ( I still use Homesite and I don't want to change that for the moment )
4. To be able to access and modify from my Windows machine all the projects files and directories without restriction.

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

Don't hesitate if you have questions

Cheers,
Claudiu

[PicturesqueWeb]

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

Excellent! Can't wait to have time to try it. Thank you for sharing this information.

[Emma]

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

Hi

Thanks for your appreciation :) I also added a new section to the tutorial, because I found out that the symlink to the mysql.sock is deleted each time I reboot my Ubuntu machine. So I made a small service that will create the symbolic link after the reboot.

Cheers
Claudiu

[mvmarkus]

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

Salut Claudiu,

Thanks a lot, that is really great! I have always been too lazy to set this up as I was always expecting tedious (hidden) roadblocks on the way. Your step by step tutorial is exactly what is needed. Now I just have to free a bit of space on my dev server and voilą...

Merci beaucoup, mon pote.

Markus

[Emma]

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

Je t'en prie Markus, tout le plaisir est pour moi :) I'm thinking about making a script to do all the setups automatically... it shouldn't be too hard to do. If I find the time, I'll post it here

Cheers
Claudiu

[TFo]

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

Hi Claudiu,

Your reference is just what I was looking for, but I'm running into a small problem.

I'm a Linux rookie, and I'm trying to set up a dev machine that will mimic the production Linux server. I'm running ubuntu 10.04. I followed your instructions except for the samba and bind parts. I'm planning to do the development in Linux too and I'm using my hosts file to add domain names.

Here's the problem:

When I try to access http://mydomain.com/diag6.mvc

The server is looking for diag6.mvc in "/cgi-bin/mivavm/diag6.mvc"

Here are the entries in httpd.conf:

AddType application/x-miva-compiled .mvc
Action application/x-miva-compiled /cgi-bin/mivavm

ServerName server.com:80
NameVirtualHost 192.168.100.108:80
<VirtualHost *:80>
DocumentRoot "/var/www/default/www"
</VirtualHost>

<VirtualHost 192.168.100.108:80>
DocumentRoot "/var/www/at/www"
ServerName mydomain.com
SuexecUserGroup at users
ScriptAlias /cgi-bin/ /var/www/at/cgi-bin/
AddHandler x-httpd-php5 .php
<Directory />
Options FollowSymLinks
AllowOverride None
</Directory>
<Directory "/var/www/at/www/">
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
allow from all
</Directory>
<Directory "/var/www/at/cgi-bin">
AllowOverride None
Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
Order allow,deny
Allow from all
</Directory>
ErrorLog /var/www/at/log/error.log
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
LogLevel warn
CustomLog /var/www/at/log/access.log combined
</VirtualHost>


Any help will be greatly appreciated.

Todd

[Emma]

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

Hi there Todd :)

Can you paste the content of your mivavm.conf ? Your httpd seems to be ok...

Best regards,
Claudiu

[TFo]

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

Thanks for looking Claudiu!

mivavm.conf:

mivaroot=/var/www/at/www

globaltimeout=360000
mailtimeout=20
calltimeout=360000

userdir=www
authfile=/etc/miva.authfile

<BUILTIN-LIB LIBRARY =
"/var/www/mivavm-v5.08/lib/builtins/crypto.so">
<BUILTIN-LIB LIBRARY =
"/var/www/mivavm-v5.08/lib/builtins/archive.so">
<BUILTIN-LIB LIBRARY =
"/var/www/mivavm-v5.08/lib/builtins/system.so">
<BUILTIN-LIB LIBRARY =
"/var/www/mivavm-v5.08/lib/builtins/file.so">
<BUILTIN-LIB LIBRARY =
"/var/www/mivavm-v5.08/lib/builtins/math.so">
<BUILTIN-LIB LIBRARY =
"/var/www/mivavm-v5.08/lib/builtins/string.so">
<BUILTIN-LIB LIBRARY =
"/var/www/mivavm-v5.08/lib/builtins/time.so">
<BUILTIN-LIB LIBRARY =
"/var/www/mivavm-v5.08/lib/builtins/template.so">

<DATABASE-LIB METHOD="MySQL" LIBRARY="/var/www/mivavm-v5.08/lib/databases/mysql.so">
<DATABASE-LIB METHOD="MivaSQL" LIBRARY="/var/www/mivavm-v5.08/lib/databases/mivasql.so">

cadir=/var/www/mivavm-v5.08/certs

securityoptions=7
dnslookup=off

<VirtualHost at.com>
[email protected]
mivaroot=/var/www/at/www
</VirtualHost>

[Emma]

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

I must say that your config files are OK. No problem detected. Small observation, you could delete your builtins paths in the config file and add this line instead:
builtindir=/var/www/mivavm-v5.08/lib/builtins

This will avoid you modify every line each time you change the Empresa engine (that's a new directive introduced with 5.07)

Also, if you want to use the new GD connector, you'll have to add this line in your config file:
<SYSTEM-LIB CODE="GD" LIBRARY = "/usr/lib/libgd.so.2.0.0">

Back to your problem... I need to understand. When you say that "The server is looking for diag6.mvc in "/cgi-bin/mivavm/diag6.mvc", that means you have an error in your log, or what's the error you have?

PS: By the way, have you changed your env.so file to libmivaconfig.so or the 3x.so ?

[TFo]

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

Thanks for the tips.

I figured out part of the problem. I was always accessing the default www directory. I changed my ip address settings to 127.0.0.1, and now I'm able to access any domain I've set up.

My next problem is with suexec. Don't know if you'll have any ideas, but I'll throw it out for you to see.

Apache Error Log:
[Wed Sep 15 21:10:15 2010] [error] [client 127.0.0.1] suexec policy violation: see suexec log for more details
[Wed Sep 15 21:10:15 2010] [error] [client 127.0.0.1] Premature end of script headers: mivavm

Suexec Log:
[2010-09-15 21:10:15]: uid: (1001/at) gid: (100/users) cmd: mivavm
[2010-09-15 21:10:15]: file is writable by others: (/var/www/at/cgi-bin/mivavm)

I'm grateful for all of your help. I hate the idea of having to work out of my hosts dev area online.

Regards,
Todd

[TFo]

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

I reset the permissions of the mivavm for this domain, and I've made progress. Now I get the following error on the at.com domain:

Configuration Error: 'todd' is not authorized to use Miva Script


I just tried the second domain I set up after changing those mivavm permissions, and I get a whole lot closer. diag6.mvc looks like it's throwing a miva script error:

Fatal error in diag6.mvc @ [00000000:00000076]: diag6.mv: Line 61: Unresolved call to external function 'asciichar'


It feels like I'm getting really close now.

[TFo]

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

Just to finish my part in this thread, I finally have everything running as planned. I did some rearranging, went back to the sites-enabled method since I'm not partial to either, and worked on permissions. I believe permissions were my biggest stumbling block.

Thanks for your help Claudiu.

Todd

[Emma]

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

Sorry for my late response...I'm glad to see you did it :) Indeed, suexec is tricky and owners was a problem for me too.

I'm going to change the tutorial, because some parts are not very well explained

Thanks for your appreciation
Claudiu

[krassib]

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

Hi Claudiu,

This is a great post. I give you my two thumbs up! Thanks for posting it. I used especially the part of provisioning Apache and Miva. Really great help!

Regards,
Krassimir

[RayYates]

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

Fantastic stuff!! Thank you.