Reload failed because retrieve_conf encountered an error: 1

Hello,

I’ve got a problem since this morning, i can’t apply config from my Freepbx.
It’s an old installation which works fine, but know i don’t understand what appened.
Thank’s for your helping.

Here is the error message :


exit: 1
found language dir ja for pbdirectory, not installed on system, skipping
found language dir es for pbdirectory, not installed on system, skipping
found language dir es for speeddial, not installed on system, skipping
Added to globals: OPERATOR_XTN =
Added to globals: VMX_LOOPS = 1
Added to globals: VMX_OPTS_DOVM =
Added to globals: VMX_OPTS_LOOP =
Added to globals: VMX_REPEAT = 1
Added to globals: VMX_TIMEOUT = 2
Added to globals: VM_DDTYPE = u
Added to globals: VM_GAIN =
Added to globals: VM_OPTS =
Added to globals: ASTETCDIR = /etc/asterisk
Added to globals: ASTMODDIR = /usr/lib/asterisk/modules
Added to globals: ASTVARLIBDIR = /var/lib/asterisk
Added to globals: ASTAGIDIR = /var/lib/asterisk/agi-bin
Added to globals: ASTSPOOLDIR = /var/spool/asterisk
Added to globals: ASTRUNDIR = /var/run/asterisk
Added to globals: ASTLOGDIR = /var/log/asterisk
Added to globals: CWINUSEBUSY = true
Added to globals: AMPMGRUSER = admin
Added to globals: AMPMGRPASS = khtopcr
Added to globals: AMPDBENGINE = mysql
Added to globals: AMPDBHOST = localhost
Added to globals: AMPDBNAME = asterisk
Added to globals: AMPDBUSER = freepbx
Added to globals: AMPDBPASS = fpbx
Added to globals: VMX_CONTEXT = from-internal
Added to globals: VMX_PRI = 1
Added to globals: VMX_TIMEDEST_CONTEXT =
Added to globals: VMX_TIMEDEST_EXT = dovm
Added to globals: VMX_TIMEDEST_PRI = 1
Added to globals: VMX_LOOPDEST_CONTEXT =
Added to globals: VMX_LOOPDEST_EXT = dovm
Added to globals: VMX_LOOPDEST_PRI = 1
Added to globals: MIXMON_DIR =
Added to globals: MIXMON_POST =
Added to globals: DIAL_OPTIONS = tr
Added to globals: TRUNK_OPTIONS =
Added to globals: TRUNK_RING_TIMER = 300
Added to globals: MIXMON_FORMAT = wav
Added to globals: REC_POLICY = caller
Added to globals: RINGTIMER_DEFAULT = 30
Added to globals: TRANSFER_CONTEXT = from-internal-xfer
Notice: no Queues defined
Notice: no iax trunks defined
Notice: no AMP Users defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
Notice: no VM Prefix defined
[FATAL] SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq [nativecode=145 ** Table ‘./asterisk/sipsettings’ is marked as crashed and should be repaired]SQL -
SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq

Trace Back:

/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq [nativecode=145 ** Table ‘./asterisk/sipsettings’ is marked as crashed and should be repaired]SQL -
SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq

/var/www/html/admin/modules/sipsettings/Sipsettings.class.php:371 sql()
[0]: SELECT keyword, data, type, seq FROM sipsettings WHERE type != 1 AND type != 2 ORDER BY type, seq
[1]: getAll
[2]: 2

/var/www/html/admin/modules/sipsettings/functions.inc.php:246 Sipsettings->getChanSipSettings()
[0]: 1

/var/www/html/admin/modules/sipsettings/functions.inc.php:91 sipsettings_get()
[0]: 1

/var/www/html/admin/libraries/BMO/DialplanHooks.class.php:87 sipsettings_hookGet_config()
[0]: asterisk

/var/lib/asterisk/bin/retrieve_conf:727 DialplanHooks->processHooks()
[0]: asterisk
[1]:

your sip settings table crashed and you should repair this. But I don’t know that it has any easy tool or not.
did you try to re-install sipsettings module?

This should fix:

mysqlcheck --repair --all-databases
1 Like

Hello everybody :wink:

Finaly, i restored the backup from yesterday and all is working fine now :wink:
I will note your solutions for another day if the problem returns.

Thank’s