XMPP Issues

Commercial Modules
1

Hi Everyone,

I have FreePBX 12.0.73 installed and have added the XMPP comm module but am having difficulties…

When I try to add/Remove a user through user mgmt I get the error message below, XMPP module is currently at version 12.0.24. Any help would be greatly appreciated :smile:

FATAL ERROR

FreePBX is Unable to Continue

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘asterisk.prosody’ doesn’t exist

Trace Back

/var/www/html/admin/modules/xmpp/Xmpp.class.php:271 PDOStatement->execute()
[0]:

/var/www/html/admin/modules/xmpp/Xmpp.class.php:250 FreePBX\modules\Xmpp->usermanUpdateUser()
[0]: 9
[1]: userman
[2]:

: FreePBX\modules\Xmpp->usermanAddUser()
[0]: 9
[1]: userman
[2]:

/var/www/html/admin/libraries/BMO/Hooks.class.php:141 call_user_func_array()
[0]:
[1]:

/var/www/html/admin/modules/userman/Userman.class.php:442 Hooks->processHooks()
[0]: 9
[1]: userman
[2]:

/var/www/html/admin/modules/userman/Userman.class.php:116 FreePBX\modules\Userman->addUser()
[0]: bob
[1]: 55555
[2]: 3003
[3]:
[4]:

/var/www/html/admin/libraries/BMO/GuiHooks.class.php:281 FreePBX\modules\Userman->doConfigPageInit()
[0]: userman

/var/www/html/admin/libraries/BMO/GuiHooks.class.php:249 GuiHooks->doBMOConfigPage()
[0]: Userman
[1]: userman

/var/www/html/admin/config.php:312 GuiHooks->doConfigPageInits()
[0]: userman
[1]:

2

What does the FreePBX dashboard say for Prosody (XMPP) and UCP Daemon?

3

Hi Igaetz,

Prosody (XMPP) says it’s running, but I can see no mention of UCP Daemon.

I have XMPP Presence Daemon with a warning triangle that say presence.php dead but PID exists.

Summary has:-

Asterisk - green tick
MYSQL - green tick
Web Server - green tick
Fail2BAN - green tick
System Reg - green tick
Prosody XMPP - green tick
XMPP Presence Daemon - warning as mentioned above

Cheers

Al

4 
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'asterisk.prosody' doesn't exist

For whatever reason the table is not there… try reinstalling the module

5

Yeah tried to re-install the module but I still get the same error. Has any one an idea of a work around?

6

Is the the FreePBX distro? If not we need to know.

I don’t believe the XMPP module creates the prosody table, but I don’t know which module does.

7

Is the the FreePBX distro? If not we need to know.

Yes and I installed Prosody using this link for centos 6

http://wiki.freepbx.org/display/FCM/XMPP-Installing+Prosody+RPM

and then through the commercial module