<br><br><div class="gmail_quote">On Dec 11, 2007 2:17 AM, Edward Rudd <<a href="mailto:erudd@netfor.com">erudd@netfor.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Ahhhh.<br>ok.<br>that means that djabberd ran into an error and kicked that user off.<br>Did you check the file permissions on the your sqlite database?<br></blockquote><div>Yes the sqlite database has the permissions for read and write.
<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>Also create a file in /etc/djabberd/ called log.conf with this contents<br>(make sure that /etc/djabberd is writable by djabberd)
<br><br>log4perl.logger.DJabberd = DEBUG, file<br>log4perl.logger.DJabberd.Hook = DEBUG<br><br>log4perl.logger.DJabberd.Connection.XML = DEBUG<br><br>log4perl.appender.screen = Log::Log4perl::Appender::ScreenColoredLevels
<br>log4perl.appender.screen.layout = Log::Log4perl::Layout::PatternLayout<br>log4perl.appender.screen.layout.ConversionPattern = %-5p %-40c %m %n<br><br>log4perl.appender.file = Log::Dispatch::File<br>log4perl.appender.file.filename=/etc/djabberd/djabberd.log
<br>log4perl.appender.file.mode=append<br>log4perl.appender.file.layout=Log::Log4perl::Layout::PatternLayout<br>log4perl.appender.file.layout.ConversionPattern=%d %p> %F{1}:%L %M - %m%n<br><div class="Ih2E3d"></div></blockquote>
<div><br>I created this file under the specified locaiton. But log file is not created. Is it because i have the djabberd running in a different location? I am running the djabber under /usr/local/.... I was enabling the log statements by giving export LOGLEVEL=ALL..
<br></div><div><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d"><br>Rajesh Dharmalingam wrote:<br>> Yes. I created two users and tried to add buddy with alias and group.
<br>> While doing so, the user who wants to add a buddy logs off.<br>><br>> say for example, I created 2 users a1 and a2. I logged in with a1 and<br>> a2. When i try to add a2 from a1 account, a1 gets disconnected. After
<br>> this, I am not able to login again with a1 account. The user entry for<br>> a1 is not there.<br>><br>> On Dec 11, 2007 1:55 AM, Edward Rudd <<a href="mailto:erudd@netfor.com">erudd@netfor.com</a><br></div>
<div><div></div><div class="Wj3C7c">> <mailto:<a href="mailto:erudd@netfor.com">erudd@netfor.com</a>>> wrote:<br>><br>> The roster table ONLY gets updated when a *subscription* happens. IE.<br>> users A subscribes or adds user B to a group in their buddy list.
<br>><br>> Rajesh Dharmalingam wrote:<br>> > Hi,<br>> ><br>> > I created new users and able to login. But when i check the roster, i<br>> > get the same old data as i sent you previously. The roaster table does
<br>> > not get updated with the latest users.<br>> ><br>> > From config file:<br>> > The plugin for users<br>> > <Plugin DJabberd::Authen::HTDigest><br>> > Realm djabberd
<br>> > HtDigest /usr/local/chat/djabberd/djabberd.users<br>> > </Plugin><br>> ><br>> > The plugin for SQLite:<br>> > <Plugin DJabberd::RosterStorage::SQLite>
<br>> > Database /usr/local/chat/djabberd/DJabberd/roster.sqlite<br>> > </Plugin><br>> ><br>> > I am creating the users as<br>> > htdigest -c djabberd.users djabberd user1
<br>> > htdigest -c djabberd.users djabberd user2<br>> ><br>> > Am i missing something?<br>> ><br>> > Regards,<br>> > -Rajesh<br>> ><br>> > On Dec 11, 2007 1:08 AM, Edward Rudd <
<a href="mailto:erudd@netfor.com">erudd@netfor.com</a><br>> <mailto:<a href="mailto:erudd@netfor.com">erudd@netfor.com</a>><br></div></div><div><div></div><div class="Wj3C7c">> > <mailto: <a href="mailto:erudd@netfor.com">
erudd@netfor.com</a> <mailto:<a href="mailto:erudd@netfor.com">erudd@netfor.com</a>>>> wrote:<br>> ><br>> > Rajesh Dharmalingam wrote:<br>> > [snip]<br>> > > That means the subscriptiong didn't work right. Can you
<br>> > provide a dump<br>> > > of your roster database?<br>> > > sqlite3 roster.sqlite .dump<br>> > ><br>> > > This is the output:
<br>> > ><br>> > > BEGIN TRANSACTION;<br>> > [snip]<br>> > > CREATE TABLE roster (<br>> > > userid INTEGER
<br>> REFERENCES<br>> > jidmap<br>> > > NOT NULL,<br>> > > contactid INTEGER<br>> REFERENCES<br>> > jidmap<br>
> > > NOT NULL,<br>> > > name VARCHAR(255),<br>> > > subscription INTEGER NOT NULL<br>> > > REFERENCES substates DEFAULT 0,
<br>> > > PRIMARY KEY (userid, contactid)<br>> > > );<br>> > Looks like no subscription information every got save. Odd.. the
<br>> > roster<br>> > table should be filled with entries like (1,2, 'My User',3)<br>> and (2,1,<br>> > 'My Other User',3)<br>> ><br>> > Try specifying a *groupname* and alias when subscribing to
<br>> users and see<br>> > how this DB changes.<br>> ><br>> ><br>> ><br>> ><br>> > --<br>> > Regards,<br>> > -Rajesh<br>> >
<br>> > "Stick to our roots and not to forget where we come from"<br>><br>><br>><br>><br>> --<br>> Regards,<br>> -Rajesh<br>><br>> "Stick to our roots and not to forget where we come from"
<br></div></div></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>-Rajesh<br><br>"Stick to our roots and not to forget where we come from"