Empty parameters

[Thiago]

I wanted to set up a campaign yesterday and I see that it is empty and that it has changed as you can see.

This is the second time this has happened to me in 1 month, the last time I filled in the system settings manually but it takes a lot of time, please how can I fix this for good?

[carpenox]

run this in your linux CLI:

mysql -p -f --database=asterisk < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql

[williamconley]

I see that you've got your specs in your post. Thanks for that. Now: Have you upgraded this system after installation? How about have you brought in an old database?

If neither of those has happened, your system may be crashing tables. Or it's even possible your HD is too full (which can cause ... crashed tables). Some installations of mysql will auto-repair on reboot so you may not know it was crashed. If that's the case, of course, for the first few minutes you'll have queries running to rebuild the broken tables and your mysql logs should have crash notices.

The first test for crashed tables:

Code: Select all

mysql asterisk -p -e "show table status where comment like '%crashed%'"

drive usage:

Code: Select all

df -h


[Thiago]

Thanks Capernox and William for your replies

Indeed, I recently updated my server. And the waiter started to disturb 2 weeks later... after Capernox's request, it works

Please what is the latest stable Asterisk version with vicidial, the opensuse that you advise me, I want to launch an update this weekend

[carpenox]

no problem bud, and I personally use Asterisk 18.21

You can install it using these commands:

zypper in make gcc -y
mkdir /usr/src/asterisk
cd /usr/src/asterisk
wget https://downloads.asterisk.org/pub/tele ... 6.1.tar.gz
wget https://download.vicidial.com/required- ... ici.tar.gz
tar -xvzf asterisk-18.21.0-vici.tar.gz
tar -xvzf libpri-*

cd /usr/src
wget https://github.com/cisco/libsrtp/archive/v2.1.0.tar.gz
tar xfv v2.1.0.tar.gz
cd libsrtp-2.1.0
./configure --prefix=/usr --enable-openssl
make shared_library && sudo make install
ldconfig

cd /usr/src/asterisk/asterisk-18.21.0-vici/

zypper in libuuid-devel libxml2-devel -y

: ${JOBS:=$(( $(nproc) + $(nproc) / 2 ))}
./configure --libdir=/usr/lib64 --with-gsm=internal --enable-opus --enable-srtp --with-ssl --enable-asteriskssl --with-pjproject-bundled --with-jansson-bundled

make menuselect/menuselect menuselect-tree menuselect.makeopts
#enable app_meetme
menuselect/menuselect --enable app_meetme menuselect.makeopts
#enable res_http_websocket
menuselect/menuselect --enable res_http_websocket menuselect.makeopts
#enable res_srtp
menuselect/menuselect --enable res_srtp menuselect.makeopts
make samples
sed -i 's|noload = chan_sip.so|;noload = chan_sip.so|g' /etc/asterisk/modules.conf
make -j ${JOBS} all
make install


Let me know if this works, its from my installer for Alma or Rocky but I converted the commands to opensuse so it should

Chris

[williamconley]

Indeed, I recently updated my server. And the waiter started to disturb 2 weeks later... after Capernox's request, it works

Good postback. Always helps when solutions are marked. Future users may not bother saying it, but it helps.

Please what is the latest stable Asterisk version with vicidial, the opensuse that you advise me, I want to launch an update this weekend

Not to butt in, but why do you feel a need to upgrade?

Most of our clients only upgrade when there's a new feature they "must have". Otherwise, these servers will run for 10 years + without being touched aside from occasionally changing carriers and replacing dead RAID HDs.

[Thiago]

no problem bud, and I personally use Asterisk 18.21

Thanks Capernox, I'll think about it.

Good postback. Always helps when solutions are marked. Future users may not bother saying it, but it helps.

yes, postback is the basis for forum help entry

Not to butt in, but why do you feel a need to upgrade?

I'm thinking of doing the update because since the update, I have a problem with some calls. In fact, when the customer hangs up, the call remains in LIVECALL at the agent's, the hangup button doesn't work, the agent has to reconnect. maybe I'll make a new post about it

[williamconley]

that likely won't be fixed by upgrading again. in fact, if that happened during an upgrade, another upgrade could give you more fun things to complain about.

Track down the error messages, you'll likely find that cron requires a change or a .conf file is being generated incorrectly due to a version problem in astguiclient.conf or admin->Servers. Note that some systems offer asterisk versions such as "11.X" and expect the ".X" to be there. Leaving it off is a mismatch and the result can be the wrong .conf file entries. During an install or upgrade or even just "install.pl" copying the files again, that tiny mismatch can cause the wrong .conf file bases to be written into the /etc/asterisk folder with compatibility for the wrong version of asterisk.

One method is to run the install.pl script but NOT actually say "Yes" at the end. Check out the versions offered. Make sure your astguiclient.conf file has an exact match. If it doesn't, change it and run the install.pl again and this time it will pull the correct .conf files. Alternately, of course, you can make the change in astguiclient.conf and then determined which sip.conf (and others possibly, but mostly sip.conf) should have been copied ... and just copy them one at a time yourself until the problem goes away. Remember that sip.conf has "externip" in it of course.