# Problem with sqlite3

**URL:** <https://www.ruby-forum.com/t/problem-with-sqlite3/152117>\
**Category:** Rails\
**Created:** [October 30, 2008, 7:49am UTC](https://www.ruby-forum.com/t/problem-with-sqlite3/152117 "2008-10-30T07:49:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![hai\_l](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/c68b51/32.png) [@hai\_l](https://www.ruby-forum.com/u/hai_l)\
**Post date:** [October 30, 2008, 7:49am UTC](https://www.ruby-forum.com/t/problem-with-sqlite3/152117/1 "2008-10-30T07:49:50Z")

</div>

I have problem when login 127.0.0.1

About your application’s environment  
CGI::Session::CookieStore::TamperedWithCookie in  
Rails/infoController#properties

CGI::Session::CookieStore::TamperedWithCookie

RAILS\_ROOT: C:/ruby/testing  
Application Trace | Framework Trace | Full Trace

Request

Parameters:

None

Show session dump

* * *

flash: !map:ActionController::Flash::FlashHash {}

Response

Headers:

{“cookie”=\>[],  
“Content-Type”=\>"",  
“Cache-Control”=\>“no-cache”}

My enviroment is  
ruby 1.8.6(2007 -09 -24 patchlevel 111)[i386-mswin32]  
ruby gem 1.3.1  
rails 2.2.0  
action… 2.2.0  
mongrel web server 1.1.5  
sqlite3 3.6.4

When I try “gem install sqlite2-ruby” it error  
failed to build gem native extension  
nmake is not recognize as an internal or external command, operable  
program or batch file …

Can someone give me the way to fix it?

---

<div class="post-metadata">

**Author:** ![hai\_l](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/c68b51/32.png) [@hai\_l](https://www.ruby-forum.com/u/hai_l)\
**Post date:** [October 30, 2008, 2:14pm UTC](https://www.ruby-forum.com/t/problem-with-sqlite3/152117/2 "2008-10-30T14:14:40Z")

</div>

Help me plz! Or it is a bug in rail 2.20

---

<div class="post-metadata">

**Author:** ![hai\_l](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/c68b51/32.png) [@hai\_l](https://www.ruby-forum.com/u/hai_l)\
**Post date:** [October 31, 2008, 7:14am UTC](https://www.ruby-forum.com/t/problem-with-sqlite3/152117/3 "2008-10-31T07:14:35Z")

</div>

Sounds like you have a stale cookie laying around. You can check for  
this through the preferences menu related to your browser.

You could just delete all cookies related to localhost (i.e.  
127.0.0.1) and then reload your application. I’ve seen this related  
to changes to the config/environment.rb file - see the comment in that  
file.

Rick

On Oct 30, 3:14 am, Hai anh Le [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![hai\_l](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/c68b51/32.png) [@hai\_l](https://www.ruby-forum.com/u/hai_l)\
**Post date:** [October 31, 2008, 9:53am UTC](https://www.ruby-forum.com/t/problem-with-sqlite3/152117/4 "2008-10-31T09:53:08Z")

</div>

Rick wrote:

> Sounds like you have a stale cookie laying around. You can check for  
> this through the preferences menu related to your browser.
> 
> You could just delete all cookies related to localhost (i.e.  
> 127.0.0.1) and then reload your application. I’ve seen this related  
> to changes to the config/environment.rb file - see the comment in that  
> file.
> 
> Rick
> 
> On Oct 30, 3:14�am, Hai anh Le [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

Yes, I have fix it by the way that I uninstall anything, then install  
all by console code. But sqlite3 1.2.4 can run with Window, so that I  
try to install version 1.2.3. Now anything is OK 😃

---

<div class="post-metadata">

**Author:** ![hai\_l](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/c68b51/32.png) [@hai\_l](https://www.ruby-forum.com/u/hai_l)\
**Post date:** [October 31, 2008, 9:57am UTC](https://www.ruby-forum.com/t/problem-with-sqlite3/152117/5 "2008-10-31T09:57:16Z")

</div>

I type wrong. sqlite 1.2.4 can’t run in Window so that you can try  
sqlite 1.2.3

---

<div class="post-metadata">

**Author:** ![hai\_l](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/c68b51/32.png) [@hai\_l](https://www.ruby-forum.com/u/hai_l)\
**Post date:** [February 18, 2009, 12:15am UTC](https://www.ruby-forum.com/t/problem-with-sqlite3/152117/6 "2009-02-18T00:15:08Z")

</div>

Hai anh Le wrote:

> I type wrong. sqlite 1.2.4 can’t run in Window so that you can try  
> sqlite 1.2.3

Hi Hai,

I am facing the same problem with sqlite3 as well as mysql. Can you help  
me fix it as you already did the same thing.

Thanks

Sulabh J.