IS there a way to add date and time in spark or in the DB so that when we run the queries then along with the body of the conversation we can get the Date and time of when that conversation took place? This is all in the embeded DB.
In spark you can turn on the preference to show time in the chat window. As far as I know all chat logs contain the date and time stamp by default. It is just a matter of having the right tools to read that part of the stored data.
you need to add that user to your roster and they need to add you with the full JID (firstname.lastname@example.org). You may also need to accept their invitation. If you have the subscription plugin installed it needs to be configured to accept local, accept all will not work for S2S.
Thanks for the reply. It almost worked. I added the users to each others rosters in openfire and added the users in spark. But for some reason none of them show up as online. When I try to chat I get the “user cannot receive the messages offline?”… our DNS is set up properly for the forward addresses of each other… but for some odd reason they dont seem to communicate.
So after adding the users to each other and adding their rosters they dont seem to come online. on occasion One of them comes on. Regardless of the status we can still ping each other by name and by IP.
To list out the details. To add users to a Roster I first create a Roster in Openfire under that user (under users/groups and then selecting my user). Therefore, as an example I first add User2 (JID) to my user1 roster in Openfire and then add user2 (JID) to my spark client for user1.
Then I do the same process to add user1 to user2 roster in openfire first and then spark.
So one of the users shows up online… But when I start my conference or single chat they dont see eachother and apprear offline in Spark Client.
Therefore I’m not sure if i am not adding properly or if there is a feature in Spark that i need to enable to allow this but its not working properly.
Please let me know if you need more clarification, or if you can provide more clarification…
I tried it both ways (1. Just through Spak. and 2nd way with Openfire and Spark). Anyway i’ll try this agian with creating new users (in both of my domains/networks) and then adding them through just the spark client and see if it works.
But so far the issues might be something else. The users show up on each others list (eventhough they are on a different domain) just because I added them but they appear in the offline list. and on the one it show online but pending approval and when I check the user that has to approve the acceptance he doesn’t see anything like “accept or reject or anything”.
Also when I click on start a chat and view their profile I can see their profiles on both domains, but I can only see client version for one of them on one domain only.
Both of my JID’s can ping eachother, from different networks.