This thread is archived
4 Replies Last post: Mar 29, 2007 8:36 AM by Jordi García  
Jordi García   10 posts since
Mar 13, 2007
Currently Being Moderated

Mar 14, 2007 10:22 AM

PostGRE SQL group integration problem

Hi,

 

I''ve been trying to customize auth, users and groups in Wildfire but I still can''t get customized groups to work as they do when Wildfire uses its own structure. When I do that, I can create a group via de Web admin page and assign users to that group, then share with other users and as soon as I connect to the server (using PSI or Spark clients) this new group with the assigned contacts will appear in the roster of the client. This is exactly the behaviour I''m looking for. BUT, if I try to customize groups, I can''t create them from within the Web admin (I''m guessing it will make the data read-only as it does when customizing users) because I get an error that makes me check my logs. I thought that might be the point but "groups" customization doesn''t allow me to modify tables such as "jivegroupprop" that probably make the difference.

 

Problem is that once I try to customize groups, they won''t appear in the client as I described above, which proves I''m doing something wrong (but I still haven''t been able to figure out). I''ve thoroughly searched the through the forums and found many things that helped me in previous steps, but not in this one.

 

Wildfire is running on (after ant building) Eclipse 3.2.1 with JDK 1.5.0_10. Platform is Windows XP, and the DB is running on Ubuntu Linux. I''m using Wildfire 3.1.1 (since updating to 3.2.2 brought many other issues I''m still not ready to face), PostGreSQL for auth, user and group customization, and my "wildfire.xml" config file is as follows:

 

<----


START OF "WILDFIRE.XML" -


>

 

9090 9091 en org.jivesoftware.database.DefaultConnectionProvider org.postgresql.Driver jdbc:postgresql://10.95.98.11:5432/Wildfire postgres 5 15 1.0 org.postgresql.Driver jdbc:postgresql://10.95.98.11:5432/WildfireAuth?user=postgres org.jivesoftware.wildfire.auth.JDBCAuthProvider org.jivesoftware.wildfire.user.JDBCUserProvider org.jivesoftware.wildfire.group.JDBCGroupProvider SELECT password FROM iisysauth WHERE username=? plain SELECT username,email FROM users2 WHERE username=? SELECT COUNT(*) FROM users2 SELECT username FROM users2 SELECT username FROM users2 WHERE username username email SELECT count(*) FROM groups SELECT groupname FROM groups SELECT groupname FROM groupsusers WHERE username=? SELECT description FROM groups WHERE groupname=? SELECT username FROM groupsusers WHERE groupname=? AND administrator=''N'' SELECT username FROM groupsusers WHERE groupname=? AND administrator=''Y'' true ]]>

 

<----


END OF "WILDFIRE.XML" -


>

 

The "WildfireAuth" database is used only for auth, and the "Wildfire" one should be used for the other two options (users and groups). Users and auth work fine, groups just don''t.

 

Let me know if you need any other information, any help would be greatly appreciated.

 

Thanks,

 

Jordi

 

Message was edited by: Jordig

LG KeyContributor 4,962 posts since
Dec 13, 2005
Currently Being Moderated
Mar 14, 2007 6:37 PM in response to: Jordi García
Re: PostGRE SQL group integration problem

Hi,

 

it''s at least a very long and complicated looking post.

Is "The "WildfireAuth" database is used only for auth, and the "Wildfire" one should be used for the other two options (users and groups)." right? Then you must use only the auth provider as described in "Authentication Integration" in http://www.igniterealtime.org/builds/wildfire/docs/latest/documentation/db-integ ration-guide.html - your current setup is the "Group Integration" one.

 

LG

More Like This

  • Retrieving data ...