[typo] typo and mysql 5.0.15

[clint]

All,

I got it working.  I had to change the tmpdir in the /etc/my.cnf dfile
to look like:

[mysqld]
datadir=/usr/local/mysql/data
socket=/private/tmp/mysql.sock
tmpdir=/usr/local/mysql/tmp

[mysql.server]
user=mysql
basedir=/usr/local/mysql

[client]
socket=/private/tmp/mysql.sock

and make sure that I had write access to the tmpdir.

Thanks,
Clint
On 11/7/05, clint <ccagle at alumni.utexas.net> wrote:
> Does typo work with mysql 5.0.15?
>
> When I try to access http://localhost:3000 I recieve the following:
> Clint:~/temp/rails/typo clint$ script/server -e production
> => Rails application started on http://0.0.0.0:3000
> => Ctrl-C to shutdown server; call with --help for options
> [2005-11-07 20:58:10] INFO  WEBrick 1.3.1
> [2005-11-07 20:58:10] INFO  ruby 1.8.2 (2004-12-25) [powerpc-darwin8.0]
> [2005-11-07 20:58:10] INFO  WEBrick::HTTPServer#start: pid=3047 port=3000
> #<ActiveRecord::StatementInvalid: Can't create/write to file
> '/var/tmp/#sql_975_0.MYI' (Errcode: 13): SHOW FIELDS FROM sessions>
>
> I am using mysql version:
> mysql  Ver 14.12 Distrib 5.0.15, for apple-darwin7.9.0 (powerpc) using
> readline 5.0
>
> I update to the latest version of typo (725) from svn.
>
> I created a new database called typo using:
> mysql -u root -p typo < schema.mysql.sql
>
> my database.yml file looks like:
> login: &login
>   adapter: mysql
>   host: localhost
>   username: root
>   password:
>
>
> development:
>   database: typo_dev
>   <<: *login
>
> test:
>   database: typo_tests
>   <<: *login
>
> production:
>   database: typo
>   <<: *login
>
>
> what am i missing?
>
> Thanks in advance,
> clint
>


--
clint cagle | cell: 214.405.8845 | ccagle at alumni.utexas.net