Fatal Error

[himala76]

Hello Everyone

one of my PiaF upgrade form 2.6 to 2.7 ( freepbx)after upgrade i get this error
FATAL ERROR

SELECT username, password_sha1, extension_low, extension_high, deptname, sections FROM ampusers WHERE username = 'asteriskuser'
DB Error: no such field

i use user name as maint to log in

Now i cant get in to the WEB GUI
anybody has this issue or know how to fix it??

Thanks in advance
Himala

 

[randy7376]

This sounds like something I had happen with a trixbox installation a few years back. I had to recreate the missing field in one of the tables.

Can you post the output of status in your reply, please?

You need to find a way to verify that each field is present in the ampuser table. Do you have phpMyadmin installed? That's probably the easiest way. If not, we can do this from the command line.

Here's a screenshot from phpMyAdmin for the asterisk database and ampuser table on a working system:

Lastly, you may have more than one table that's missing information. You might get this one fixed and find out that something else is wrong.

 

[himala76]

Hello Randy

Thanks for the reply
can you tell me how to get Status page .
im new to Linux sorry
i log in to the webmin cant see any page like that
himala

 

[randy7376]

Do you have physical access to the server? If not, are you familiar with logging into your server with SSH?

The status command will run automatically if you login via the console or SSH.

I'm not a Webmin user, but I do have it running on one system. It looks like you can get into your system this way: Once you've logged into Webmin, go to Others, and select SSH Login. It will prompt you for your username and password. Login with root and root's password.

In order for that to work, you will need to have a browser that has the Java plug-in enabled.

Otherwise, if you can physically access the server, login at the console with root and root's password.

 

[himala76]

hello Randy

this is the out put
root@pbx:~ $ status
Status - 1.7.6 released on 071010
********************************************************************
* PBX in a Flash GOLD Daemon Status *
********************************************************************
* Asterisk * ONLINE * Zaptel * ONLINE * MySQL * ONLINE *
* SSH * ONLINE * Apache * ONLINE * Iptables * ONLINE *
* Fail2ban * ONLINE * IP Connect* ONLINE * Ip6tables * ONLINE *
* BlueTooth * ONLINE * Hidd * ONLINE * NTPD * ONLINE *
* Sendmail * ONLINE * Samba * OFFLINE * Webmin * ONLINE *
* Ethernet0 * ONLINE * Ethernet1 * N/A * Wlan0 * N/A *
********************************************************************
* PBX in a Flash Version : 1.7.5.5
* FreePBX Version : 2.7.0.10
* Running Asterisk Version : Asterisk 1.4.21.2
* Asterisk Source Version : 1.4.21.2
* Zaptel Source Version : 1.4.12.1
* Libpri Source Version : 1.4.11.4
* Addons Source Version : 1.4.12
********************************************************************
pbx.local on 192.168.1.2 - eth0
CentOS release 5.6 (Final) :32 Bit Kernel: 2.6.18-194.8.1.el5
root@pbx:~ $
Thanks
Himala

 

[mickecarlsson]

Login via ssh, start mysql:

mysql -u root -ppassw0rd
use asterisk; 
ALTER TABLE ampusers CHANGE COLUMN password password_sha1 varchar(40);
UPDATE ampusers SET password_sha1 = 'd033e22ae348aeb5660fc2140aec35850c4da997' where username='admin';

 

[himala76]

Thanks mickecarlsson
its worked .
thanks again
himala