forgot password?
Forum Home > Usage > Troubleshooting > Thread
   
 
database not configured?  really?
 
emory
Posted: 26 July 2006 06:27 PM   [ Ignore ]  
Newbie
Rank
Total Posts:  20
Joined  2006-07-26

Upon launching script/server -e production:

./script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:194:in `establish_connection’: production database is not configured (ActiveRecord::AdapterNotSpecified)


lies!  all lies!

development:
      adapter: sqlite3
      database: ~/webdocs/incumbent/tracks/db/tracks-104.db

test:
      adapter: sqlite3
      database: ~/webdocs/incumbent/tracks/db/tracks-104.db

production:
      adapter: sqlite3
      database: /Volumes/miniStack/Users/emory/webdocs/incumbent/tracks/db/tracks-104.db

note: ~/webdocs… is = /Volumes/miniStack/... I was experimenting a bit and it seemed to make no difference.

Any ideas?  Stock distribution of Tracks.  Running current release code, not dev.
Profile
 
 
Craig
Posted: 26 July 2006 09:14 PM   [ Ignore ]   [ # 1 ]  
Newbie
Rank
Total Posts:  28
Joined  2006-06-28

your tracks directory is really just called tracks (and not by any chance tracks-1.041)?

 Signature 

Tracks 1.042 on Locomotive / Camino 1.0.1
Profile
 
 
emory
Posted: 26 July 2006 11:17 PM   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  20
Joined  2006-07-26

‘tracks’ is symlinked to ‘tracks-1.041’.
Profile
 
 
bsag
Posted: 27 July 2006 07:01 AM   [ Ignore ]   [ # 3 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  223
Joined  2006-03-05

I’m not sure how well Rails deals with symlinks, because I’ve never tried it. However, did you run the script/server line from within /Volumes/miniStack/Users/emory/webdocs/incumbent/tracks? If you do that, then you should be able to give the path as just db/tracks-1.041.db
Profile
 
 
myles
Posted: 27 July 2006 02:02 PM   [ Ignore ]   [ # 4 ]  
Newbie
Rank
Total Posts:  6
Joined  2006-06-28
emory - 26 July 2006 06:27 PM

      adapter: sqlite3
      database: ~/webdocs/incumbent/tracks/db/tracks-104.db

Are you sure it is sqlite3 not sqlite? Also could you do a ls -la in ~/webdocs/incumbent/tracks/db/.
Profile
 
 
emory
Posted: 27 July 2006 07:19 PM   [ Ignore ]   [ # 5 ]  
Newbie
Rank
Total Posts:  20
Joined  2006-07-26
myles - 27 July 2006 02:02 PM
emory - 26 July 2006 06:27 PM

      adapter: sqlite3
      database: ~/webdocs/incumbent/tracks/db/tracks-104.db

Are you sure it is sqlite3 not sqlite? Also could you do a ls -la in ~/webdocs/incumbent/tracks/db/.

That isn’t the issue.

Permissions are fine:

.-(~/webdocs/incumbent/tracks)-----------------------------------(emory@hungus)-
`--> ls -la db
total 48
drwxr-xr-x    7 emory  staff    238 Apr 17 13:24 ./
drwxr-xr-x   19 emory  staff    646 Jul 26 11:23 ../
drwxr-xr-x    2 emory  staff     68 Apr 17 13:24 exported_fixtures/
drwxr-xr-x    9 emory  staff    306 May 11 13:27 migrate/
-rw-r--r--    1 emory  staff   2182 Apr  8 18:46 schema.rb
-rw-r--r--    1 emory  staff  11264 Feb 26 16:26 tracks-104.db
-rw-r--r--    1 emory  staff   4765 Feb 26 16:26 tracks_1.04_content.sql 
Profile
 
 
emory
Posted: 27 July 2006 07:46 PM   [ Ignore ]   [ # 6 ]  
Newbie
Rank
Total Posts:  20
Joined  2006-07-26

oy!

this is lunacy.

apparently you MUST have two spaces before the subvars in the directives in database.yml.

i had a tab.  can’t use a tab.

so it MUST look like this:

production:
  adapter: sqlite3  
  database: ~rewl/webdocs/incumbent/tracks/db/tracks-104.db 

arrrgh!
Profile
 
 
bsag
Posted: 27 July 2006 08:52 PM   [ Ignore ]   [ # 7 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  223
Joined  2006-03-05

Yes, that’s one of YAML’s least attractive qualities. But to be fair, it is mentioned in installation.html:

“It’s very important that you don’t use TABS in any of the *.yml files. Just use spaces to indent.”

It’s one of those things that’s really difficult to track down as an error because the error message is so non-informative.
Profile
 
 
   
 
 
‹‹ Internet Explorer 6 woes      Tracks running very very slow on Windows XP Pro ››