LinuxMCE Forums

General => Installation issues => Topic started by: twodogs on December 20, 2011, 12:42:53 am

Title: [SOLVED] Phone line admin page is missing in 1004
Post by: twodogs on December 20, 2011, 12:42:53 am
I tried to make the move to 1004 today. Things looked like they went smoothly, but when I tried to install my VOIP line, the phone line admin page would not come up. I selected it in the left pane, but the right pane was simply a blank white slate. I remember that there were some telecom problems but I thought they were fixed.

twodogs
Title: Re: Phone line admin page is missing in 1004
Post by: posde on December 20, 2011, 06:36:58 am
Please open a trac ticket, and make sure to select module Asterisk.
Title: Re: Phone line admin page is missing in 1004
Post by: rages on December 20, 2011, 03:14:15 pm
I have the same problem.

Emanuele
Title: Re: Phone line admin page is missing in 1004
Post by: posde on December 20, 2011, 03:49:27 pm
Guess what? My answer is the same ;)
Title: Re: Phone line admin page is missing in 1004
Post by: twodogs on December 20, 2011, 06:54:49 pm
OK, maybe not an asterisk problem. I tried to reinstall and watch things more closely. Looks like there were download errors. If someone could help me out with the --fix missing syntax then I could investigate further.

Code: [Select]
Get:215 http://deb.linuxmce.org/ubuntu/ lucid/beta2 pluto-dcerouter 2.0.0.45.11121925281 [203kB]
Get:216 http://deb.linuxmce.org/ubuntu/ lucid/beta2 video-wizard-videos 1.1 [469MB]
Err http://deb.linuxmce.org/ubuntu/ lucid/beta2 video-wizard-videos 1.1
  Could not connect to deb.linuxmce.org:80 (87.239.186.102). - connect (110: Connection timed out)
Failed to fetch http://deb.linuxmce.org/ubuntu/dists/lucid/beta2/binary-i386/video-wizard-videos_1.1_all.deb  Could not connect to deb.linuxmce.org:80 (87.239.186.102). - connect (110: Connection timed out)
Fetched 590MB in 17min 9s (574kB/s)
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?
An error (Exit code 100) occured during the last action
Initial media and dcerouter install
root@Higgins:~# 
Title: Re: Phone line admin page is missing in 1004
Post by: mkbrown69 on December 20, 2011, 10:07:27 pm
OK, maybe not an asterisk problem. I tried to reinstall and watch things more closely. Looks like there were download errors. If someone could help me out with the --fix missing syntax then I could investigate further.

sudo apt-get update
sudo apt-get install --fix-missing

That should do it for you!

/Mike
Title: Re: Phone line admin page is missing in 1004
Post by: twodogs on December 21, 2011, 12:34:49 am
I tried the "fix missing" command and not much happened so I just restarted the LinuxMCE installer. This time everything loaded and the installation completed with the message that no errors had been detected. Sarah started her intro and the wizard ran just fine. When I rebooted and went into admin, the phone line page was still missing as was freepbx. So it looks like a 1004 problem, not a download error. I'll fill out a ticket.

twodogs
Title: Re: Phone line admin page is missing in 1004
Post by: posde on December 21, 2011, 05:26:25 am
Thanks for filling out a ticket. As a side note: We no longer use FreePBX, but are using Realtime database access. Foxi did a lot of work in this area to help us utilize what asterisk has to offer out of the box. Whenever you find stuff, that does not seem to work with asterisk, we need to be made aware of it, so foxi can fix it for us.
Title: Re: Phone line admin page is missing in 1004
Post by: rages on December 24, 2011, 12:24:43 pm
My error is different, i try reinstall lmce-asterisk:

Code: [Select]
ERROR 1064 (42000) at line 338: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT '',
  `channels` int(11) NOT NULL DEFAULT '5',
  PRIMARY KEY (`id`)
)' at line 13
adduser: Il gruppo «asterisk» non esiste.
chown: utente non valido: "asterisk.asterisk"
ERROR 1146 (42S02) at line 1: Table 'asterisk.phonelines' doesn't exist
Adding SIP phone device 22 extension 200
Adding SIP phone device 33 extension 201
Executing Configuration Script configure_snom3xx.pl

Emanuele
Title: Re: Phone line admin page is missing in 1004
Post by: posde on December 24, 2011, 12:42:59 pm
rages,

remove all asterisk packages, i.e. all packages you get by executing dpkg -l|grep asterisk, and install lmce-asterisk manually, and see if that helps.
Title: Re: Phone line admin page is missing in 1004
Post by: rages on December 24, 2011, 02:28:13 pm
Posde, I try your suggestion but I have the same error of my previuos post.

Emanuele
Title: Re: Phone line admin page is missing in 1004
Post by: rages on December 28, 2011, 10:44:06 am
Hi,

there is a way to realign the tables without having to reinstall everything?

Emanuele
Title: Re: Phone line admin page is missing in 1004
Post by: posde on December 28, 2011, 10:52:45 am
If removing asterisk does not help, please open a trac ticket.

btw: Removal should be done using dpkg --purge to remove the conf files as well.
Title: Re: Phone line admin page is missing in 1004
Post by: Rino on December 28, 2011, 10:31:06 pm
Folks,

