Skip Menu |
 

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 15889
Status: resolved
Priority: 0/
Queue: DBIx-Class

People
Owner: Nobody in particular
Requestors: m.romani [...] spinsoft.it
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: MySQL config suggestions to test under Win32
Download (untitled) / with headers
text/plain 818b
The tests try to connect to database 'test' with no username and no password. The resulting error under Win32 is access deined for user 'ODBC'@'localhost'. The fix is obvious: create database test; grant select,insert,update,delete,create,drop on test.* to 'ODBC'@'localhost'; flush privileges; but it doesn't work. The reason is that the parameter sql-mode is, by default: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" The option NO_AUTO_CREATE_USER prevents you from creating passwordless accounts. If you remote it and restart mysql, the previous statements work fine, and the mysql tests can run. (The parameter is in my.ini, whose default location is the MySQL Server subdir. To find out which config file you are using I recommend you install mysql-administrator from mysql.com)
Download (untitled) / with headers
text/plain 965b
[guest - Thu Nov 17 06:29:58 2005]: Show quoted text
> The tests try to connect to database 'test' with no username and no > password. > The resulting error under Win32 is access deined for user > 'ODBC'@'localhost'. > > The fix is obvious: > > create database test; > grant select,insert,update,delete,create,drop on test.* to > 'ODBC'@'localhost'; > flush privileges; > > but it doesn't work. > The reason is that the parameter sql-mode is, by default: > > sql- > mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" > > The option NO_AUTO_CREATE_USER prevents you from creating passwordless > accounts. > If you remote it and restart mysql, the previous statements work fine, > and the mysql tests can run. > > (The parameter is in my.ini, whose default location is the MySQL > Server subdir. To find out which config file you are using I recommend > you install mysql-administrator from mysql.com)
I'm sorry, I meant to post this for Class::DBI::Sweet.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.