I have tried to deploy my app from my windows development machine to my RHEL3 server. If I try webrick on my server and try to lgoin I get this error message. Packets out of order: 1<>3: SELECT * FROM os_user WHERE user_id = ''Smellicus'' and pass_hash = ''a8b25 f79c8e6e4c3fba40920b3c524b3'' and admin_flg = 1 LIMIT 1 I have no idea what this means. Some guru please enlighten my sorry butt. Thanks in advance Steven _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
Do you use native mysql bindings or the ruby one? First one should not give this error while also being faster ;-) Please do a gem install mysql Zsombor On 5/19/05, Steven Chan <smellicus-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I have tried to deploy my app from my windows development machine to my > RHEL3 server. If I try webrick on my server and try to lgoin I get this > error message. > > Packets out of order: 1<>3: SELECT * FROM os_user WHERE user_id > ''Smellicus'' and pass_hash = ''a8b25 > f79c8e6e4c3fba40920b3c524b3'' and admin_flg = 1 LIMIT 1 > > I have no idea what this means. Some guru please enlighten my sorry butt. > > Thanks in advance > > Steven > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-- http://deezsombor.blogspot.com
On 5/19/05, Steven Chan <smellicus-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I have tried to deploy my app from my windows development machine to my > RHEL3 server. If I try webrick on my server and try to lgoin I get this > error message. > > Packets out of order: 1<>3: SELECT * FROM os_user WHERE user_id > ''Smellicus'' and pass_hash = ''a8b25 > f79c8e6e4c3fba40920b3c524b3'' and admin_flg = 1 LIMIT 1 > > I have no idea what this means. Some guru please enlighten my sorry butt. > > Thanks in advance > > StevenIt has to do with Rails and your version of MySQL. Try searching the wiki. Here''s a page I found: http://wiki.rubyonrails.com/rails/show/MySQL%20Database%20access%20problem Also, try searching the list archives. I haven''t run into this problem personally, so this is the most I can help out :) -- rick http://techno-weenie.net
Thanks that did the trick. Now if only I could solve my apache problems... Steven On 5/19/05, Dee Zsombor <dee.zsombor-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Do you use native mysql bindings or the ruby one? First one should not > give this error while also being faster ;-) Please do a > > gem install mysql > > Zsombor > > On 5/19/05, Steven Chan <smellicus-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > I have tried to deploy my app from my windows development machine to my > > RHEL3 server. If I try webrick on my server and try to lgoin I get this > > error message. > > > > Packets out of order: 1<>3: SELECT * FROM os_user WHERE user_id > > ''Smellicus'' and pass_hash = ''a8b25 > > f79c8e6e4c3fba40920b3c524b3'' and admin_flg = 1 LIMIT 1 > > > > I have no idea what this means. Some guru please enlighten my sorry > butt. > > > > Thanks in advance > > > > Steven > > > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > > > > > -- > http://deezsombor.blogspot.com >_______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
I ran into the same error today Packets out of order: 1<>3. However, it was in the context of trying to set custom :finder_sql option for one of my habtm associations. I am indeed using the Ruby mysql driver also and people in the chat room gave me the standard response of trying to switch to native. That turned out to be a little more complicated than I had time for, so I went back and hacked a workaround. The results make me suspect that there is more to this problem than just a driver issue. First, I made absolutely sure that my custom sql was correct -- directly against the db. That let me find a workaround by adding an accessor method to my model (wrapping a find_by_sql call using my custom query). If I can figure out what is going on I''ll of course follow up here... Obie> ---------- Forwarded message ---------- > From: Steven Chan <smellicus-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > To: Dee Zsombor <dee.zsombor-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > Date: Thu, 19 May 2005 23:35:55 +0800 > Subject: Re: [Rails] ActiveRecord problem > Thanks that did the trick. Now if only I could solve my apache problems... > > Steven > > On 5/19/05, Dee Zsombor <dee.zsombor-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > Do you use native mysql bindings or the ruby one? First one should not > > give this error while also being faster ;-) Please do a > > > > gem install mysql > > > > Zsombor > > > > On 5/19/05, Steven Chan < smellicus-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > I have tried to deploy my app from my windows development machine to my > > > RHEL3 server. If I try webrick on my server and try to lgoin I get this > > > error message. > > > > > > Packets out of order: 1<>3: SELECT * FROM os_user WHERE user_id > > > ''Smellicus'' and pass_hash = ''a8b25 > > > f79c8e6e4c3fba40920b3c524b3'' and admin_flg = 1 LIMIT 1 > > > > > > I have no idea what this means. Some guru please enlighten my sorry > butt. > > > > > > Thanks in advance > > > > > > Steven
On May 19, 2005, at 11:46 PM, Obie Fernandez wrote:>>>> Packets out of order: 1<>3: SELECT * FROM os_user WHERE user_id >>>> ''Smellicus'' and pass_hash = ''a8b25 >>>> f79c8e6e4c3fba40920b3c524b3'' and admin_flg = 1 LIMIT 1I had this problem, and found this solution http://blog.rebelplatoon.com/articles/2005/05/12/mysql-woes-and- activerecord -- Craig Beck http://blog.rebelplatoon.com http://luckybonza.com AIM: Kreiggers