Topic: Installing SAIL 3.1.x onto CentOS 6 64 bit (minimal)

[Uber_CaT]

Hi there,

Maybe I'm trying to bite off more than I can chew,
I'm trying, as the topic says, to install all the latest CentOS, Asterisk, Dahdi & SAIL files from source.

The reason I'm doing this?
Well personally I like lean installations so I'm trying to make an CLEAN installation without all the clutter that typically comes with big packaged Asterisk flavors.
Currently my install so far which is also Virtualised in an VM on my notebook boots and ready for login in under 25 secs

If anyone is interested I'll post the complete steps back here once I get it working ... if I get it working.
But as you maybe be aware CentOS minimal, is just that minimal hence there is nothing running on it.
In fact the Network card is initially even DISABLED after installation.

To get you up to speed I have Successfully installed & dealt with the dependencies for the following:
CentOS 6 64 bit (minimal) now in a usable state and updated
asterisk-1.8.7.1
dahdi-linux-complete-2.5.0.2+2.5.0.2

sail-3.1.0-140 (update: I just noticed this package didn't install due to unsigned package busy working on user "chown" problems ATM)

Asterisk will start but I have to start it manually from bash.

However I don't know what I need to install to get the http://myserver.local/sail web page running
I haven't installed HTTPD yet and I will try that soon but I assume that I need a few more modules like MySQL and other things installed for the SAIL management page to start working?

Then lastly I'm actually not sure how to get some of these things running automatically on start up:
My numerous previous test Asterisk installs of various types would always auto add the likes of Asterisk, Zaptel, Dahdi, MySQL, HTTPD etc
into the start-up which I believe is normally /etc/init.d
But truth be told I don't know how to add this myself manually.

It seems that after what I've done only Dahdi has automatically added itself to startup

So if someone can help me install just the correct modules to get the management pages working & what I need to add to init.d
I'd really be grateful.

Thanks
Cheers
-The_CaT
=^_^=

[Uber_CaT]

OK update:

Looks like I've got HTTPD running but it is not running as user www it seems to be running as apache
(I don't know if that will effect the SAIL installation)
I've mannually added groups: www & asterisk and users: www & asterisk
(which fixed some sail installation CHOWN errors I was getting)
asterisk doesn't run automatically still so I guess it's running as root if I start it myself

If I try to install sail like this
"yum reinstall localinstall sail-3.1.0-140.noarch.rpm --enablerepo=base --nogpgcheck"

I get a bunch of errors(some look like SQL errors):
Error: near line 1: constraint failed
Error: near line 2: constraint failed
Error: near line 1: duplicate column name: channel
Error: near line 1: duplicate column name: ASTDLIM
Error: near line 2: constraint failed
Error: near line 1: constraint failed
Error: near line 2: constraint failed
Error: near line 1: constraint failed
Error: near line 1: duplicate column name: XMPP
Error: near line 2: duplicate column name: XMPPSERV
Error: near line 3: constraint failed
Error: near line 4: constraint failed
Error: near line 1: duplicate column name: CLUSTER
Error: near line 2: duplicate column name: dialstring
Error: near line 3: constraint failed
Error: near line 4: constraint failed
Error: near line 5: constraint failed
Error: near line 1: constraint failed
Error: near line 1: duplicate column name: orideclosed
Error: near line 2: duplicate column name: orideopen
Error: near line 5: constraint failed
Error: near line 6: constraint failed
Error: near line 1: constraint failed
Error: near line 1: constraint failed
Error: near line 2: constraint failed
Error: near line 3: constraint failed
Error: near line 4: constraint failed
Error: near line 5: constraint failed
Error: near line 1: constraint failed
Error: near line 2: constraint failed
Error: near line 3: constraint failed
Error: near line 4: constraint failed
Error: near line 5: constraint failed
Error: near line 1: duplicate column name: trunkname
Error: near line 2: duplicate column name: UNDOONOFF
Error: near line 3: constraint failed
Error: near line 5: constraint failed
Error: near line 1: constraint failed
Error: near line 1: constraint failed
Error: near line 1: constraint failed
Error: near line 2: constraint failed
Error: near line 3: constraint failed
Error: near line 4: constraint failed
Error: near line 5: constraint failed
Error: near line 6: constraint failed
Error: near line 7: duplicate column name: openfirewall
Error: near line 8: duplicate column name: openfirewall
Error: near line 9: duplicate column name: subnet
Error: near line 10: duplicate column name: subnet1
Error: near line 11: duplicate column name: subnet2
Error: near line 12: duplicate column name: subnetstr
Error: near line 13: duplicate column name: subnet1str
Error: near line 14: duplicate column name: subnet2str
Error: near line 15: constraint failed
Error: near line 16: constraint failed
Error: near line 17: constraint failed
Error: near line 19: duplicate column name: callprogress
Error: near line 20: constraint failed
Error: near line 1: duplicate column name: HAUSECLUSTER
Error: near line 2: duplicate column name: RHINOSPF
Error: near line 3: constraint failed
Error: near line 8: constraint failed
Error: near line 1: constraint failed
Error: near line 1: duplicate column name: SIPMULTICAST
Error: near line 2: duplicate column name: ZTP
Error: near line 4: constraint failed
Error: near line 6: constraint failed
Error: near line 23: constraint failed
Error: near line 46: constraint failed
Error: near line 1: table Device has 7 columns but 8 values were supplied
Error: near line 67: table Device has 7 columns but 8 values were supplied
Error: near line 133: table Device has 7 columns but 8 values were supplied
Error: near line 199: table Device has 7 columns but 8 values were supplied
Error: near line 265: table Device has 7 columns but 8 values were supplied
Error: near line 293: table Device has 7 columns but 8 values were supplied
Error: near line 321: table Device has 7 columns but 8 values were supplied
Error: near line 349: table Device has 7 columns but 8 values were supplied
Error: near line 377: table Device has 7 columns but 8 values were supplied
Error: near line 1: constraint failed
Error: near line 2: constraint failed
Error: near line 1: duplicate column name: ACL
Error: near line 2: constraint failed
Error: near line 3: constraint failed
Error: near line 1: duplicate column name: routeable
Error: near line 2: constraint failed
Error: near line 1: table Device has 7 columns but 8 values were supplied
Error: near line 23: table Device has 7 columns but 8 values were supplied
Error: near line 45: table Device has 7 columns but 8 values were supplied
Error: near line 127: table Device has 7 columns but 8 values were supplied
Error: near line 1: constraint failed
Error: near line 2: constraint failed
Error: near line 3: constraint failed
Error: near line 1: duplicate column name: RECLIMIT
Error: near line 1: duplicate column name: transformclip
Error: near line 9: constraint failed
Installed:
  sail.noarch 0:3.1.0-140
Complete!

So it says complete but the web page http://myserver.local/sail still doesn't work.
and if I look in "/etc/httpd/conf/httpd.conf"
it has not added any of the alias records that would be needed for the web page to work.
and I'm guessing that there must also be a problem with the SQL records
I don't know what to check for on the SQL server so I can't tell if it has done anything at all?

Thanks
Cheers
-The_CaT
=^_^=

[SARK devs]

Hello

SARK/SAIL is currently EL5(SME)/32 bit.   The sail rpm doesn't install any environment dependencies so you won't get any httpd objects or any of the other things you've already seen to be missing, they are provided by another rpm called either smesailenv or el5sailenv depending upon the target distro.  The EL5 variant is quite a bit out of date because we've spent our development time on SME and WARP embedded linux. It may not even install from the rpms but there is an iso you could take a look at here

http://sailpbx.com/iso/Centos/5/

It is a regular EL5 kickstart iso so you can loop mount it and make any changes you want to lighten it up but at just under 600MB, I think you'll find it's already OK.  I think this may be your easiest way forward.

The other thing that might be worth considering is the fact that SME server is fairly lightweight anyway (at least when compared with full blown CentOS).  Might it not be easier to simply use SME as the guest in your VM?   There is a self-installing sail V3 iso using asterisk 1.8 and dahdi 2.5 which you can simply download and install as a VM image.  It currently contains sail-3.1.0-128 but you can upgrade it to -140 after you install the iso.

The iso is here http://sailpbx.com/iso/SME8b6/


Kind Regards

S