hi, guys:
i''m Writing Depot app on Mac OS X(10.5.2 Leopard) using bash, when
running a db migrate to create product table, and i get this error:
rake aborted!
Mysql::Error: Can''t create/write to file
''/var/folders/Gt/GthmQ9UrH-Ols3WlCkC7qE+++TI/-Tmp-/#sql_1f4_0.MYI''
(Errcode:
13): SHOW FIELDS FROM products
Anyone knows this reason and tell me how to solve it, thinks
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
Venture Lee wrote:> rake aborted! > Mysql::Error: Can''t create/write to file > ''/var/folders/Gt/GthmQ9UrH-Ols3WlCkC7qE+++TI/-Tmp-/#sql_1f4_0.MYI'' > (Errcode: > 13): SHOW FIELDS FROM products > > Anyone knows this reason and tell me how to solve it, thinksIt appears that your mysql can''t access it''s own storage files, check permissions on the folders and make sure that the account that mysql is using has write permissions to that folder.. Perhaps reinstalling mysql will solve the problem hth ilan -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I would say your MySQL installation is screwed up somehow. That folder looks not normal. How did you install Rails and MySQL? On Feb 24, 2008, at 12:19 AM, venture Lee wrote:> hi, guys: > > i''m Writing Depot app on Mac OS X(10.5.2 Leopard) using bash, > when running a db migrate to create product table, and i get this > error: > > rake aborted! > Mysql::Error: Can''t create/write to file ''/var/folders/Gt/GthmQ9UrH- > Ols3WlCkC7qE+++TI/-Tmp-/#sql_1f4_0.MYI'' (Errcode: 13): SHOW FIELDS > FROM products > > Anyone knows this reason and tell me how to solve it, thinks--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Venture Lee wrote:> Mysql::Error: Can''t create/write to file > ''/var/folders/Gt/GthmQ9UrH-Ols3WlCkC7qE+++TI/-Tmp-/#sql_1f4_0.MYI'' > (Errcode: > 13): SHOW FIELDS FROM productsThis area (/var/folders) contains a number of files related to running applications. In this particular case, it looks like some temporary storage for MySQL. Was MySQL installed as an admin user? Is it set to start up on boot or do you start it manually? The /var/folders area is a protected area and, in general, only applications running with admin rights will be able to use it so MySQL must be setup from an admin user account. My recommendation would be to stop the MySQL service (from System Preferences), re-install the package as an admin user, setting it running (from the admin account) and try again. Some people have had success by just giving all users on the machine full read/write access to /var/folders (as admin user: sudo chown -R a+rw /var/folders), but this should be a last resort as it may open up your machine to other problems. Try searching the internet for references to this directory (especially on Apple support sites). -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
thanks all, i''m a newbie with leopard, and i download mysql from www.mysql.com (mysql-5.1.23.dmg), and install it by a normal user, then su to root user, run the script "/usr/local/mysql/support-files/mysql.server start" to start mysql server, i don''t know this way correctly or not, and if i was wrong, what should i do? thanks very much~ On Mon, Feb 25, 2008 at 4:18 AM, Mark Bush <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Venture Lee wrote: > > Mysql::Error: Can''t create/write to file > > ''/var/folders/Gt/GthmQ9UrH-Ols3WlCkC7qE+++TI/-Tmp-/#sql_1f4_0.MYI'' > > (Errcode: > > 13): SHOW FIELDS FROM products > > This area (/var/folders) contains a number of files related to running > applications. In this particular case, it looks like some temporary > storage for MySQL. Was MySQL installed as an admin user? Is it set to > start up on boot or do you start it manually? > > The /var/folders area is a protected area and, in general, only > applications running with admin rights will be able to use it so MySQL > must be setup from an admin user account. > > My recommendation would be to stop the MySQL service (from System > Preferences), re-install the package as an admin user, setting it > running (from the admin account) and try again. > > Some people have had success by just giving all users on the machine > full read/write access to /var/folders (as admin user: sudo chown -R > a+rw /var/folders), but this should be a last resort as it may open up > your machine to other problems. > > Try searching the internet for references to this directory (especially > on Apple support sites). > > -- > Posted via http://www.ruby-forum.com/. > > > >--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
i have seloved this problem, add parameter --user=root to start mysql On Mon, Feb 25, 2008 at 9:42 AM, venture Lee <liwenqiu-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> thanks all, i''m a newbie with leopard, and i download mysql from > www.mysql.com (mysql-5.1.23.dmg), and install it by a normal user, then su > to root user, run the script "/usr/local/mysql/support-files/mysql.server > start" to start mysql server, i don''t know this way correctly or not, and > if i was wrong, what should i do? thanks very much~ > > > On Mon, Feb 25, 2008 at 4:18 AM, Mark Bush < > rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: > > > > > Venture Lee wrote: > > > Mysql::Error: Can''t create/write to file > > > ''/var/folders/Gt/GthmQ9UrH-Ols3WlCkC7qE+++TI/-Tmp-/#sql_1f4_0.MYI'' > > > (Errcode: > > > 13): SHOW FIELDS FROM products > > > > This area (/var/folders) contains a number of files related to running > > applications. In this particular case, it looks like some temporary > > storage for MySQL. Was MySQL installed as an admin user? Is it set to > > start up on boot or do you start it manually? > > > > The /var/folders area is a protected area and, in general, only > > applications running with admin rights will be able to use it so MySQL > > must be setup from an admin user account. > > > > My recommendation would be to stop the MySQL service (from System > > Preferences), re-install the package as an admin user, setting it > > running (from the admin account) and try again. > > > > Some people have had success by just giving all users on the machine > > full read/write access to /var/folders (as admin user: sudo chown -R > > a+rw /var/folders), but this should be a last resort as it may open up > > your machine to other problems. > > > > Try searching the internet for references to this directory (especially > > on Apple support sites). > > > > -- > > Posted via http://www.ruby-forum.com/. > > > > > > > > >--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Can you please tell me, where did you add this parameter? On Feb 26, 9:59 am, "venture Lee" <liwen...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> i have seloved this problem, add parameter --user=root to start mysql > > On Mon, Feb 25, 2008 at 9:42 AM, venture Lee <liwen...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > thanks all, i''m a newbie with leopard, and i download mysql from > >www.mysql.com(mysql-5.1.23.dmg), and install it by a normal user, then su > > to root user, run the script "/usr/local/mysql/support-files/mysql.server > > start" to start mysql server, i don''t know this way correctly or not, and > > if i was wrong, what should i do? thanks very much~ > > > On Mon, Feb 25, 2008 at 4:18 AM, Mark Bush < > > rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: > > > > Venture Lee wrote: > > > > Mysql::Error: Can''t create/write to file > > > > ''/var/folders/Gt/GthmQ9UrH-Ols3WlCkC7qE+++TI/-Tmp-/#sql_1f4_0.MYI'' > > > > (Errcode: > > > > 13): SHOW FIELDS FROM products > > > > This area (/var/folders) contains a number of files related to running > > > applications. In this particular case, it looks like some temporary > > > storage for MySQL. Was MySQL installed as an admin user? Is it set to > > > start up on boot or do you start it manually? > > > > The /var/folders area is a protected area and, in general, only > > > applications running with admin rights will be able to use it so MySQL > > > must be setup from an admin user account. > > > > My recommendation would be to stop the MySQL service (from System > > > Preferences), re-install the package as an admin user, setting it > > > running (from the admin account) and try again. > > > > Some people have had success by just giving all users on the machine > > > full read/write access to /var/folders (as admin user: sudo chown -R > > > a+rw /var/folders), but this should be a last resort as it may open up > > > your machine to other problems. > > > > Try searching the internet for references to this directory (especially > > > on Apple support sites). > > > > -- > > > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@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 -~----------~----~----~----~------~----~------~--~---