Rails - Apr 2010 - Switching from SQLite 3 to MySQL DB gives strange redirects

Hi there,

I have a site that''s been running for a few years now and I want to
change the Database to MySQL from SQLite,

Using yaml_db I performed the migration fairly seamlessly, and have
the site up and running with all my data in MySQL now, however I have
a few problems on a couple of authenticated areas of my site.

I have an admin section, and when I try and log in, I don''t receive
any errors but return to the login page, the log shows this...

"Filter chain halted as [:authorize] rendered_or_redirected."

I''m not sure why I''m getting this redirect because if I edit
the
database.yml config file to use my SQLite DB again and retry logging
in, it will accept, so this would mean to me that it isn''t an issue
with my before_filters or routes.rb.

Can anyone shed any light on what might be causing this?, I''m using
Rails 2.3.5

Cheers,

Blaise.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On Apr 5, 2010, at 2:36 AM, Blaise wrote:
> Hi there,
>
> I have a site that''s been running for a few years now and I want
to
> change the Database to MySQL from SQLite,
>
> Using yaml_db I performed the migration fairly seamlessly, and have
> the site up and running with all my data in MySQL now, however I have
> a few problems on a couple of authenticated areas of my site.
>
> I have an admin section, and when I try and log in, I don''t
receive
> any errors but return to the login page, the log shows this...
>
> "Filter chain halted as [:authorize] rendered_or_redirected."
>
> I''m not sure why I''m getting this redirect because if I
edit the
> database.yml config file to use my SQLite DB again and retry logging
> in, it will accept, so this would mean to me that it isn''t an
issue
> with my before_filters or routes.rb.
>
> Can anyone shed any light on what might be causing this?, I''m
using
> Rails 2.3.5
You need to examine the code in the :authorize filter and see why it''s
returning false.  Run the queries it is running and see what happens.

My guess is that you''ve got a boolean field somewhere that sqlite  
thinks is true, but mysql thinks is false.

or something similar.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On 5 April 2010 10:36, Blaise
<abienz-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Hi there,
>
> I have a site that''s been running for a few years now and I want
to
> change the Database to MySQL from SQLite,
Is that a good idea?  I don''t think sqlite is recommended for deployed
systems.

Colin

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

I wanted to test it out to see how it performed, generally it was
pretty good. however it failed at performing multiple transactions,
naturally this isn''t great for a web app.

On Apr 5, 5:32 pm, Colin Law
<clan...-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org>
wrote:
> On 5 April 2010 10:36, Blaise
<abi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> > Hi there,
>
> > I have a site that''s been running for a few years now and I
want to
> > change the Database to MySQL from SQLite,
>
> Is that a good idea?  I don''t think sqlite is recommended for
deployed systems.
>
> Colin
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.