Topic: [Anounce] smeserver-trixbox-fws-beta2

[Daniel B.]

Hello everyone!
I've just finished the first beta of smeserver-trixbox so I'd need some testers to see what's working and what is not.

It's based on trixbox 1.2.3 but the install script is totally rewrite and brought some new features:

 - the biggest one is that you can edit, before the installation, all the default passwords
 - you can choose which componant you want to install (crm, meetme, maint etc...)
 - you can install and remove independently every features (crm, meetme, maint etc...)
 - each time you remove something, all the needed files and databases are saved for a future reinstall
 - you can choose for the CRM between sugarCRM or vtiger, even if for now, there's no real integration between vtiger and asterisk, I'm working on it and some others are too, I think some interesting features will be soon available.
 - tftpd has been replace with smeserver-tftp-server from trevorb
 - phpmyadmin has been replace with smserver-phpmyadmin-multiusers from mastersleepy
 - meetme has been replace with the latest version

There's some others changes but this is the biggest part.

Zaptel seems to work, at least for a TDM400P digium card.

[edit] I forgot to tell, it's working for en and fr, you just have to edit a script before the installation and all will be configured[/edit]

Some features are not working for now, it's explain in the how-to.

Do NOT install it yet in a prod evironnement, it hasn't been tested enaugh. (well, it shouldn't be too dangerous, I use it on 2 production servers but maybe there're still some problems

You can find the how-to and the contrib here:

http://sme.firewall-services.com/spip.php?article7

Please, try it and send me your comment:

daniel@firewall-services.com

Good weekend everyone.

[fpausp]

Hi,

Got this after installation when i try to use the asterisk management portal:

[nativecode=Access denied for user 'asteriskuser'@'localhost' (using password: NO)] ** mysql://asteriskuser:@/asterisk


regards
fpausp

[Daniel B.]

First, thanks for testing it !

Does the error occures when you try to access https://yourserver/amp or https://yourserver/admin, or another page ?
I think it comes from /opt/asterisk/html/maint/libs/trixbox.php.
Can you post here the line 54 of this file please.
Did you edit the header of the install script, especially ASTERISK_DB_PASS ?

Does the installation went ok ?
I'll do my best to find out where the error comes from.

Cheers, daniel

[fpausp]

Does the error occures when you try to access https://yourserver/amp or https://yourserver/admin, or another page ?

https://server/amp
- [nativecode=Access denied for user 'asteriskuser'@'localhost' (using password: NO)] ** mysql://asteriskuser:@/asterisk

https://server/amp
- Is working

trixbox.php
- $db = DB::connect('mysql://asteriskuser:password@localhost/'.$database);

ASTERISK_DB_PASS ?
- each *_PASS has the same password

Does the installation went ok ?
- Yes, first i have done it with vtiger then i removed it and after that i installed it with sugarcrm (dont know the default pass, vtiger has admin/admin)


hope i can help you
thanks for your work

fpausp

[Daniel B.]

https://server/amp
- [nativecode=Access denied for user 'asteriskuser'@'localhost' (using password: NO)] ** mysql://asteriskuser:@/asterisk

https://server/amp
- Is working

Euh, I think one of this two pages is /admin but you wrote /amp for the two.

Maybe you could uninstall it and reinstall with the defaults passwords to see if it's working this way. If it does, I need to review my script. It's quite strange because I've tested several times with differents passwords and I didn't get an error like that.
Can you post also your /etc/amportal.conf file ?

[fpausp]

Ups, i am sorry,

https://server/admin/
[nativecode=Access denied for user 'asteriskuser'@'localhost' (using password: NO)] ** mysql://asteriskuser:@/asterisk

https://server/amp
- Is working

/etc/amportal.conf

# This file contains settings for components of the Asterisk Management Portal
# Spaces are not allowed!
# Run /usr/src/AMP/apply_conf.sh after making changes to this file

# AMPDBUSER: the user to connect to the 'asterisk' mysql database
AMPDBUSER=asteriskuser

# AMPDBPASS: the password for AMPDBUSER
AMPDBPASS=password

# AMPMGRUSER: the user to access the Asterisk manager interface
AMPMGRUSER=admin

# AMPMGRPASS: the password for AMPMGRUSER
AMPMGRPASS=password

# AMPWEBROOT: the path to Apache's webroot (leave off trailing slash)
AMPWEBROOT=/opt/asterisk/html
AMPBIN=/var/lib/asterisk/bin

