Ive got as far as "rake db:migrate"
Got a MYSQL DB called appointments with the database.yml setup
Mongrel is running - I can see an exception caught and debug dump at
0.0.0.0:3000
But the app cant find a socket to connect to mysql. I can connect and
see the DB using bash and mysql monitor as the correct user (ie DB
permissions are correct)
Cant see anyway to configure the app access to DB - it is looking for
the socket at /tmp/mysql.sock in the debug dump (is this in the app
directory?)
MYSQL Configuration (from /usr/share/mysql/my-small.cnf)
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
net_buffer_length = 2K
thread_stack = 64K
It is the same for medium/large/huge
Im sure the answer is simple
Thanks in advance
Richard
Debug dump from "rake db:migrate --trace"
(in /home/richard/Desktop/Programming/appointments)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
No such file or directory - /tmp/mysql.sock
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:104:in
`initialize'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:104:in
`new'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:104:in
`real_connect'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:335:in
`connect'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:87:in
`initialize'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:36:in
`new'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:36:in
`mysql_connection'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:252:in
`send'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:252:in
`connection_without_query_cache='
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in
`connection='
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in
`retrieve_connection'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
`connection'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/activerecord/lib/active_record/migration.rb:283:in
`migrate'
/home/richard/Desktop/Programming/appointments/config/../vendor/rails/railties/lib/tasks/databases.rake:4
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `call'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:357:in `invoke'
/usr/local/lib/ruby/1.8/thread.rb:135:in `synchronize'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in `invoke'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/bin/rake:7
/usr/local/bin/rake:18:in `load'
/usr/local/bin/rake:18
Horst Herb wrote:
Until I manage to set up the subversion repository for this (and have gone
through the source code myself) those who can't wait can access the tarball
of the complete source at:
http://ozdocit.org/tiki-list_file_gallery.php?galleryId=7
In order to install you need
- RoR installed
- Mongrel installed
- blank database created (no tables at all)
- unpack that tarball into any directory
- in this directory, create config/database.yml (example in
config/database.example)
- in this directory, type "rake db:migrate"
- in this directory, start Mongrel
You should now be able to use the appointment system by pointing your browser
at the computer running Mongrel (default port 3000)
Have fun with it,
Horst
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
