<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = "urn:schemas-microsoft-com:office:word" xmlns:st1 = "urn:schemas-microsoft-com:office:smarttags"><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <TITLE>Mensaje</TITLE> <META content=Word.Document name=ProgId> <META content="MSHTML 6.00.2712.300" name=GENERATOR> <META content="Microsoft Word 10" name=Originator><LINK href="cid:filelist.xml@01C1A585.B8787520" rel=File-List><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"></o:SmartTagType> <STYLE>@font-face { font-family: Tahoma; } @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } A:visited { COLOR: purple; TEXT-DECORATION: underline; text-underline: single } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline; text-underline: single } P { FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto } SPAN.EmailStyle18 { COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply; mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial } SPAN.SpellE { mso-style-name: ""; mso-spl-e: yes } SPAN.GramE { mso-style-name: ""; mso-gram-e: yes } DIV.Section1 { page: Section1 } </STYLE> </HEAD> <BODY lang=EN-US style="tab-interval: .5in" vLink=purple link=blue> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2>Continuing...</FONT></SPAN></DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2>I cannot make any transport work with mysql...</FONT></SPAN></DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2>Myslq is working form jabber and if I coneect to msn it create my roster in usersroster...</FONT></SPAN></DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2>but nothing is saved in the msn or aim tables (my login information for the transport inst' it?)</FONT></SPAN></DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2>it keeps triyng to set the infromation, this line appears all the time...</FONT></SPAN></DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2>Mon Jan 28 09:06:17 2002  deliver.c:460 DELIVER 2:aim.ferengi.com.ar <xdb type='set' <A href="mailto:to='ec75fec87fc620cd7262b4072aceb62397534071@aim.ferengi.com.ar'">to='ec75fec87fc620cd7262b4072aceb62397534071@aim.ferengi.com.ar'</A> from='aim.ferengi.com.ar' ns='aimtrans:roster' id='3'><aimtrans><buddies/></aimtrans></xdb><BR>Mon Jan 28 09:06:17 2002  deliver.c:649 delivering to instance 'xdb'<BR>Mon Jan 28 09:06:17 2002  xdb_sql.c:124 modules = 814b8e0<BR>Mon Jan 28 09:06:28 2002  mio.c:698 MIO read from socket 19: <log type='warn' from='sessions.c:1100'>[AT] Closing down session for <A href="mailto:dedalo@poseidon.ferengi.com.ar/hermes</log">dedalo@poseidon.ferengi.com.ar/hermes</log</A>></FONT></SPAN></DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2>I'm not sure about something... in the to line I have: <U>ec75fec87fc620cd7262b4072aceb62397534071</U>  this code, must be the same tha appears in users0k table?</FONT></SPAN></DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2>thanks for any help!</FONT></SPAN></DIV> <DIV><SPAN class=329390912-28012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV></DIV> <DIV class=OutlookMessageHeader lang=es dir=ltr align=left><FONT face=Tahoma size=2>-----Mensaje original-----<BR><B>De:</B> Rodrigo Roman [mailto:dedalo@ferengi.com.ar] <BR><B>Enviado el:</B> Viernes, 25 de Enero de 2002 06:45 p.m.<BR><B>Para:</B> 'jdev@jabber.org'<BR><B>Asunto:</B> RE: [JDEV] Mysql and transports<BR><BR></FONT></DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2>Something odd is happening...</FONT></SPAN></DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2>I used your sql to create tables, and your xml.</FONT></SPAN></DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2>Then I tried with my instalation of msnt, and worked out... but only the first time, when I register the gateway, i received all my roster form msn and could send and receive messages. Then when I log in again it does not recive my presence... gateway does not come alive...</FONT></SPAN></DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2>I tried with your msntrans... and the same... I could register and received my contacts.. but receive this error:</FONT></SPAN></DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2>Fri Jan 25 18:44:23 2002  deliver.c:460 DELIVER 4:c2s <route <A href="mailto:from='dedalo@poseidon.ferengi.com.ar/8252928'">from='dedalo@poseidon.ferengi.com.ar/8252928'</A> <A href="mailto:to='21@c2s/819B518'><presence">to='21@c2s/819B518'><presence</A> from='msn.ferengi.com.ar/registered' <A href="mailto:to='dedalo@poseidon.ferengi.com.ar/Winjab'">to='dedalo@poseidon.ferengi.com.ar/Winjab'</A> type='error'><status>Online</status><error code='500'>Internal Server Error</error></presence></route><BR>Fri Jan 25 18:44:23 2002  deliver.c:649 delivering to instance 'c2s'<BR>Fri Jan 25 18:44:23 2002  client.c:148 C2S: <A href="mailto:dedalo@poseidon.ferengi.com.ar/8252928">dedalo@poseidon.ferengi.com.ar/8252928</A> has an active session, delivering packet<BR>Fri Jan 25 18:44:23 2002  client.c:202 Writing packet to MIO: <presence from='msn.ferengi.com.ar/registered' <A href="mailto:to='dedalo@poseidon.ferengi.com.ar/Winjab'">to='dedalo@poseidon.ferengi.com.ar/Winjab'</A> type='error'><status>Online</status><error code='500'>Internal Server Error</error></presence><BR>Fri Jan 25 18:44:23 2002  mio.c:908 mio_write called on x: 82728A8 buffer: (null)<BR>Fri Jan 25 18:44:23 2002  mtq 81AD7D8 leaving to pth<BR>Fri Jan 25 18:44:23 2002  mio.c:268 write_dump writing data: <presence from='msn.ferengi.com.ar/registered' <A href="mailto:to='dedalo@poseidon.ferengi.com.ar/Winjab'">to='dedalo@poseidon.ferengi.com.ar/Winjab'</A> type='error'><status>Online</status><error code='500'>Internal Server Error</error></presence></FONT></SPAN></DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2>any help?</FONT></SPAN></DIV> <DIV><SPAN class=143263321-25012002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV></DIV> <DIV class=OutlookMessageHeader lang=es dir=ltr align=left><FONT face=Tahoma size=2>-----Mensaje original-----<BR><B>De:</B> Jason Reineri [mailto:jreineri@northridge.com] <BR><B>Enviado el:</B> Viernes, 25 de Enero de 2002 11:50 a.m.<BR><B>Para:</B> jdev@jabber.org<BR><B>Asunto:</B> RE: [JDEV] Mysql and transports<BR><BR></FONT></DIV> <DIV class=Section1> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">We are running a version of the MSN transport here that works with <SPAN class=SpellE>xdb_sql</SPAN>. <SPAN style="mso-spacerun: yes"> </SPAN>If you'd like to run it I can email a <SPAN class=SpellE>tarball</SPAN> to you, but it won't be easy to set up.<SPAN style="mso-spacerun: yes">  </SPAN>There are quite a few things you have to do to <SPAN class=SpellE>xdb_sql</SPAN> before it will work with it.<SPAN style="mso-spacerun: yes">  </SPAN>You'll have to add a table to your <SPAN class=SpellE>mySQL</SPAN> db, add query definitions to the <SPAN class=SpellE>xdb_sql.xml</SPAN> file and there was a bug in <SPAN class=SpellE>xdb_sql</SPAN> that prevented the msn transport from working correctly with it that we fixed. <SPAN style="mso-spacerun: yes"> </SPAN>I don't know if this bug has been fixed in the newest version of <SPAN class=SpellE>xdb_sql</SPAN> or not.<SPAN style="mso-spacerun: yes">  </SPAN>The bug was due to the fact that the msn transport sends values to <SPAN class=SpellE>xdb</SPAN> as attributes of an xml tag instead of as children tags I think.<SPAN style="mso-spacerun: yes">  </SPAN>It may have been the other way around.<SPAN style="mso-spacerun: yes">  </SPAN>This functionality was broken in version 1.1 of <SPAN class=SpellE>xdb_<SPAN class=GramE>sql</SPAN></SPAN><SPAN class=GramE>,</SPAN> if it was fixed I'm sure the maintainer will chime in.<SPAN style="mso-spacerun: yes">  </SPAN>If it hasn't been fixed I need to send him our fix.<SPAN style="mso-spacerun: yes">  </SPAN>If you want to give it a shot let me know.<SPAN style="mso-spacerun: yes">  </SPAN>Just realize that it will be pretty complicated.<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P> <P class=MsoNormal><st1:PersonName style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Jason Reineri</SPAN></FONT></st1:PersonName><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Northridge Systems, Inc.<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Rodrigo Roman [mailto:dedalo@ferengi.com.ar] <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Friday, January 25, 2002 7:58 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> 'jdev@jabber.org'<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> [JDEV] Mysql and transports</SPAN></FONT></P> <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P> <P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have installes xdb_sql succesfully?</SPAN></FONT> <o:p></o:p></P> <P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Everything is working but transports, I cannot make MSN nor AIM to work, winjab disconnects when I try to browse the agent... and then it hangs... with colinjab is the same, and psi for linux also...</SPAN></FONT><o:p></o:p></P> <P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">With jabber users everything is fine...</SPAN></FONT> <o:p></o:p></P> <P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any clue?</SPAN></FONT> <o:p></o:p></P></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>