# AMPCGIBIN: the path to Apache's cgi-bin dir (leave off trailing slash)
AMPCGIBIN=/opt/asterisk/cgi-bin
 

# AMPWEBADDRESS: the IP address or host name used to access the AMP web admin
AMPWEBADDRESS=192.168.1.246

# FOPPASSWORD: the secred code for performing transfers and hangups in the Flash Operator Panel
FOPPASSWORD=password

# FOPSORT: FOP should sort extensions by Last Name [lastname] or by Extension [extension]
FOPSORT=extension
FOPWEBROOT=/opt/asterisk/html/panel

# AUTHTYPE: authentication type to use for web admin
# If type set to 'database', the primary AMP admin credentials will be the AMPDBUSER/AMPDBPASS above
# valid: none, database
AUTHTYPE=none

# AMPADMINLOGO: Defines the logo that is to be displayed at the TOP LEFT of the admin screen.
#           This enables you to customize the look of the administration screen.
# NOTE: images need to be saved in the ..../admin/images directory of your AMP install
# This image should be 55px in height
AMPADMINLOGO=amp.png

# AMPFOOTERLOGO: Defines the logo that is to be displayed at the BOTTOM RIGHT of the admin screen.
#           This enables you to customize the look of the administration screen.
# NOTE: images need to be saved in the ..../admin/images directory of your AMP install
# This image should be 40px in height
AMPFOOTERLOGO=blank.gif

# AMPADMINHREF: Defines the where a user is taken if they click on the footer logo
#           This enables you to customize the look of the administration screen.
AMPADMINHREF=amp.coalescentsystems.ca

# AMPEXTENSIONS: the type of view for extensions admin
# If set to 'deviceanduser' Devices and Users will be administered seperately, and Users will be able to "login" to devices.
# If set to 'extensions' Devices and Users will me administered in a single screen.
AMPEXTENSIONS=extensions
AMPSBIN=/usr/sbin
ASTETCDIR=/etc/asterisk
ASTMODDIR=/usr/lib/asterisk/modules
ASTVARLIBDIR=/var/lib/asterisk
ASTAGIDIR=/var/lib/asterisk/agi-bin
ASTSPOOLDIR=/var/spool/asterisk
ASTRUNDIR=/var/run/asterisk
ASTLOGDIR=/var/log/asterisk

fpausp

[Daniel B.]

Ok, so your amportal.conf seems to be good, it was just to be sure the passwords were correctly reflected during the install process. I realy don't know what's the matter, could you try to re-install it? I'm uploading an new archive which is based on trixbox 1.2.3, maybe you could try it. It'll be available tomorow.

[Daniel B.]

ok, smeserver-trixbox-1.2.3 is available
http://dedibox.firewall-services.com/downloads/smeserver/smeserver-trixbox

[fpausp]

ok, smeserver-trixbox-1.2.3 is installed

https://server/admin/
[nativecode=Access denied for user 'asteriskuser'@'localhost' (using password: NO)] ** mysql://asteriskuser:@/asterisk

https://server/amp
- Is working

I used the phpmyadmin to change the user asteriskuser to use no password, after that i was able to use https://server/admin/, but there are some other errors ...

I changed the user asteriskuser back to use a password


fpausp

[Daniel B.]

can you please post the return of
tail /var/log/messages
after trying to access https://server/admin ? I think the number of the line which generate the error will be indicated, so I may find why the password isn't set correctly

thanks, daniel

[Daniel B.]

I had a problem with freePBX with another install. I could access to /admin but the configuration was not reflected in the conf file, I looked into the logs and I saw that mysql passwords was not the same that I've set. It was beacause I put a '@' in the passwords. Your problem seems different but I post that for others if they want to try, do not put any special caracters in the passwords.

[Daniel B.]

Well, nobody else is interested in testing trixbox? I'd be great if I have some other feedback to see if the problem of fpausp comes from his server's config or the package.
fpausp, what's installed on your server? Is it a fresh SME 7 ?

ps: sorry, I forgot to answer, default login for sugarCRM is admin:password

[fpausp]

Hi,

Monday i will install it on another box.

regards
fpausp

[jester]

I'm freeing up a box, but this is a bit tricky. Once i got it i was planning on giving it a spin.

[girkers]

How is trixbox different to SAIL?

I am looking at adding Asterisk to my home SME box and am wondering what is the difference.