If your going to eliminate the asterisk web page, perhaps in your wizard you could allow for a 'Other Provider' Button. So those who didn't use these perticular providers could enter there own.  At least with version 8.10 I was able to point that linuxmce-asterisk to my currently running version of FreePBX to which has all the bells and whistle already configured. so i didn't have to redo all that works.

While I'm suggestion things, perhaps a another possible automation tool as well, perhaps have a modules that tries to discover is there is already a asterisk server or other simular pbx on your network so it would, just integrate that one in?

PS: Posted, Don't get mad, These are just suggestions. in hopes to improve, not to critic you or anyone else.
Title: Re: Phone line admin page is missing in 1004
Post by: Foxi352 on December 28, 2011, 10:48:23 pm
My error is different, i try reinstall lmce-asterisk:

Code: [Select]
ERROR 1064 (42000) at line 338: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT '',
  `channels` int(11) NOT NULL DEFAULT '5',
  PRIMARY KEY (`id`)
)' at line 13
adduser: Il gruppo «asterisk» non esiste.
chown: utente non valido: "asterisk.asterisk"
ERROR 1146 (42S02) at line 1: Table 'asterisk.phonelines' doesn't exist
Adding SIP phone device 22 extension 200
Adding SIP phone device 33 extension 201
Executing Configuration Script configure_snom3xx.pl

Emanuele

Should have been fixed earlier today with changeset 25299. Wait for next build to finish and it should work again ...
Title: Re: Phone line admin page is missing in 1004
Post by: rages on December 31, 2011, 11:45:49 am
I have another problem with lmce-asterisk, when I try to reinstall, I have problem with dependency:

Code: [Select]
dpkg: problemi con le dipendenze impediscono la configurazione di asterisk:
 asterisk dipende da asterisk-config (= 1:1.8.8.0-1digium1~lucid) | asterisk-config-custom; comunque:
  Il pacchetto asterisk-config non è installato.
  Il pacchetto asterisk-config-custom non è installato.
  Il pacchetto lmce-asterisk che fornisce asterisk-config-custom non è ancora configurato.

sorry but I have the italian in terminal.
There are problem with asterisk-config and asterisk-config-custom.

emanuele
Title: Re: Phone line admin page is missing in 1004
Post by: twodogs on January 15, 2012, 04:42:44 am
I took another stab at 1004 and I'm happy to say the phone line page is back. I was able to get the phone line to register. I was also able to install the phone device and get my SPA3102 to register as well. However the phone does not work. I'm not a VOIP expert, but here is my analysis.

In 810 I could go into FreePBX and view/modify the Asterisk configuration (passwords, trunks, extension, routes, rules, patterns, etc) but FreePBX is gone now. How is Asterisk configuration viewed/modified in 1004?

Twodogs
Title: Re: Phone line admin page is missing in 1004
Post by: cfernandes on January 15, 2012, 05:20:35 pm
Hello,

my new fresh install off 1004  work great,  only issue that i have is the cisco phones is not registrated .

i take a look  on  configure_cisco7970.pl  and configure_cisco7960.pl  configure_cisco7910.pl
and change lines  52 '/usr/pluto/bin/db_phone_config.sh'  to exec ("/usr/pluto/bin/db_phone_config.sh");
 and comment
this lines

#open(FILE,"/tmp/phone${Device_ID}extension");
#$Device_EXT=<FILE>;
#close(FILE);

#chomp($Device_EXT);

after this changes ,   my cisco phones work great too .
Title: Re: Phone line admin page is missing in 1004
Post by: davegravy on January 15, 2012, 06:59:38 pm
I took another stab at 1004 and I'm happy to say the phone line page is back. I was able to get the phone line to register. I was also able to install the phone device and get my SPA3102 to register as well. However the phone does not work. I'm not a VOIP expert, but here is my analysis.
  • Phone line registers so LMCE must be talking properly to Broadvoice
  • SPA3102 registers so it's talking to LMCE
  • The problem must be with Asterisk configuration

In 810 I could go into FreePBX and view/modify the Asterisk configuration (passwords, trunks, extension, routes, rules, patterns, etc) but FreePBX is gone now. How is Asterisk configuration viewed/modified in 1004?

Twodogs

I spent quite a bit of time looking into the new Asterisk setup in 1004 yesterday (see my thread in the users section). Basically, sip.conf, iax.conf, extensions.conf, and several other configuration files that used to be managed by the FreePBX interface are now stored inside a mysql database called "asterisk". It's quite a bit more difficult now to modify the configuration than it was under FreePBX, since you have to manually modify the database records. But presumably we'll eventually have an easy-to-use webadmin interface for that.

Some people have reported no problems getting things working, but for me the package installer is badly broken. It seems to be a work in progress, so your mileage may vary.



Title: Re: Phone line admin page is missing in 1004
Post by: twodogs on January 15, 2012, 09:09:59 pm
Thanks Dave. Seems like were having the same problems. I'll call this thread solved since the admin page is working. I'll keep an eye on your thread for solutions to the asterisk problems. For now, I'll just keep going with my 0810 installation because I rely on my VOIP phone.

Foxi, I know you're doing a lot of work on 1004 telecom - looks like you're making good progress. Thanks for doing it.

Twodogs