powered by Jive Software

Create Queue through MySQL

I need the ability to add and edit queues through a custom portal. I’ve got something setup to add a row to the fpQueue table in the DB but the queue is still not recognized after I restart the enterprise plugin. I get a 404 error, /workgroup-error.jsp. It seems like there should be some values in the fpQueueProp table but there isn’t any data in that table for any of my queues.

This is all I could find in the debug.log:

2007.09.02 18:05:55 JspEngine --> /workgroup-error.jsp

2007.09.02 18:05:55 ServletPath: /workgroup-error.jsp

2007.09.02 18:05:55 PathInfo: null

2007.09.02 18:05:55 RealPath: /opt/openfire/plugins/admin/webapp/workgroup-error.jsp

2007.09.02 18:05:55 RequestURI: /workgroup-error.jsp

2007.09.02 18:05:55 QueryString: wgID=testworkgroup@workgroup.mydomain.com&qID=21

2007.09.02 18:05:55 Request Params:

2007.09.02 18:05:55 wgID = testworkgroup@workgroup.mydomain.com

2007.09.02 18:05:55 qID = 21

Any ideas or suggestions?