From: Harold M. <coc...@ea...> - 2003-11-03 01:49:20
|
I'm following the instructions in the book, when I get to installing DBIx::Password, but it can't connect to the mysql db with the slash user (though it can with the root user). I tried connecting to the slash user with mysql: mysql -u slash -p Enter password: ERROR 1045: Access denied for user: 'slash@localhost' (Using password: YES) I've reset the password, flushed privileges, etc.but I can't get the slash user working. And ideas? TIA, Harold |
From: Shane <sh...@lo...> - 2003-11-03 12:30:23
|
Check what host is defined, in mysql, that that user can login as. Shane On Nov 2, 2003, at 7:44 PM, Harold Martin wrote: > I'm following the instructions in the book, when I get to installing > DBIx::Password, but it can't connect to the mysql db with the slash > user > (though it can with the root user). > I tried connecting to the slash user with mysql: > mysql -u slash -p > Enter password: > ERROR 1045: Access denied for user: 'slash@localhost' (Using password: > YES) > > I've reset the password, flushed privileges, etc.but I can't get the > slash user working. > And ideas? > > TIA, > Harold > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general > |
From: Chris J. <jo...@nm...> - 2003-11-03 12:51:48
|
On Mon, 3 Nov 2003, Shane wrote: > Check what host is defined, in mysql, that that user can login as. > > Shane > > I think I'd see a complaint from mysql about an illegal connection if there as a problem. But I checked and the user is in mysql.user and the mysql.db table allows access to the database for it. ------------------------------------------------------------------------------- Chris Johnson |Internet: jo...@nm... Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson NMR Center |Voice: 617.726.0949 Mass. General Hospital |FAX: 617.726.7422 149 (2301) 13th Street |Survival, all by it self, isn't worth it. Charlestown, MA., 02129 USA | Me ------------------------------------------------------------------------------- |
From: Harold M. <coc...@ea...> - 2003-11-03 15:32:20
|
Here's some info from the mysql db (sorry the formatting ges messed up): SELECT * FROM db; +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ | % | test | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | | % | test\_% | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ SELECT * FROM tables_priv; +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ | Host | Db | User | Table_name | Grantor | Timestamp | Table_priv | Column_priv | +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ | % | slash | slash | localhost | root@localhost | 20031102180006 | Select,Insert,Update,Delete,Create,Drop,References,Index,Alter | | +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ SELECT * FROM user WHERE User='slash'; +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | % | slash | nice try ;-) | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ TIA, Harold On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: > On Mon, 3 Nov 2003, Shane wrote: > > > Check what host is defined, in mysql, that that user can login as. > > > > Shane > > > > > > I think I'd see a complaint from mysql about an illegal > connection if there as a problem. But I checked and the user is in > mysql.user and the mysql.db table allows access to the database for > it. > > ------------------------------------------------------------------------------- > Chris Johnson |Internet: jo...@nm... > Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson > NMR Center |Voice: 617.726.0949 > Mass. General Hospital |FAX: 617.726.7422 > 149 (2301) 13th Street |Survival, all by it self, isn't worth it. > Charlestown, MA., 02129 USA | Me > ------------------------------------------------------------------------------- > |
From: Patrick G. <pa...@pa...> - 2003-11-03 17:02:56
|
Harold, Please do this: connect to your mysql's 'mysql' database mysql -u root -p mysql select Host from user where User = 'slash'; whichever hosts appear from that select, ensure that DBIx::Password has the correct values: locate Password.pm on my box: [root@krsna root]# locate Password.pm /usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm edit this... my $virtual1 = { 'slash' => { 'driver' => 'mysql', 'username' => 'slash', 'attributes' => {}, 'port' => '', 'database' => 'slash', 'password' => 'yourpass', 'host' => 'EDITTHISVALUEHAROLD', 'connect' => 'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' } }; make sure host is set to the value of the 'Host' column had for the slash user in the 'mysql' database. (Note: When you install DBIx::Password, it should have already asked you what to choose for the host value). Hope this helps, regards, Patrick Harold Martin wrote: > Here's some info from the mysql db (sorry the formatting ges messed up): > SELECT * FROM db; > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > | Host | Db | User | Select_priv | Insert_priv | Update_priv | > Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | > Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > | % | test | | Y | Y | Y | > Y | Y | Y | N | Y | > Y | Y | Y | Y | > | % | test\_% | | Y | Y | Y | > Y | Y | Y | N | Y | > Y | Y | Y | Y | > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > SELECT * FROM tables_priv; > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > | Host | Db | User | Table_name | Grantor | Timestamp | > Table_priv | > Column_priv | > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > | % | slash | slash | localhost | root@localhost | 20031102180006 | > Select,Insert,Update,Delete,Create,Drop,References,Index,Alter > | | > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > SELECT * FROM user WHERE User='slash'; > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > | Host | User | Password | Select_priv | Insert_priv | > Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | > Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv > | Index_priv | Alter_priv | Show_db_priv | Super_priv | > Create_tmp_table_priv | Lock_tables_priv | Execute_priv | > Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer > | x509_subject | max_questions | max_updates | max_connections | > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > | % | slash | nice try ;-) | N | N | N > | N | N | N | N | N | > N | N | N | N | N | N | > N | N | N | N | > N | N | N | > | | | | 0 | 0 > | 0 | > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > TIA, > Harold > > On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: > >>On Mon, 3 Nov 2003, Shane wrote: >> >> >>>Check what host is defined, in mysql, that that user can login as. >>> >>> Shane >>> >>> >> >> I think I'd see a complaint from mysql about an illegal >>connection if there as a problem. But I checked and the user is in >>mysql.user and the mysql.db table allows access to the database for >>it. >> >>------------------------------------------------------------------------------- >>Chris Johnson |Internet: jo...@nm... >>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson >>NMR Center |Voice: 617.726.0949 >>Mass. General Hospital |FAX: 617.726.7422 >>149 (2301) 13th Street |Survival, all by it self, isn't worth it. >>Charlestown, MA., 02129 USA | Me >>------------------------------------------------------------------------------- >> > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general -- ---------------------- Patrick Galbraith Senior Software Developer pa...@se... pa...@pa... cap...@sl... |
From: Harold M. <coc...@ea...> - 2003-11-03 17:36:34
|
How can I test to make sure this worked correctly? Thanks, Harold On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: > Harold, > > Please do this: > > connect to your mysql's 'mysql' database > > mysql -u root -p mysql > > select Host from user where User = 'slash'; > > whichever hosts appear from that select, ensure that DBIx::Password has > the correct values: > > locate Password.pm > > on my box: > > [root@krsna root]# locate Password.pm > /usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm > > edit this... > > my $virtual1 = { > 'slash' => { > 'driver' => 'mysql', > 'username' => 'slash', > 'attributes' => {}, > 'port' => '', > 'database' => 'slash', > 'password' => 'yourpass', > 'host' => 'EDITTHISVALUEHAROLD', > 'connect' => > 'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' > } > }; > > make sure host is set to the value of the 'Host' column had for the > slash user in the 'mysql' database. (Note: When you install > DBIx::Password, it should have already asked you what to choose for the > host value). > > Hope this helps, > > regards, > > Patrick > > Harold Martin wrote: > > Here's some info from the mysql db (sorry the formatting ges messed up): > > SELECT * FROM db; > > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > > | Host | Db | User | Select_priv | Insert_priv | Update_priv | > > Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | > > Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | > > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > > | % | test | | Y | Y | Y | > > Y | Y | Y | N | Y | > > Y | Y | Y | Y | > > | % | test\_% | | Y | Y | Y | > > Y | Y | Y | N | Y | > > Y | Y | Y | Y | > > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > > SELECT * FROM tables_priv; > > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > > | Host | Db | User | Table_name | Grantor | Timestamp | > > Table_priv | > > Column_priv | > > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > > | % | slash | slash | localhost | root@localhost | 20031102180006 | > > Select,Insert,Update,Delete,Create,Drop,References,Index,Alter > > | | > > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > > SELECT * FROM user WHERE User='slash'; > > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > | Host | User | Password | Select_priv | Insert_priv | > > Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | > > Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv > > | Index_priv | Alter_priv | Show_db_priv | Super_priv | > > Create_tmp_table_priv | Lock_tables_priv | Execute_priv | > > Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer > > | x509_subject | max_questions | max_updates | max_connections | > > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > | % | slash | nice try ;-) | N | N | N > > | N | N | N | N | N | > > N | N | N | N | N | N | > > N | N | N | N | > > N | N | N | > > | | | | 0 | 0 > > | 0 | > > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > > > TIA, > > Harold > > > > On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: > > > >>On Mon, 3 Nov 2003, Shane wrote: > >> > >> > >>>Check what host is defined, in mysql, that that user can login as. > >>> > >>> Shane > >>> > >>> > >> > >> I think I'd see a complaint from mysql about an illegal > >>connection if there as a problem. But I checked and the user is in > >>mysql.user and the mysql.db table allows access to the database for > >>it. > >> > >>------------------------------------------------------------------------------- > >>Chris Johnson |Internet: jo...@nm... > >>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson > >>NMR Center |Voice: 617.726.0949 > >>Mass. General Hospital |FAX: 617.726.7422 > >>149 (2301) 13th Street |Survival, all by it self, isn't worth it. > >>Charlestown, MA., 02129 USA | Me > >>------------------------------------------------------------------------------- > >> > > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SF.net Giveback Program. > > Does SourceForge.net help you be more productive? Does it > > help you create better code? SHARE THE LOVE, and help us help > > YOU! Click Here: http://sourceforge.net/donate/ > > _______________________________________________ > > Slashcode-general mailing list > > Sla...@li... > > https://lists.sourceforge.net/lists/listinfo/slashcode-general |
From: Harold M. <coc...@ea...> - 2003-11-03 17:49:10
|
The value I got from mysql (and used in Password.pm) is '%' I continued with the slash install and eventually got this error: ./bin/install-slashsite -u slash DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 Major Mojo Bad things unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) Database % unsupported! (virtual user: slash) at /usr/lib/perl5/site_perl/5.8.0/i686-linux/Slash/DB.pm line 44. Thanks for the help, Harold On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: > Harold, > > Please do this: > > connect to your mysql's 'mysql' database > > mysql -u root -p mysql > > select Host from user where User = 'slash'; > > whichever hosts appear from that select, ensure that DBIx::Password has > the correct values: > > locate Password.pm > > on my box: > > [root@krsna root]# locate Password.pm > /usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm > > edit this... > > my $virtual1 = { > 'slash' => { > 'driver' => 'mysql', > 'username' => 'slash', > 'attributes' => {}, > 'port' => '', > 'database' => 'slash', > 'password' => 'yourpass', > 'host' => 'EDITTHISVALUEHAROLD', > 'connect' => > 'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' > } > }; > > make sure host is set to the value of the 'Host' column had for the > slash user in the 'mysql' database. (Note: When you install > DBIx::Password, it should have already asked you what to choose for the > host value). > > Hope this helps, > > regards, > > Patrick > > Harold Martin wrote: > > Here's some info from the mysql db (sorry the formatting ges messed up): > > SELECT * FROM db; > > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > > | Host | Db | User | Select_priv | Insert_priv | Update_priv | > > Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | > > Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | > > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > > | % | test | | Y | Y | Y | > > Y | Y | Y | N | Y | > > Y | Y | Y | Y | > > | % | test\_% | | Y | Y | Y | > > Y | Y | Y | N | Y | > > Y | Y | Y | Y | > > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > > SELECT * FROM tables_priv; > > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > > | Host | Db | User | Table_name | Grantor | Timestamp | > > Table_priv | > > Column_priv | > > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > > | % | slash | slash | localhost | root@localhost | 20031102180006 | > > Select,Insert,Update,Delete,Create,Drop,References,Index,Alter > > | | > > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > > SELECT * FROM user WHERE User='slash'; > > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > | Host | User | Password | Select_priv | Insert_priv | > > Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | > > Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv > > | Index_priv | Alter_priv | Show_db_priv | Super_priv | > > Create_tmp_table_priv | Lock_tables_priv | Execute_priv | > > Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer > > | x509_subject | max_questions | max_updates | max_connections | > > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > | % | slash | nice try ;-) | N | N | N > > | N | N | N | N | N | > > N | N | N | N | N | N | > > N | N | N | N | > > N | N | N | > > | | | | 0 | 0 > > | 0 | > > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > > > TIA, > > Harold > > > > On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: > > > >>On Mon, 3 Nov 2003, Shane wrote: > >> > >> > >>>Check what host is defined, in mysql, that that user can login as. > >>> > >>> Shane > >>> > >>> > >> > >> I think I'd see a complaint from mysql about an illegal > >>connection if there as a problem. But I checked and the user is in > >>mysql.user and the mysql.db table allows access to the database for > >>it. > >> > >>------------------------------------------------------------------------------- > >>Chris Johnson |Internet: jo...@nm... > >>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson > >>NMR Center |Voice: 617.726.0949 > >>Mass. General Hospital |FAX: 617.726.7422 > >>149 (2301) 13th Street |Survival, all by it self, isn't worth it. > >>Charlestown, MA., 02129 USA | Me > >>------------------------------------------------------------------------------- > >> > > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SF.net Giveback Program. > > Does SourceForge.net help you be more productive? Does it > > help you create better code? SHARE THE LOVE, and help us help > > YOU! Click Here: http://sourceforge.net/donate/ > > _______________________________________________ > > Slashcode-general mailing list > > Sla...@li... > > https://lists.sourceforge.net/lists/listinfo/slashcode-general |
From: Shane <sh...@lo...> - 2003-11-03 17:55:08
|
In DBIx::Password's Password.pm, don't put "%" as the host. Put the real hostname in. On Nov 3, 2003, at 11:43 AM, Harold Martin wrote: > The value I got from mysql (and used in Password.pm) is '%' > I continued with the slash install and eventually got this error: > ./bin/install-slashsite -u slash > DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > line 47 > Major Mojo Bad things > unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > Database % unsupported! (virtual user: slash) at > /usr/lib/perl5/site_perl/5.8.0/i686-linux/Slash/DB.pm line 44. > > Thanks for the help, > Harold > On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: >> Harold, >> >> Please do this: >> >> connect to your mysql's 'mysql' database >> >> mysql -u root -p mysql >> >> select Host from user where User = 'slash'; >> >> whichever hosts appear from that select, ensure that DBIx::Password >> has >> the correct values: >> >> locate Password.pm >> >> on my box: >> >> [root@krsna root]# locate Password.pm >> /usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm >> >> edit this... >> >> my $virtual1 = { >> 'slash' => { >> 'driver' => 'mysql', >> 'username' => 'slash', >> 'attributes' => {}, >> 'port' => '', >> 'database' => 'slash', >> 'password' => 'yourpass', >> 'host' => 'EDITTHISVALUEHAROLD', >> 'connect' => >> 'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' >> } >> }; >> >> make sure host is set to the value of the 'Host' column had for the >> slash user in the 'mysql' database. (Note: When you install >> DBIx::Password, it should have already asked you what to choose for >> the >> host value). >> >> Hope this helps, >> >> regards, >> >> Patrick >> >> Harold Martin wrote: >>> Here's some info from the mysql db (sorry the formatting ges messed >>> up): >>> SELECT * FROM db; >>> +------+---------+------+-------------+-------------+------------- >>> +-------------+-------------+-----------+------------ >>> +-----------------+------------+------------+----------------------- >>> +------------------+ >>> | Host | Db | User | Select_priv | Insert_priv | Update_priv | >>> Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv >>> | >>> Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | >>> +------+---------+------+-------------+-------------+------------- >>> +-------------+-------------+-----------+------------ >>> +-----------------+------------+------------+----------------------- >>> +------------------+ >>> | % | test | | Y | Y | Y | >>> Y | Y | Y | N | Y >>> | >>> Y | Y | Y | Y | >>> | % | test\_% | | Y | Y | Y | >>> Y | Y | Y | N | Y >>> | >>> Y | Y | Y | Y | >>> +------+---------+------+-------------+-------------+------------- >>> +-------------+-------------+-----------+------------ >>> +-----------------+------------+------------+----------------------- >>> +------------------+ >>> SELECT * FROM tables_priv; >>> +------+-------+-------+------------+---------------- >>> +---------------- >>> +---------------------------------------------------------------- >>> +-------------+ >>> | Host | Db | User | Table_name | Grantor | Timestamp >>> | >>> Table_priv | >>> Column_priv | >>> +------+-------+-------+------------+---------------- >>> +---------------- >>> +---------------------------------------------------------------- >>> +-------------+ >>> | % | slash | slash | localhost | root@localhost | >>> 20031102180006 | >>> Select,Insert,Update,Delete,Create,Drop,References,Index,Alter >>> | | >>> +------+-------+-------+------------+---------------- >>> +---------------- >>> +---------------------------------------------------------------- >>> +-------------+ >>> SELECT * FROM user WHERE User='slash'; >>> +------+-------+------------------+-------------+------------- >>> +-------------+-------------+-------------+-----------+------------- >>> +---------------+--------------+-----------+------------ >>> +-----------------+------------+------------+-------------- >>> +------------+-----------------------+------------------ >>> +--------------+-----------------+------------------+---------- >>> +------------+-------------+--------------+--------------- >>> +-------------+-----------------+ >>> | Host | User | Password | Select_priv | Insert_priv | >>> Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | >>> Shutdown_priv | Process_priv | File_priv | Grant_priv | >>> References_priv >>> | Index_priv | Alter_priv | Show_db_priv | Super_priv | >>> Create_tmp_table_priv | Lock_tables_priv | Execute_priv | >>> Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | >>> x509_issuer >>> | x509_subject | max_questions | max_updates | max_connections | >>> +------+-------+------------------+-------------+------------- >>> +-------------+-------------+-------------+-----------+------------- >>> +---------------+--------------+-----------+------------ >>> +-----------------+------------+------------+-------------- >>> +------------+-----------------------+------------------ >>> +--------------+-----------------+------------------+---------- >>> +------------+-------------+--------------+--------------- >>> +-------------+-----------------+ >>> | % | slash | nice try ;-) | N | N | N >>> | N | N | N | N | N >>> | >>> N | N | N | N | N | N >>> | >>> N | N | N | N >>> | >>> N | N | N | >>> | | | | 0 | 0 >>> | 0 | >>> +------+-------+------------------+-------------+------------- >>> +-------------+-------------+-------------+-----------+------------- >>> +---------------+--------------+-----------+------------ >>> +-----------------+------------+------------+-------------- >>> +------------+-----------------------+------------------ >>> +--------------+-----------------+------------------+---------- >>> +------------+-------------+--------------+--------------- >>> +-------------+-----------------+ >>> >>> TIA, >>> Harold >>> >>> On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: >>> >>>> On Mon, 3 Nov 2003, Shane wrote: >>>> >>>> >>>>> Check what host is defined, in mysql, that that user can login as. >>>>> >>>>> Shane >>>>> >>>>> >>>> >>>> I think I'd see a complaint from mysql about an illegal >>>> connection if there as a problem. But I checked and the user is in >>>> mysql.user and the mysql.db table allows access to the database for >>>> it. >>>> >>>> -------------------------------------------------------------------- >>>> ----------- >>>> Chris Johnson |Internet: jo...@nm... >>>> Systems Administrator |Web: >>>> http://www.nmr.mgh.harvard.edu/~johnson >>>> NMR Center |Voice: 617.726.0949 >>>> Mass. General Hospital |FAX: 617.726.7422 >>>> 149 (2301) 13th Street |Survival, all by it self, isn't worth >>>> it. >>>> Charlestown, MA., 02129 USA | Me >>>> -------------------------------------------------------------------- >>>> ----------- >>>> >>> >>> >>> >>> >>> ------------------------------------------------------- >>> This SF.net email is sponsored by: SF.net Giveback Program. >>> Does SourceForge.net help you be more productive? Does it >>> help you create better code? SHARE THE LOVE, and help us help >>> YOU! Click Here: http://sourceforge.net/donate/ >>> _______________________________________________ >>> Slashcode-general mailing list >>> Sla...@li... >>> https://lists.sourceforge.net/lists/listinfo/slashcode-general > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general > |
From: Harold M. <coc...@ea...> - 2003-11-03 17:54:01
|
Sorry to cause so much noise on the list. I had accidently set the driver instead of the host to '%'. However, when I fixed this, I get the error: ./bin/install-slashsite -u slash DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 Major Mojo Bad things unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 Major Mojo Bad things unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 Can't bless non-reference value at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. I tried changing the host to 'localhost', but I get: ./bin/install-slashsite -u slash DBI connect('database=slash;host=localhost','slash',...) failed: Access denied for user: 'slash@localhost' (Using password: YES) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 Major Mojo Bad things unable to connect to MySQL: : Access denied for user: 'slash@localhost' (Using password: YES) DBI connect('database=slash;host=localhost','slash',...) failed: Access denied for user: 'slash@localhost' (Using password: YES) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 Major Mojo Bad things unable to connect to MySQL: : Access denied for user: 'slash@localhost' (Using password: YES) DBI connect('database=slash;host=localhost','slash',...) failed: Access denied for user: 'slash@localhost' (Using password: YES) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 Can't bless non-reference value at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. Thanks again for all your help, Harold On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: > Harold, > > Please do this: > > connect to your mysql's 'mysql' database > > mysql -u root -p mysql > > select Host from user where User = 'slash'; > > whichever hosts appear from that select, ensure that DBIx::Password has > the correct values: > > locate Password.pm > > on my box: > > [root@krsna root]# locate Password.pm > /usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm > > edit this... > > my $virtual1 = { > 'slash' => { > 'driver' => 'mysql', > 'username' => 'slash', > 'attributes' => {}, > 'port' => '', > 'database' => 'slash', > 'password' => 'yourpass', > 'host' => 'EDITTHISVALUEHAROLD', > 'connect' => > 'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' > } > }; > > make sure host is set to the value of the 'Host' column had for the > slash user in the 'mysql' database. (Note: When you install > DBIx::Password, it should have already asked you what to choose for the > host value). > > Hope this helps, > > regards, > > Patrick > > Harold Martin wrote: > > Here's some info from the mysql db (sorry the formatting ges messed up): > > SELECT * FROM db; > > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > > | Host | Db | User | Select_priv | Insert_priv | Update_priv | > > Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | > > Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | > > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > > | % | test | | Y | Y | Y | > > Y | Y | Y | N | Y | > > Y | Y | Y | Y | > > | % | test\_% | | Y | Y | Y | > > Y | Y | Y | N | Y | > > Y | Y | Y | Y | > > +------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > > SELECT * FROM tables_priv; > > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > > | Host | Db | User | Table_name | Grantor | Timestamp | > > Table_priv | > > Column_priv | > > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > > | % | slash | slash | localhost | root@localhost | 20031102180006 | > > Select,Insert,Update,Delete,Create,Drop,References,Index,Alter > > | | > > +------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > > SELECT * FROM user WHERE User='slash'; > > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > | Host | User | Password | Select_priv | Insert_priv | > > Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | > > Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv > > | Index_priv | Alter_priv | Show_db_priv | Super_priv | > > Create_tmp_table_priv | Lock_tables_priv | Execute_priv | > > Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer > > | x509_subject | max_questions | max_updates | max_connections | > > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > | % | slash | nice try ;-) | N | N | N > > | N | N | N | N | N | > > N | N | N | N | N | N | > > N | N | N | N | > > N | N | N | > > | | | | 0 | 0 > > | 0 | > > +------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > > > > TIA, > > Harold > > > > On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: > > > >>On Mon, 3 Nov 2003, Shane wrote: > >> > >> > >>>Check what host is defined, in mysql, that that user can login as. > >>> > >>> Shane > >>> > >>> > >> > >> I think I'd see a complaint from mysql about an illegal > >>connection if there as a problem. But I checked and the user is in > >>mysql.user and the mysql.db table allows access to the database for > >>it. > >> > >>------------------------------------------------------------------------------- > >>Chris Johnson |Internet: jo...@nm... > >>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson > >>NMR Center |Voice: 617.726.0949 > >>Mass. General Hospital |FAX: 617.726.7422 > >>149 (2301) 13th Street |Survival, all by it self, isn't worth it. > >>Charlestown, MA., 02129 USA | Me > >>------------------------------------------------------------------------------- > >> > > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SF.net Giveback Program. > > Does SourceForge.net help you be more productive? Does it > > help you create better code? SHARE THE LOVE, and help us help > > YOU! Click Here: http://sourceforge.net/donate/ > > _______________________________________________ > > Slashcode-general mailing list > > Sla...@li... > > https://lists.sourceforge.net/lists/listinfo/slashcode-general |
From: Patrick G. <pa...@pa...> - 2003-11-03 18:35:10
|
Harold, you do not want '%' as the host!!! This will allow any host to connect to your db as slash! Do this to fix this: (when I say YOURHOSTNAME..., I mean whatever is the hostname of your box, or better yet, the IP address) UPDATE user SET Host = 'YOURHOSTNAMEORIPADDRESS' WHERE User = 'slash'; FLUSH PRIVILEGES; Then, whatever value you set 'Host' to in the db, make that the same value in Password.pm. ALSO: Please read up on mysql security on mysql's website http://www.mysql.com/documentation/index.html (in the documentation) and make sure _none_ of your users have a host of '%' ! good luck, Patrick Harold Martin wrote: > Sorry to cause so much noise on the list. > I had accidently set the driver instead of the host to '%'. > However, when I fixed this, I get the error: > ./bin/install-slashsite -u slash > DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > line 47 > Major Mojo Bad things > unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > line 47 > Major Mojo Bad things > unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > line 31 > Can't bless non-reference value at > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > I tried changing the host to 'localhost', but I get: > ./bin/install-slashsite -u slash > DBI connect('database=slash;host=localhost','slash',...) failed: Access > denied for user: 'slash@localhost' (Using password: YES) at > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > Major Mojo Bad things > unable to connect to MySQL: : Access denied for user: 'slash@localhost' > (Using password: YES) > DBI connect('database=slash;host=localhost','slash',...) failed: Access > denied for user: 'slash@localhost' (Using password: YES) at > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > Major Mojo Bad things > unable to connect to MySQL: : Access denied for user: 'slash@localhost' > (Using password: YES) > DBI connect('database=slash;host=localhost','slash',...) failed: Access > denied for user: 'slash@localhost' (Using password: YES) at > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 > Can't bless non-reference value at > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > > Thanks again for all your help, > Harold > > On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: > >>Harold, >> >>Please do this: >> >>connect to your mysql's 'mysql' database >> >>mysql -u root -p mysql >> >>select Host from user where User = 'slash'; >> >>whichever hosts appear from that select, ensure that DBIx::Password has >>the correct values: >> >>locate Password.pm >> >>on my box: >> >>[root@krsna root]# locate Password.pm >>/usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm >> >>edit this... >> >>my $virtual1 = { >> 'slash' => { >> 'driver' => 'mysql', >> 'username' => 'slash', >> 'attributes' => {}, >> 'port' => '', >> 'database' => 'slash', >> 'password' => 'yourpass', >> 'host' => 'EDITTHISVALUEHAROLD', >> 'connect' => >>'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' >> } >> }; >> >>make sure host is set to the value of the 'Host' column had for the >>slash user in the 'mysql' database. (Note: When you install >>DBIx::Password, it should have already asked you what to choose for the >>host value). >> >>Hope this helps, >> >>regards, >> >>Patrick >> >>Harold Martin wrote: >> >>>Here's some info from the mysql db (sorry the formatting ges messed up): >>>SELECT * FROM db; >>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ >>>| Host | Db | User | Select_priv | Insert_priv | Update_priv | >>>Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | >>>Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | >>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ >>>| % | test | | Y | Y | Y | >>>Y | Y | Y | N | Y | >>>Y | Y | Y | Y | >>>| % | test\_% | | Y | Y | Y | >>>Y | Y | Y | N | Y | >>>Y | Y | Y | Y | >>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ >>>SELECT * FROM tables_priv; >>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ >>>| Host | Db | User | Table_name | Grantor | Timestamp | >>>Table_priv | >>>Column_priv | >>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ >>>| % | slash | slash | localhost | root@localhost | 20031102180006 | >>>Select,Insert,Update,Delete,Create,Drop,References,Index,Alter >>>| | >>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ >>>SELECT * FROM user WHERE User='slash'; >>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ >>>| Host | User | Password | Select_priv | Insert_priv | >>>Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | >>>Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv >>>| Index_priv | Alter_priv | Show_db_priv | Super_priv | >>>Create_tmp_table_priv | Lock_tables_priv | Execute_priv | >>>Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer >>>| x509_subject | max_questions | max_updates | max_connections | >>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ >>>| % | slash | nice try ;-) | N | N | N >>>| N | N | N | N | N | >>>N | N | N | N | N | N | >>>N | N | N | N | >>>N | N | N | >>>| | | | 0 | 0 >>>| 0 | >>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ >>> >>>TIA, >>>Harold >>> >>>On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: >>> >>> >>>>On Mon, 3 Nov 2003, Shane wrote: >>>> >>>> >>>> >>>>>Check what host is defined, in mysql, that that user can login as. >>>>> >>>>> Shane >>>>> >>>>> >>>> >>>> I think I'd see a complaint from mysql about an illegal >>>>connection if there as a problem. But I checked and the user is in >>>>mysql.user and the mysql.db table allows access to the database for >>>>it. >>>> >>>>------------------------------------------------------------------------------- >>>>Chris Johnson |Internet: jo...@nm... >>>>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson >>>>NMR Center |Voice: 617.726.0949 >>>>Mass. General Hospital |FAX: 617.726.7422 >>>>149 (2301) 13th Street |Survival, all by it self, isn't worth it. >>>>Charlestown, MA., 02129 USA | Me >>>>------------------------------------------------------------------------------- >>>> >>> >>> >>> >>> >>>------------------------------------------------------- >>>This SF.net email is sponsored by: SF.net Giveback Program. >>>Does SourceForge.net help you be more productive? Does it >>>help you create better code? SHARE THE LOVE, and help us help >>>YOU! Click Here: http://sourceforge.net/donate/ >>>_______________________________________________ >>>Slashcode-general mailing list >>>Sla...@li... >>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general -- ---------------------- Patrick Galbraith Senior Software Developer pa...@se... pa...@pa... cap...@sl... |
From: Harold M. <coc...@ea...> - 2003-11-03 19:00:37
|
I modified Host in the user table to gentoo (my hostname) and did the same for both fields in Pawssword.pm. I get this error, tho: # ./bin/install-slashsite -u slash DBI connect('database=slash;host=gentoo','slash',...) failed: Access denied for user: 'slash@localhost' (Using password: YES) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 Major Mojo Bad things unable to connect to MySQL: : Access denied for user: 'slash@localhost' (Using password: YES) DBI connect('database=slash;host=gentoo','slash',...) failed: Access denied for user: 'slash@localhost' (Using password: YES) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 Major Mojo Bad things unable to connect to MySQL: : Access denied for user: 'slash@localhost' (Using password: YES) DBI connect('database=slash;host=gentoo','slash',...) failed: Access denied for user: 'slash@localhost' (Using password: YES) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 Can't bless non-reference value at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. My user table looks a bit odd (to me, at least): > select User, Host from user; +-------+-----------+ | User | Host | +-------+-----------+ | | gentoo | | root | gentoo | | slash | gentoo | | | localhost | | root | localhost | +-------+-----------+ Thanks for your help, Harold On Mon, 2003-11-03 at 12:31, Patrick Galbraith wrote: > Harold, you do not want '%' as the host!!! This will allow any host to > connect to your db as slash! > > Do this to fix this: > > (when I say YOURHOSTNAME..., I mean whatever is the hostname of your > box, or better yet, the IP address) > > UPDATE user SET Host = 'YOURHOSTNAMEORIPADDRESS' WHERE User = 'slash'; > > FLUSH PRIVILEGES; > > Then, whatever value you set 'Host' to in the db, make that the same > value in Password.pm. > > ALSO: Please read up on mysql security on mysql's website > > http://www.mysql.com/documentation/index.html > > (in the documentation) and make sure _none_ of your users have a host > of '%' ! > > good luck, > > Patrick > > Harold Martin wrote: > > Sorry to cause so much noise on the list. > > I had accidently set the driver instead of the host to '%'. > > However, when I fixed this, I get the error: > > ./bin/install-slashsite -u slash > > DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > > Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > > line 47 > > Major Mojo Bad things > > unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > > DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > > Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > > line 47 > > Major Mojo Bad things > > unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > > DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > > Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > > line 31 > > Can't bless non-reference value at > > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > > I tried changing the host to 'localhost', but I get: > > ./bin/install-slashsite -u slash > > DBI connect('database=slash;host=localhost','slash',...) failed: Access > > denied for user: 'slash@localhost' (Using password: YES) at > > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > > Major Mojo Bad things > > unable to connect to MySQL: : Access denied for user: 'slash@localhost' > > (Using password: YES) > > DBI connect('database=slash;host=localhost','slash',...) failed: Access > > denied for user: 'slash@localhost' (Using password: YES) at > > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > > Major Mojo Bad things > > unable to connect to MySQL: : Access denied for user: 'slash@localhost' > > (Using password: YES) > > DBI connect('database=slash;host=localhost','slash',...) failed: Access > > denied for user: 'slash@localhost' (Using password: YES) at > > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 > > Can't bless non-reference value at > > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > > > > Thanks again for all your help, > > Harold > > > > On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: > > > >>Harold, > >> > >>Please do this: > >> > >>connect to your mysql's 'mysql' database > >> > >>mysql -u root -p mysql > >> > >>select Host from user where User = 'slash'; > >> > >>whichever hosts appear from that select, ensure that DBIx::Password has > >>the correct values: > >> > >>locate Password.pm > >> > >>on my box: > >> > >>[root@krsna root]# locate Password.pm > >>/usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm > >> > >>edit this... > >> > >>my $virtual1 = { > >> 'slash' => { > >> 'driver' => 'mysql', > >> 'username' => 'slash', > >> 'attributes' => {}, > >> 'port' => '', > >> 'database' => 'slash', > >> 'password' => 'yourpass', > >> 'host' => 'EDITTHISVALUEHAROLD', > >> 'connect' => > >>'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' > >> } > >> }; > >> > >>make sure host is set to the value of the 'Host' column had for the > >>slash user in the 'mysql' database. (Note: When you install > >>DBIx::Password, it should have already asked you what to choose for the > >>host value). > >> > >>Hope this helps, > >> > >>regards, > >> > >>Patrick > >> > >>Harold Martin wrote: > >> > >>>Here's some info from the mysql db (sorry the formatting ges messed up): > >>>SELECT * FROM db; > >>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>| Host | Db | User | Select_priv | Insert_priv | Update_priv | > >>>Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | > >>>Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | > >>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>| % | test | | Y | Y | Y | > >>>Y | Y | Y | N | Y | > >>>Y | Y | Y | Y | > >>>| % | test\_% | | Y | Y | Y | > >>>Y | Y | Y | N | Y | > >>>Y | Y | Y | Y | > >>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>SELECT * FROM tables_priv; > >>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>| Host | Db | User | Table_name | Grantor | Timestamp | > >>>Table_priv | > >>>Column_priv | > >>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>| % | slash | slash | localhost | root@localhost | 20031102180006 | > >>>Select,Insert,Update,Delete,Create,Drop,References,Index,Alter > >>>| | > >>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>SELECT * FROM user WHERE User='slash'; > >>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>| Host | User | Password | Select_priv | Insert_priv | > >>>Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | > >>>Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv > >>>| Index_priv | Alter_priv | Show_db_priv | Super_priv | > >>>Create_tmp_table_priv | Lock_tables_priv | Execute_priv | > >>>Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer > >>>| x509_subject | max_questions | max_updates | max_connections | > >>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>| % | slash | nice try ;-) | N | N | N > >>>| N | N | N | N | N | > >>>N | N | N | N | N | N | > >>>N | N | N | N | > >>>N | N | N | > >>>| | | | 0 | 0 > >>>| 0 | > >>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>> > >>>TIA, > >>>Harold > >>> > >>>On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: > >>> > >>> > >>>>On Mon, 3 Nov 2003, Shane wrote: > >>>> > >>>> > >>>> > >>>>>Check what host is defined, in mysql, that that user can login as. > >>>>> > >>>>> Shane > >>>>> > >>>>> > >>>> > >>>> I think I'd see a complaint from mysql about an illegal > >>>>connection if there as a problem. But I checked and the user is in > >>>>mysql.user and the mysql.db table allows access to the database for > >>>>it. > >>>> > >>>>------------------------------------------------------------------------------- > >>>>Chris Johnson |Internet: jo...@nm... > >>>>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson > >>>>NMR Center |Voice: 617.726.0949 > >>>>Mass. General Hospital |FAX: 617.726.7422 > >>>>149 (2301) 13th Street |Survival, all by it self, isn't worth it. > >>>>Charlestown, MA., 02129 USA | Me > >>>>------------------------------------------------------------------------------- > >>>> > >>> > >>> > >>> > >>> > >>>------------------------------------------------------- > >>>This SF.net email is sponsored by: SF.net Giveback Program. > >>>Does SourceForge.net help you be more productive? Does it > >>>help you create better code? SHARE THE LOVE, and help us help > >>>YOU! Click Here: http://sourceforge.net/donate/ > >>>_______________________________________________ > >>>Slashcode-general mailing list > >>>Sla...@li... > >>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SF.net Giveback Program. > > Does SourceForge.net help you be more productive? Does it > > help you create better code? SHARE THE LOVE, and help us help > > YOU! Click Here: http://sourceforge.net/donate/ > > _______________________________________________ > > Slashcode-general mailing list > > Sla...@li... > > https://lists.sourceforge.net/lists/listinfo/slashcode-general |
From: Patrick G. <pa...@pa...> - 2003-11-03 19:13:02
|
1. Did you do a flush privileges? 2. Try to connect: "mysql -h gentoo -uslash -p slash Can you connect this way? Harold Martin wrote: > I modified Host in the user table to gentoo (my hostname) and did the > same for both fields in Pawssword.pm. I get this error, tho: > # ./bin/install-slashsite -u slash > DBI connect('database=slash;host=gentoo','slash',...) failed: Access > denied for user: 'slash@localhost' (Using password: YES) at > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > Major Mojo Bad things > unable to connect to MySQL: : Access denied for user: 'slash@localhost' > (Using password: YES) > DBI connect('database=slash;host=gentoo','slash',...) failed: Access > denied for user: 'slash@localhost' (Using password: YES) at > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > Major Mojo Bad things > unable to connect to MySQL: : Access denied for user: 'slash@localhost' > (Using password: YES) > DBI connect('database=slash;host=gentoo','slash',...) failed: Access > denied for user: 'slash@localhost' (Using password: YES) at > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 > Can't bless non-reference value at > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > > > My user table looks a bit odd (to me, at least): > >>select User, Host from user; > > +-------+-----------+ > | User | Host | > +-------+-----------+ > | | gentoo | > | root | gentoo | > | slash | gentoo | > | | localhost | > | root | localhost | > +-------+-----------+ > > > Thanks for your help, > Harold > > On Mon, 2003-11-03 at 12:31, Patrick Galbraith wrote: > >>Harold, you do not want '%' as the host!!! This will allow any host to >>connect to your db as slash! >> >>Do this to fix this: >> >>(when I say YOURHOSTNAME..., I mean whatever is the hostname of your >>box, or better yet, the IP address) >> >>UPDATE user SET Host = 'YOURHOSTNAMEORIPADDRESS' WHERE User = 'slash'; >> >>FLUSH PRIVILEGES; >> >>Then, whatever value you set 'Host' to in the db, make that the same >>value in Password.pm. >> >>ALSO: Please read up on mysql security on mysql's website >> >>http://www.mysql.com/documentation/index.html >> >> (in the documentation) and make sure _none_ of your users have a host >>of '%' ! >> >>good luck, >> >>Patrick >> >>Harold Martin wrote: >> >>>Sorry to cause so much noise on the list. >>>I had accidently set the driver instead of the host to '%'. >>>However, when I fixed this, I get the error: >>>./bin/install-slashsite -u slash >>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL >>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm >>>line 47 >>>Major Mojo Bad things >>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) >>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL >>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm >>>line 47 >>>Major Mojo Bad things >>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) >>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL >>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm >>>line 31 >>>Can't bless non-reference value at >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. >>>I tried changing the host to 'localhost', but I get: >>>./bin/install-slashsite -u slash >>>DBI connect('database=slash;host=localhost','slash',...) failed: Access >>>denied for user: 'slash@localhost' (Using password: YES) at >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 >>>Major Mojo Bad things >>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' >>>(Using password: YES) >>>DBI connect('database=slash;host=localhost','slash',...) failed: Access >>>denied for user: 'slash@localhost' (Using password: YES) at >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 >>>Major Mojo Bad things >>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' >>>(Using password: YES) >>>DBI connect('database=slash;host=localhost','slash',...) failed: Access >>>denied for user: 'slash@localhost' (Using password: YES) at >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 >>>Can't bless non-reference value at >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. >>> >>>Thanks again for all your help, >>>Harold >>> >>>On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: >>> >>> >>>>Harold, >>>> >>>>Please do this: >>>> >>>>connect to your mysql's 'mysql' database >>>> >>>>mysql -u root -p mysql >>>> >>>>select Host from user where User = 'slash'; >>>> >>>>whichever hosts appear from that select, ensure that DBIx::Password has >>>>the correct values: >>>> >>>>locate Password.pm >>>> >>>>on my box: >>>> >>>>[root@krsna root]# locate Password.pm >>>>/usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm >>>> >>>>edit this... >>>> >>>>my $virtual1 = { >>>> 'slash' => { >>>> 'driver' => 'mysql', >>>> 'username' => 'slash', >>>> 'attributes' => {}, >>>> 'port' => '', >>>> 'database' => 'slash', >>>> 'password' => 'yourpass', >>>> 'host' => 'EDITTHISVALUEHAROLD', >>>> 'connect' => >>>>'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' >>>> } >>>> }; >>>> >>>>make sure host is set to the value of the 'Host' column had for the >>>>slash user in the 'mysql' database. (Note: When you install >>>>DBIx::Password, it should have already asked you what to choose for the >>>>host value). >>>> >>>>Hope this helps, >>>> >>>>regards, >>>> >>>>Patrick >>>> >>>>Harold Martin wrote: >>>> >>>> >>>>>Here's some info from the mysql db (sorry the formatting ges messed up): >>>>>SELECT * FROM db; >>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ >>>>>| Host | Db | User | Select_priv | Insert_priv | Update_priv | >>>>>Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | >>>>>Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | >>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ >>>>>| % | test | | Y | Y | Y | >>>>>Y | Y | Y | N | Y | >>>>>Y | Y | Y | Y | >>>>>| % | test\_% | | Y | Y | Y | >>>>>Y | Y | Y | N | Y | >>>>>Y | Y | Y | Y | >>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ >>>>>SELECT * FROM tables_priv; >>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ >>>>>| Host | Db | User | Table_name | Grantor | Timestamp | >>>>>Table_priv | >>>>>Column_priv | >>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ >>>>>| % | slash | slash | localhost | root@localhost | 20031102180006 | >>>>>Select,Insert,Update,Delete,Create,Drop,References,Index,Alter >>>>>| | >>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ >>>>>SELECT * FROM user WHERE User='slash'; >>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ >>>>>| Host | User | Password | Select_priv | Insert_priv | >>>>>Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | >>>>>Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv >>>>>| Index_priv | Alter_priv | Show_db_priv | Super_priv | >>>>>Create_tmp_table_priv | Lock_tables_priv | Execute_priv | >>>>>Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer >>>>>| x509_subject | max_questions | max_updates | max_connections | >>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ >>>>>| % | slash | nice try ;-) | N | N | N >>>>>| N | N | N | N | N | >>>>>N | N | N | N | N | N | >>>>>N | N | N | N | >>>>>N | N | N | >>>>>| | | | 0 | 0 >>>>>| 0 | >>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ >>>>> >>>>>TIA, >>>>>Harold >>>>> >>>>>On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: >>>>> >>>>> >>>>> >>>>>>On Mon, 3 Nov 2003, Shane wrote: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>>Check what host is defined, in mysql, that that user can login as. >>>>>>> >>>>>>>Shane >>>>>>> >>>>>>> >>>>>> >>>>>> I think I'd see a complaint from mysql about an illegal >>>>>>connection if there as a problem. But I checked and the user is in >>>>>>mysql.user and the mysql.db table allows access to the database for >>>>>>it. >>>>>> >>>>>>------------------------------------------------------------------------------- >>>>>>Chris Johnson |Internet: jo...@nm... >>>>>>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson >>>>>>NMR Center |Voice: 617.726.0949 >>>>>>Mass. General Hospital |FAX: 617.726.7422 >>>>>>149 (2301) 13th Street |Survival, all by it self, isn't worth it. >>>>>>Charlestown, MA., 02129 USA | Me >>>>>>------------------------------------------------------------------------------- >>>>>> >>>>> >>>>> >>>>> >>>>> >>>>>------------------------------------------------------- >>>>>This SF.net email is sponsored by: SF.net Giveback Program. >>>>>Does SourceForge.net help you be more productive? Does it >>>>>help you create better code? SHARE THE LOVE, and help us help >>>>>YOU! Click Here: http://sourceforge.net/donate/ >>>>>_______________________________________________ >>>>>Slashcode-general mailing list >>>>>Sla...@li... >>>>>https://lists.sourceforge.net/lists/listinfo/slashcode-general >>> >>> >>> >>> >>>------------------------------------------------------- >>>This SF.net email is sponsored by: SF.net Giveback Program. >>>Does SourceForge.net help you be more productive? Does it >>>help you create better code? SHARE THE LOVE, and help us help >>>YOU! Click Here: http://sourceforge.net/donate/ >>>_______________________________________________ >>>Slashcode-general mailing list >>>Sla...@li... >>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > > -- ---------------------- Patrick Galbraith Senior Software Developer pa...@se... pa...@pa... cap...@sl... |
From: Harold M. <coc...@ea...> - 2003-11-03 19:29:04
|
Yes, I flushed privileges. No, I can't connect via "mysql -h gentoo -uslash -p slash", I get the error: ERROR 1045: Access denied for user: 'slash@localhost' (Using password: YES) Thanks, Harold On Mon, 2003-11-03 at 13:09, Patrick Galbraith wrote: > 1. Did you do a flush privileges? > 2. Try to connect: "mysql -h gentoo -uslash -p slash > > Can you connect this way? > > > > Harold Martin wrote: > > I modified Host in the user table to gentoo (my hostname) and did the > > same for both fields in Pawssword.pm. I get this error, tho: > > # ./bin/install-slashsite -u slash > > DBI connect('database=slash;host=gentoo','slash',...) failed: Access > > denied for user: 'slash@localhost' (Using password: YES) at > > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > > Major Mojo Bad things > > unable to connect to MySQL: : Access denied for user: 'slash@localhost' > > (Using password: YES) > > DBI connect('database=slash;host=gentoo','slash',...) failed: Access > > denied for user: 'slash@localhost' (Using password: YES) at > > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > > Major Mojo Bad things > > unable to connect to MySQL: : Access denied for user: 'slash@localhost' > > (Using password: YES) > > DBI connect('database=slash;host=gentoo','slash',...) failed: Access > > denied for user: 'slash@localhost' (Using password: YES) at > > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 > > Can't bless non-reference value at > > /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > > > > > > My user table looks a bit odd (to me, at least): > > > >>select User, Host from user; > > > > +-------+-----------+ > > | User | Host | > > +-------+-----------+ > > | | gentoo | > > | root | gentoo | > > | slash | gentoo | > > | | localhost | > > | root | localhost | > > +-------+-----------+ > > > > > > Thanks for your help, > > Harold > > > > On Mon, 2003-11-03 at 12:31, Patrick Galbraith wrote: > > > >>Harold, you do not want '%' as the host!!! This will allow any host to > >>connect to your db as slash! > >> > >>Do this to fix this: > >> > >>(when I say YOURHOSTNAME..., I mean whatever is the hostname of your > >>box, or better yet, the IP address) > >> > >>UPDATE user SET Host = 'YOURHOSTNAMEORIPADDRESS' WHERE User = 'slash'; > >> > >>FLUSH PRIVILEGES; > >> > >>Then, whatever value you set 'Host' to in the db, make that the same > >>value in Password.pm. > >> > >>ALSO: Please read up on mysql security on mysql's website > >> > >>http://www.mysql.com/documentation/index.html > >> > >> (in the documentation) and make sure _none_ of your users have a host > >>of '%' ! > >> > >>good luck, > >> > >>Patrick > >> > >>Harold Martin wrote: > >> > >>>Sorry to cause so much noise on the list. > >>>I had accidently set the driver instead of the host to '%'. > >>>However, when I fixed this, I get the error: > >>>./bin/install-slashsite -u slash > >>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > >>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > >>>line 47 > >>>Major Mojo Bad things > >>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > >>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > >>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > >>>line 47 > >>>Major Mojo Bad things > >>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > >>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > >>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > >>>line 31 > >>>Can't bless non-reference value at > >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > >>>I tried changing the host to 'localhost', but I get: > >>>./bin/install-slashsite -u slash > >>>DBI connect('database=slash;host=localhost','slash',...) failed: Access > >>>denied for user: 'slash@localhost' (Using password: YES) at > >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>Major Mojo Bad things > >>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>(Using password: YES) > >>>DBI connect('database=slash;host=localhost','slash',...) failed: Access > >>>denied for user: 'slash@localhost' (Using password: YES) at > >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>Major Mojo Bad things > >>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>(Using password: YES) > >>>DBI connect('database=slash;host=localhost','slash',...) failed: Access > >>>denied for user: 'slash@localhost' (Using password: YES) at > >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 > >>>Can't bless non-reference value at > >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > >>> > >>>Thanks again for all your help, > >>>Harold > >>> > >>>On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: > >>> > >>> > >>>>Harold, > >>>> > >>>>Please do this: > >>>> > >>>>connect to your mysql's 'mysql' database > >>>> > >>>>mysql -u root -p mysql > >>>> > >>>>select Host from user where User = 'slash'; > >>>> > >>>>whichever hosts appear from that select, ensure that DBIx::Password has > >>>>the correct values: > >>>> > >>>>locate Password.pm > >>>> > >>>>on my box: > >>>> > >>>>[root@krsna root]# locate Password.pm > >>>>/usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm > >>>> > >>>>edit this... > >>>> > >>>>my $virtual1 = { > >>>> 'slash' => { > >>>> 'driver' => 'mysql', > >>>> 'username' => 'slash', > >>>> 'attributes' => {}, > >>>> 'port' => '', > >>>> 'database' => 'slash', > >>>> 'password' => 'yourpass', > >>>> 'host' => 'EDITTHISVALUEHAROLD', > >>>> 'connect' => > >>>>'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' > >>>> } > >>>> }; > >>>> > >>>>make sure host is set to the value of the 'Host' column had for the > >>>>slash user in the 'mysql' database. (Note: When you install > >>>>DBIx::Password, it should have already asked you what to choose for the > >>>>host value). > >>>> > >>>>Hope this helps, > >>>> > >>>>regards, > >>>> > >>>>Patrick > >>>> > >>>>Harold Martin wrote: > >>>> > >>>> > >>>>>Here's some info from the mysql db (sorry the formatting ges messed up): > >>>>>SELECT * FROM db; > >>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>>>| Host | Db | User | Select_priv | Insert_priv | Update_priv | > >>>>>Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | > >>>>>Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | > >>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>>>| % | test | | Y | Y | Y | > >>>>>Y | Y | Y | N | Y | > >>>>>Y | Y | Y | Y | > >>>>>| % | test\_% | | Y | Y | Y | > >>>>>Y | Y | Y | N | Y | > >>>>>Y | Y | Y | Y | > >>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>>>SELECT * FROM tables_priv; > >>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>>>| Host | Db | User | Table_name | Grantor | Timestamp | > >>>>>Table_priv | > >>>>>Column_priv | > >>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>>>| % | slash | slash | localhost | root@localhost | 20031102180006 | > >>>>>Select,Insert,Update,Delete,Create,Drop,References,Index,Alter > >>>>>| | > >>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>>>SELECT * FROM user WHERE User='slash'; > >>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>>>| Host | User | Password | Select_priv | Insert_priv | > >>>>>Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | > >>>>>Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv > >>>>>| Index_priv | Alter_priv | Show_db_priv | Super_priv | > >>>>>Create_tmp_table_priv | Lock_tables_priv | Execute_priv | > >>>>>Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer > >>>>>| x509_subject | max_questions | max_updates | max_connections | > >>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>>>| % | slash | nice try ;-) | N | N | N > >>>>>| N | N | N | N | N | > >>>>>N | N | N | N | N | N | > >>>>>N | N | N | N | > >>>>>N | N | N | > >>>>>| | | | 0 | 0 > >>>>>| 0 | > >>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>>> > >>>>>TIA, > >>>>>Harold > >>>>> > >>>>>On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: > >>>>> > >>>>> > >>>>> > >>>>>>On Mon, 3 Nov 2003, Shane wrote: > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>>Check what host is defined, in mysql, that that user can login as. > >>>>>>> > >>>>>>>Shane > >>>>>>> > >>>>>>> > >>>>>> > >>>>>> I think I'd see a complaint from mysql about an illegal > >>>>>>connection if there as a problem. But I checked and the user is in > >>>>>>mysql.user and the mysql.db table allows access to the database for > >>>>>>it. > >>>>>> > >>>>>>------------------------------------------------------------------------------- > >>>>>>Chris Johnson |Internet: jo...@nm... > >>>>>>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson > >>>>>>NMR Center |Voice: 617.726.0949 > >>>>>>Mass. General Hospital |FAX: 617.726.7422 > >>>>>>149 (2301) 13th Street |Survival, all by it self, isn't worth it. > >>>>>>Charlestown, MA., 02129 USA | Me > >>>>>>------------------------------------------------------------------------------- > >>>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>>------------------------------------------------------- > >>>>>This SF.net email is sponsored by: SF.net Giveback Program. > >>>>>Does SourceForge.net help you be more productive? Does it > >>>>>help you create better code? SHARE THE LOVE, and help us help > >>>>>YOU! Click Here: http://sourceforge.net/donate/ > >>>>>_______________________________________________ > >>>>>Slashcode-general mailing list > >>>>>Sla...@li... > >>>>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > >>> > >>> > >>> > >>> > >>>------------------------------------------------------- > >>>This SF.net email is sponsored by: SF.net Giveback Program. > >>>Does SourceForge.net help you be more productive? Does it > >>>help you create better code? SHARE THE LOVE, and help us help > >>>YOU! Click Here: http://sourceforge.net/donate/ > >>>_______________________________________________ > >>>Slashcode-general mailing list > >>>Sla...@li... > >>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > > > > |
From: Patrick G. <pa...@pa...> - 2003-11-03 19:43:45
|
Just use the IP address of 'gentoo'. I think that perhaps 'gentoo' isn't in your hosts file, or DNS... what if you ping 'gentoo' ? Harold Martin wrote: > Yes, I flushed privileges. > No, I can't connect via "mysql -h gentoo -uslash -p slash", I get the > error: > ERROR 1045: Access denied for user: 'slash@localhost' (Using password: > YES) > > Thanks, > Harold > > On Mon, 2003-11-03 at 13:09, Patrick Galbraith wrote: > >>1. Did you do a flush privileges? >>2. Try to connect: "mysql -h gentoo -uslash -p slash >> >>Can you connect this way? >> >> >> >>Harold Martin wrote: >> >>>I modified Host in the user table to gentoo (my hostname) and did the >>>same for both fields in Pawssword.pm. I get this error, tho: >>># ./bin/install-slashsite -u slash >>>DBI connect('database=slash;host=gentoo','slash',...) failed: Access >>>denied for user: 'slash@localhost' (Using password: YES) at >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 >>>Major Mojo Bad things >>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' >>>(Using password: YES) >>>DBI connect('database=slash;host=gentoo','slash',...) failed: Access >>>denied for user: 'slash@localhost' (Using password: YES) at >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 >>>Major Mojo Bad things >>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' >>>(Using password: YES) >>>DBI connect('database=slash;host=gentoo','slash',...) failed: Access >>>denied for user: 'slash@localhost' (Using password: YES) at >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 >>>Can't bless non-reference value at >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. >>> >>> >>>My user table looks a bit odd (to me, at least): >>> >>> >>>>select User, Host from user; >>> >>>+-------+-----------+ >>>| User | Host | >>>+-------+-----------+ >>>| | gentoo | >>>| root | gentoo | >>>| slash | gentoo | >>>| | localhost | >>>| root | localhost | >>>+-------+-----------+ >>> >>> >>>Thanks for your help, >>>Harold >>> >>>On Mon, 2003-11-03 at 12:31, Patrick Galbraith wrote: >>> >>> >>>>Harold, you do not want '%' as the host!!! This will allow any host to >>>>connect to your db as slash! >>>> >>>>Do this to fix this: >>>> >>>>(when I say YOURHOSTNAME..., I mean whatever is the hostname of your >>>>box, or better yet, the IP address) >>>> >>>>UPDATE user SET Host = 'YOURHOSTNAMEORIPADDRESS' WHERE User = 'slash'; >>>> >>>>FLUSH PRIVILEGES; >>>> >>>>Then, whatever value you set 'Host' to in the db, make that the same >>>>value in Password.pm. >>>> >>>>ALSO: Please read up on mysql security on mysql's website >>>> >>>>http://www.mysql.com/documentation/index.html >>>> >>>> (in the documentation) and make sure _none_ of your users have a host >>>>of '%' ! >>>> >>>>good luck, >>>> >>>>Patrick >>>> >>>>Harold Martin wrote: >>>> >>>> >>>>>Sorry to cause so much noise on the list. >>>>>I had accidently set the driver instead of the host to '%'. >>>>>However, when I fixed this, I get the error: >>>>>./bin/install-slashsite -u slash >>>>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL >>>>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm >>>>>line 47 >>>>>Major Mojo Bad things >>>>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) >>>>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL >>>>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm >>>>>line 47 >>>>>Major Mojo Bad things >>>>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) >>>>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL >>>>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm >>>>>line 31 >>>>>Can't bless non-reference value at >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. >>>>>I tried changing the host to 'localhost', but I get: >>>>>./bin/install-slashsite -u slash >>>>>DBI connect('database=slash;host=localhost','slash',...) failed: Access >>>>>denied for user: 'slash@localhost' (Using password: YES) at >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 >>>>>Major Mojo Bad things >>>>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' >>>>>(Using password: YES) >>>>>DBI connect('database=slash;host=localhost','slash',...) failed: Access >>>>>denied for user: 'slash@localhost' (Using password: YES) at >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 >>>>>Major Mojo Bad things >>>>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' >>>>>(Using password: YES) >>>>>DBI connect('database=slash;host=localhost','slash',...) failed: Access >>>>>denied for user: 'slash@localhost' (Using password: YES) at >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 >>>>>Can't bless non-reference value at >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. >>>>> >>>>>Thanks again for all your help, >>>>>Harold >>>>> >>>>>On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: >>>>> >>>>> >>>>> >>>>>>Harold, >>>>>> >>>>>>Please do this: >>>>>> >>>>>>connect to your mysql's 'mysql' database >>>>>> >>>>>>mysql -u root -p mysql >>>>>> >>>>>>select Host from user where User = 'slash'; >>>>>> >>>>>>whichever hosts appear from that select, ensure that DBIx::Password has >>>>>>the correct values: >>>>>> >>>>>>locate Password.pm >>>>>> >>>>>>on my box: >>>>>> >>>>>>[root@krsna root]# locate Password.pm >>>>>>/usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm >>>>>> >>>>>>edit this... >>>>>> >>>>>>my $virtual1 = { >>>>>> 'slash' => { >>>>>> 'driver' => 'mysql', >>>>>> 'username' => 'slash', >>>>>> 'attributes' => {}, >>>>>> 'port' => '', >>>>>> 'database' => 'slash', >>>>>> 'password' => 'yourpass', >>>>>> 'host' => 'EDITTHISVALUEHAROLD', >>>>>> 'connect' => >>>>>>'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' >>>>>> } >>>>>> }; >>>>>> >>>>>>make sure host is set to the value of the 'Host' column had for the >>>>>>slash user in the 'mysql' database. (Note: When you install >>>>>>DBIx::Password, it should have already asked you what to choose for the >>>>>>host value). >>>>>> >>>>>>Hope this helps, >>>>>> >>>>>>regards, >>>>>> >>>>>>Patrick >>>>>> >>>>>>Harold Martin wrote: >>>>>> >>>>>> >>>>>> >>>>>>>Here's some info from the mysql db (sorry the formatting ges messed up): >>>>>>>SELECT * FROM db; >>>>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ >>>>>>>| Host | Db | User | Select_priv | Insert_priv | Update_priv | >>>>>>>Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | >>>>>>>Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | >>>>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ >>>>>>>| % | test | | Y | Y | Y | >>>>>>>Y | Y | Y | N | Y | >>>>>>>Y | Y | Y | Y | >>>>>>>| % | test\_% | | Y | Y | Y | >>>>>>>Y | Y | Y | N | Y | >>>>>>>Y | Y | Y | Y | >>>>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ >>>>>>>SELECT * FROM tables_priv; >>>>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ >>>>>>>| Host | Db | User | Table_name | Grantor | Timestamp | >>>>>>>Table_priv | >>>>>>>Column_priv | >>>>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ >>>>>>>| % | slash | slash | localhost | root@localhost | 20031102180006 | >>>>>>>Select,Insert,Update,Delete,Create,Drop,References,Index,Alter >>>>>>>| | >>>>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ >>>>>>>SELECT * FROM user WHERE User='slash'; >>>>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ >>>>>>>| Host | User | Password | Select_priv | Insert_priv | >>>>>>>Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | >>>>>>>Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv >>>>>>>| Index_priv | Alter_priv | Show_db_priv | Super_priv | >>>>>>>Create_tmp_table_priv | Lock_tables_priv | Execute_priv | >>>>>>>Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer >>>>>>>| x509_subject | max_questions | max_updates | max_connections | >>>>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ >>>>>>>| % | slash | nice try ;-) | N | N | N >>>>>>>| N | N | N | N | N | >>>>>>>N | N | N | N | N | N | >>>>>>>N | N | N | N | >>>>>>>N | N | N | >>>>>>>| | | | 0 | 0 >>>>>>>| 0 | >>>>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ >>>>>>> >>>>>>>TIA, >>>>>>>Harold >>>>>>> >>>>>>>On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>>>On Mon, 3 Nov 2003, Shane wrote: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>>Check what host is defined, in mysql, that that user can login as. >>>>>>>>> >>>>>>>>>Shane >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> I think I'd see a complaint from mysql about an illegal >>>>>>>>connection if there as a problem. But I checked and the user is in >>>>>>>>mysql.user and the mysql.db table allows access to the database for >>>>>>>>it. >>>>>>>> >>>>>>>>------------------------------------------------------------------------------- >>>>>>>>Chris Johnson |Internet: jo...@nm... >>>>>>>>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson >>>>>>>>NMR Center |Voice: 617.726.0949 >>>>>>>>Mass. General Hospital |FAX: 617.726.7422 >>>>>>>>149 (2301) 13th Street |Survival, all by it self, isn't worth it. >>>>>>>>Charlestown, MA., 02129 USA | Me >>>>>>>>------------------------------------------------------------------------------- >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>>------------------------------------------------------- >>>>>>>This SF.net email is sponsored by: SF.net Giveback Program. >>>>>>>Does SourceForge.net help you be more productive? Does it >>>>>>>help you create better code? SHARE THE LOVE, and help us help >>>>>>>YOU! Click Here: http://sourceforge.net/donate/ >>>>>>>_______________________________________________ >>>>>>>Slashcode-general mailing list >>>>>>>Sla...@li... >>>>>>>https://lists.sourceforge.net/lists/listinfo/slashcode-general >>>>> >>>>> >>>>> >>>>> >>>>>------------------------------------------------------- >>>>>This SF.net email is sponsored by: SF.net Giveback Program. >>>>>Does SourceForge.net help you be more productive? Does it >>>>>help you create better code? SHARE THE LOVE, and help us help >>>>>YOU! Click Here: http://sourceforge.net/donate/ >>>>>_______________________________________________ >>>>>Slashcode-general mailing list >>>>>Sla...@li... >>>>>https://lists.sourceforge.net/lists/listinfo/slashcode-general >>> >>> > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general -- ---------------------- Patrick Galbraith Senior Software Developer pa...@se... pa...@pa... cap...@sl... |
From: Harold M. <coc...@ea...> - 2003-11-03 21:46:02
|
John: running 'mysqladmin reload' didn't change anything. I think flushing the privileges is all that should need to be done. I can ping, nmap (to check if the mysql port is open), etc. gentoo. I'm able to do login fine if I use root, so I don't think it's a host issue. On the permissions table I sent you, is it normal for there to be many empty user fields? Thanks, Harold On Mon, 2003-11-03 at 13:40, Patrick Galbraith wrote: > Just use the IP address of 'gentoo'. I think that perhaps 'gentoo' isn't > in your hosts file, or DNS... what if you ping 'gentoo' ? > > > > Harold Martin wrote: > > Yes, I flushed privileges. > > No, I can't connect via "mysql -h gentoo -uslash -p slash", I get the > > error: > > ERROR 1045: Access denied for user: 'slash@localhost' (Using password: > > YES) > > > > Thanks, > > Harold > > > > On Mon, 2003-11-03 at 13:09, Patrick Galbraith wrote: > > > >>1. Did you do a flush privileges? > >>2. Try to connect: "mysql -h gentoo -uslash -p slash > >> > >>Can you connect this way? > >> > >> > >> > >>Harold Martin wrote: > >> > >>>I modified Host in the user table to gentoo (my hostname) and did the > >>>same for both fields in Pawssword.pm. I get this error, tho: > >>># ./bin/install-slashsite -u slash > >>>DBI connect('database=slash;host=gentoo','slash',...) failed: Access > >>>denied for user: 'slash@localhost' (Using password: YES) at > >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>Major Mojo Bad things > >>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>(Using password: YES) > >>>DBI connect('database=slash;host=gentoo','slash',...) failed: Access > >>>denied for user: 'slash@localhost' (Using password: YES) at > >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>Major Mojo Bad things > >>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>(Using password: YES) > >>>DBI connect('database=slash;host=gentoo','slash',...) failed: Access > >>>denied for user: 'slash@localhost' (Using password: YES) at > >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 > >>>Can't bless non-reference value at > >>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > >>> > >>> > >>>My user table looks a bit odd (to me, at least): > >>> > >>> > >>>>select User, Host from user; > >>> > >>>+-------+-----------+ > >>>| User | Host | > >>>+-------+-----------+ > >>>| | gentoo | > >>>| root | gentoo | > >>>| slash | gentoo | > >>>| | localhost | > >>>| root | localhost | > >>>+-------+-----------+ > >>> > >>> > >>>Thanks for your help, > >>>Harold > >>> > >>>On Mon, 2003-11-03 at 12:31, Patrick Galbraith wrote: > >>> > >>> > >>>>Harold, you do not want '%' as the host!!! This will allow any host to > >>>>connect to your db as slash! > >>>> > >>>>Do this to fix this: > >>>> > >>>>(when I say YOURHOSTNAME..., I mean whatever is the hostname of your > >>>>box, or better yet, the IP address) > >>>> > >>>>UPDATE user SET Host = 'YOURHOSTNAMEORIPADDRESS' WHERE User = 'slash'; > >>>> > >>>>FLUSH PRIVILEGES; > >>>> > >>>>Then, whatever value you set 'Host' to in the db, make that the same > >>>>value in Password.pm. > >>>> > >>>>ALSO: Please read up on mysql security on mysql's website > >>>> > >>>>http://www.mysql.com/documentation/index.html > >>>> > >>>> (in the documentation) and make sure _none_ of your users have a host > >>>>of '%' ! > >>>> > >>>>good luck, > >>>> > >>>>Patrick > >>>> > >>>>Harold Martin wrote: > >>>> > >>>> > >>>>>Sorry to cause so much noise on the list. > >>>>>I had accidently set the driver instead of the host to '%'. > >>>>>However, when I fixed this, I get the error: > >>>>>./bin/install-slashsite -u slash > >>>>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > >>>>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > >>>>>line 47 > >>>>>Major Mojo Bad things > >>>>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > >>>>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > >>>>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > >>>>>line 47 > >>>>>Major Mojo Bad things > >>>>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > >>>>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > >>>>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > >>>>>line 31 > >>>>>Can't bless non-reference value at > >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > >>>>>I tried changing the host to 'localhost', but I get: > >>>>>./bin/install-slashsite -u slash > >>>>>DBI connect('database=slash;host=localhost','slash',...) failed: Access > >>>>>denied for user: 'slash@localhost' (Using password: YES) at > >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>>>Major Mojo Bad things > >>>>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>>>(Using password: YES) > >>>>>DBI connect('database=slash;host=localhost','slash',...) failed: Access > >>>>>denied for user: 'slash@localhost' (Using password: YES) at > >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>>>Major Mojo Bad things > >>>>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>>>(Using password: YES) > >>>>>DBI connect('database=slash;host=localhost','slash',...) failed: Access > >>>>>denied for user: 'slash@localhost' (Using password: YES) at > >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 > >>>>>Can't bless non-reference value at > >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > >>>>> > >>>>>Thanks again for all your help, > >>>>>Harold > >>>>> > >>>>>On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: > >>>>> > >>>>> > >>>>> > >>>>>>Harold, > >>>>>> > >>>>>>Please do this: > >>>>>> > >>>>>>connect to your mysql's 'mysql' database > >>>>>> > >>>>>>mysql -u root -p mysql > >>>>>> > >>>>>>select Host from user where User = 'slash'; > >>>>>> > >>>>>>whichever hosts appear from that select, ensure that DBIx::Password has > >>>>>>the correct values: > >>>>>> > >>>>>>locate Password.pm > >>>>>> > >>>>>>on my box: > >>>>>> > >>>>>>[root@krsna root]# locate Password.pm > >>>>>>/usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm > >>>>>> > >>>>>>edit this... > >>>>>> > >>>>>>my $virtual1 = { > >>>>>> 'slash' => { > >>>>>> 'driver' => 'mysql', > >>>>>> 'username' => 'slash', > >>>>>> 'attributes' => {}, > >>>>>> 'port' => '', > >>>>>> 'database' => 'slash', > >>>>>> 'password' => 'yourpass', > >>>>>> 'host' => 'EDITTHISVALUEHAROLD', > >>>>>> 'connect' => > >>>>>>'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' > >>>>>> } > >>>>>> }; > >>>>>> > >>>>>>make sure host is set to the value of the 'Host' column had for the > >>>>>>slash user in the 'mysql' database. (Note: When you install > >>>>>>DBIx::Password, it should have already asked you what to choose for the > >>>>>>host value). > >>>>>> > >>>>>>Hope this helps, > >>>>>> > >>>>>>regards, > >>>>>> > >>>>>>Patrick > >>>>>> > >>>>>>Harold Martin wrote: > >>>>>> > >>>>>> > >>>>>> > >>>>>>>Here's some info from the mysql db (sorry the formatting ges messed up): > >>>>>>>SELECT * FROM db; > >>>>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>>>>>| Host | Db | User | Select_priv | Insert_priv | Update_priv | > >>>>>>>Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | > >>>>>>>Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | > >>>>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>>>>>| % | test | | Y | Y | Y | > >>>>>>>Y | Y | Y | N | Y | > >>>>>>>Y | Y | Y | Y | > >>>>>>>| % | test\_% | | Y | Y | Y | > >>>>>>>Y | Y | Y | N | Y | > >>>>>>>Y | Y | Y | Y | > >>>>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>>>>>SELECT * FROM tables_priv; > >>>>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>>>>>| Host | Db | User | Table_name | Grantor | Timestamp | > >>>>>>>Table_priv | > >>>>>>>Column_priv | > >>>>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>>>>>| % | slash | slash | localhost | root@localhost | 20031102180006 | > >>>>>>>Select,Insert,Update,Delete,Create,Drop,References,Index,Alter > >>>>>>>| | > >>>>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>>>>>SELECT * FROM user WHERE User='slash'; > >>>>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>>>>>| Host | User | Password | Select_priv | Insert_priv | > >>>>>>>Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | > >>>>>>>Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv > >>>>>>>| Index_priv | Alter_priv | Show_db_priv | Super_priv | > >>>>>>>Create_tmp_table_priv | Lock_tables_priv | Execute_priv | > >>>>>>>Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer > >>>>>>>| x509_subject | max_questions | max_updates | max_connections | > >>>>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>>>>>| % | slash | nice try ;-) | N | N | N > >>>>>>>| N | N | N | N | N | > >>>>>>>N | N | N | N | N | N | > >>>>>>>N | N | N | N | > >>>>>>>N | N | N | > >>>>>>>| | | | 0 | 0 > >>>>>>>| 0 | > >>>>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>>>>> > >>>>>>>TIA, > >>>>>>>Harold > >>>>>>> > >>>>>>>On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>>On Mon, 3 Nov 2003, Shane wrote: > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>>>Check what host is defined, in mysql, that that user can login as. > >>>>>>>>> > >>>>>>>>>Shane > >>>>>>>>> > >>>>>>>>> > >>>>>>>> > >>>>>>>> I think I'd see a complaint from mysql about an illegal > >>>>>>>>connection if there as a problem. But I checked and the user is in > >>>>>>>>mysql.user and the mysql.db table allows access to the database for > >>>>>>>>it. > >>>>>>>> > >>>>>>>>------------------------------------------------------------------------------- > >>>>>>>>Chris Johnson |Internet: jo...@nm... > >>>>>>>>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson > >>>>>>>>NMR Center |Voice: 617.726.0949 > >>>>>>>>Mass. General Hospital |FAX: 617.726.7422 > >>>>>>>>149 (2301) 13th Street |Survival, all by it self, isn't worth it. > >>>>>>>>Charlestown, MA., 02129 USA | Me > >>>>>>>>------------------------------------------------------------------------------- > >>>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>------------------------------------------------------- > >>>>>>>This SF.net email is sponsored by: SF.net Giveback Program. > >>>>>>>Does SourceForge.net help you be more productive? Does it > >>>>>>>help you create better code? SHARE THE LOVE, and help us help > >>>>>>>YOU! Click Here: http://sourceforge.net/donate/ > >>>>>>>_______________________________________________ > >>>>>>>Slashcode-general mailing list > >>>>>>>Sla...@li... > >>>>>>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > >>>>> > >>>>> > >>>>> > >>>>> > >>>>>------------------------------------------------------- > >>>>>This SF.net email is sponsored by: SF.net Giveback Program. > >>>>>Does SourceForge.net help you be more productive? Does it > >>>>>help you create better code? SHARE THE LOVE, and help us help > >>>>>YOU! Click Here: http://sourceforge.net/donate/ > >>>>>_______________________________________________ > >>>>>Slashcode-general mailing list > >>>>>Sla...@li... > >>>>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > >>> > >>> > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SF.net Giveback Program. > > Does SourceForge.net help you be more productive? Does it > > help you create better code? SHARE THE LOVE, and help us help > > YOU! Click Here: http://sourceforge.net/donate/ > > _______________________________________________ > > Slashcode-general mailing list > > Sla...@li... > > https://lists.sourceforge.net/lists/listinfo/slashcode-general |
From: Harold M. <coc...@ea...> - 2003-11-03 22:09:50
|
Password.pm my $virtual1 = { 'slash' => { 'database' => 'slash', 'password' => '.....', 'attributes' => {}, 'port' => '', 'username' => 'slash', 'host' => 'gentoo', 'driver' => 'mysql', 'connect' => 'DBI:mysql:database=slash;host=gentoo' } }; > select User, Host,password from user WHERE User='slash'; +-------+--------+------------------+ | User | Host | password | +-------+--------+------------------+ | slash | gentoo | ................ | +-------+--------+------------------+ Thanks, Harold On Mon, 2003-11-03 at 15:50, Patrick Galbraith wrote: > Harold, > > Yes, those are normal records. They're for connecting locally. I would > however make sure that the password value for those is set. > > What do you have in Password.pm currently? It seems to me that the error > is that slash is still using 'localhost' as the host value. > > Patrick > > Harold Martin wrote: > > John: running 'mysqladmin reload' didn't change anything. I think > > flushing the privileges is all that should need to be done. > > I can ping, nmap (to check if the mysql port is open), etc. gentoo. > > I'm able to do login fine if I use root, so I don't think it's a host > > issue. > > On the permissions table I sent you, is it normal for there to be many > > empty user fields? > > > > Thanks, > > Harold > > > > > > On Mon, 2003-11-03 at 13:40, Patrick Galbraith wrote: > > > >>Just use the IP address of 'gentoo'. I think that perhaps 'gentoo' isn't > >>in your hosts file, or DNS... what if you ping 'gentoo' ? > >> > >> > >> > >>Harold Martin wrote: > >> > >>>Yes, I flushed privileges. > >>>No, I can't connect via "mysql -h gentoo -uslash -p slash", I get the > >>>error: > >>>ERROR 1045: Access denied for user: 'slash@localhost' (Using password: > >>>YES) > >>> > >>>Thanks, > >>>Harold > >>> > >>>On Mon, 2003-11-03 at 13:09, Patrick Galbraith wrote: > >>> > >>> > >>>>1. Did you do a flush privileges? > >>>>2. Try to connect: "mysql -h gentoo -uslash -p slash > >>>> > >>>>Can you connect this way? > >>>> > >>>> > >>>> > >>>>Harold Martin wrote: > >>>> > >>>> > >>>>>I modified Host in the user table to gentoo (my hostname) and did the > >>>>>same for both fields in Pawssword.pm. I get this error, tho: > >>>>># ./bin/install-slashsite -u slash > >>>>>DBI connect('database=slash;host=gentoo','slash',...) failed: Access > >>>>>denied for user: 'slash@localhost' (Using password: YES) at > >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>>>Major Mojo Bad things > >>>>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>>>(Using password: YES) > >>>>>DBI connect('database=slash;host=gentoo','slash',...) failed: Access > >>>>>denied for user: 'slash@localhost' (Using password: YES) at > >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>>>Major Mojo Bad things > >>>>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>>>(Using password: YES) > >>>>>DBI connect('database=slash;host=gentoo','slash',...) failed: Access > >>>>>denied for user: 'slash@localhost' (Using password: YES) at > >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 > >>>>>Can't bless non-reference value at > >>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > >>>>> > >>>>> > >>>>>My user table looks a bit odd (to me, at least): > >>>>> > >>>>> > >>>>> > >>>>>>select User, Host from user; > >>>>> > >>>>>+-------+-----------+ > >>>>>| User | Host | > >>>>>+-------+-----------+ > >>>>>| | gentoo | > >>>>>| root | gentoo | > >>>>>| slash | gentoo | > >>>>>| | localhost | > >>>>>| root | localhost | > >>>>>+-------+-----------+ > >>>>> > >>>>> > >>>>>Thanks for your help, > >>>>>Harold > >>>>> > >>>>>On Mon, 2003-11-03 at 12:31, Patrick Galbraith wrote: > >>>>> > >>>>> > >>>>> > >>>>>>Harold, you do not want '%' as the host!!! This will allow any host to > >>>>>>connect to your db as slash! > >>>>>> > >>>>>>Do this to fix this: > >>>>>> > >>>>>>(when I say YOURHOSTNAME..., I mean whatever is the hostname of your > >>>>>>box, or better yet, the IP address) > >>>>>> > >>>>>>UPDATE user SET Host = 'YOURHOSTNAMEORIPADDRESS' WHERE User = 'slash'; > >>>>>> > >>>>>>FLUSH PRIVILEGES; > >>>>>> > >>>>>>Then, whatever value you set 'Host' to in the db, make that the same > >>>>>>value in Password.pm. > >>>>>> > >>>>>>ALSO: Please read up on mysql security on mysql's website > >>>>>> > >>>>>>http://www.mysql.com/documentation/index.html > >>>>>> > >>>>>>(in the documentation) and make sure _none_ of your users have a host > >>>>>>of '%' ! > >>>>>> > >>>>>>good luck, > >>>>>> > >>>>>>Patrick > >>>>>> > >>>>>>Harold Martin wrote: > >>>>>> > >>>>>> > >>>>>> > >>>>>>>Sorry to cause so much noise on the list. > >>>>>>>I had accidently set the driver instead of the host to '%'. > >>>>>>>However, when I fixed this, I get the error: > >>>>>>>./bin/install-slashsite -u slash > >>>>>>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > >>>>>>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > >>>>>>>line 47 > >>>>>>>Major Mojo Bad things > >>>>>>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > >>>>>>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > >>>>>>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > >>>>>>>line 47 > >>>>>>>Major Mojo Bad things > >>>>>>>unable to connect to MySQL: : Unknown MySQL Server Host '%' (1) > >>>>>>>DBI connect('database=slash;host=%','slash',...) failed: Unknown MySQL > >>>>>>>Server Host '%' (1) at /usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm > >>>>>>>line 31 > >>>>>>>Can't bless non-reference value at > >>>>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > >>>>>>>I tried changing the host to 'localhost', but I get: > >>>>>>>./bin/install-slashsite -u slash > >>>>>>>DBI connect('database=slash;host=localhost','slash',...) failed: Access > >>>>>>>denied for user: 'slash@localhost' (Using password: YES) at > >>>>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>>>>>Major Mojo Bad things > >>>>>>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>>>>>(Using password: YES) > >>>>>>>DBI connect('database=slash;host=localhost','slash',...) failed: Access > >>>>>>>denied for user: 'slash@localhost' (Using password: YES) at > >>>>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 47 > >>>>>>>Major Mojo Bad things > >>>>>>>unable to connect to MySQL: : Access denied for user: 'slash@localhost' > >>>>>>>(Using password: YES) > >>>>>>>DBI connect('database=slash;host=localhost','slash',...) failed: Access > >>>>>>>denied for user: 'slash@localhost' (Using password: YES) at > >>>>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 31 > >>>>>>>Can't bless non-reference value at > >>>>>>>/usr/lib/perl5/site_perl/5.8.0/DBIx/Password.pm line 36. > >>>>>>> > >>>>>>>Thanks again for all your help, > >>>>>>>Harold > >>>>>>> > >>>>>>>On Mon, 2003-11-03 at 10:59, Patrick Galbraith wrote: > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>>Harold, > >>>>>>>> > >>>>>>>>Please do this: > >>>>>>>> > >>>>>>>>connect to your mysql's 'mysql' database > >>>>>>>> > >>>>>>>>mysql -u root -p mysql > >>>>>>>> > >>>>>>>>select Host from user where User = 'slash'; > >>>>>>>> > >>>>>>>>whichever hosts appear from that select, ensure that DBIx::Password has > >>>>>>>>the correct values: > >>>>>>>> > >>>>>>>>locate Password.pm > >>>>>>>> > >>>>>>>>on my box: > >>>>>>>> > >>>>>>>>[root@krsna root]# locate Password.pm > >>>>>>>>/usr/lib/perl5/site_perl/5.6.1/DBIx/Password.pm > >>>>>>>> > >>>>>>>>edit this... > >>>>>>>> > >>>>>>>>my $virtual1 = { > >>>>>>>> 'slash' => { > >>>>>>>> 'driver' => 'mysql', > >>>>>>>> 'username' => 'slash', > >>>>>>>> 'attributes' => {}, > >>>>>>>> 'port' => '', > >>>>>>>> 'database' => 'slash', > >>>>>>>> 'password' => 'yourpass', > >>>>>>>> 'host' => 'EDITTHISVALUEHAROLD', > >>>>>>>> 'connect' => > >>>>>>>>'DBI:mysql:database=slash;host=EDITTHISVALUEHAROLD' > >>>>>>>> } > >>>>>>>> }; > >>>>>>>> > >>>>>>>>make sure host is set to the value of the 'Host' column had for the > >>>>>>>>slash user in the 'mysql' database. (Note: When you install > >>>>>>>>DBIx::Password, it should have already asked you what to choose for the > >>>>>>>>host value). > >>>>>>>> > >>>>>>>>Hope this helps, > >>>>>>>> > >>>>>>>>regards, > >>>>>>>> > >>>>>>>>Patrick > >>>>>>>> > >>>>>>>>Harold Martin wrote: > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>>>Here's some info from the mysql db (sorry the formatting ges messed up): > >>>>>>>>>SELECT * FROM db; > >>>>>>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>>>>>>>| Host | Db | User | Select_priv | Insert_priv | Update_priv | > >>>>>>>>>Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | > >>>>>>>>>Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | > >>>>>>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>>>>>>>| % | test | | Y | Y | Y | > >>>>>>>>>Y | Y | Y | N | Y | > >>>>>>>>>Y | Y | Y | Y | > >>>>>>>>>| % | test\_% | | Y | Y | Y | > >>>>>>>>>Y | Y | Y | N | Y | > >>>>>>>>>Y | Y | Y | Y | > >>>>>>>>>+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+ > >>>>>>>>>SELECT * FROM tables_priv; > >>>>>>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>>>>>>>| Host | Db | User | Table_name | Grantor | Timestamp | > >>>>>>>>>Table_priv | > >>>>>>>>>Column_priv | > >>>>>>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>>>>>>>| % | slash | slash | localhost | root@localhost | 20031102180006 | > >>>>>>>>>Select,Insert,Update,Delete,Create,Drop,References,Index,Alter > >>>>>>>>>| | > >>>>>>>>>+------+-------+-------+------------+----------------+----------------+----------------------------------------------------------------+-------------+ > >>>>>>>>>SELECT * FROM user WHERE User='slash'; > >>>>>>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>>>>>>>| Host | User | Password | Select_priv | Insert_priv | > >>>>>>>>>Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | > >>>>>>>>>Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv > >>>>>>>>>| Index_priv | Alter_priv | Show_db_priv | Super_priv | > >>>>>>>>>Create_tmp_table_priv | Lock_tables_priv | Execute_priv | > >>>>>>>>>Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer > >>>>>>>>>| x509_subject | max_questions | max_updates | max_connections | > >>>>>>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>>>>>>>| % | slash | nice try ;-) | N | N | N > >>>>>>>>>| N | N | N | N | N | > >>>>>>>>>N | N | N | N | N | N | > >>>>>>>>>N | N | N | N | > >>>>>>>>>N | N | N | > >>>>>>>>>| | | | 0 | 0 > >>>>>>>>>| 0 | > >>>>>>>>>+------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ > >>>>>>>>> > >>>>>>>>>TIA, > >>>>>>>>>Harold > >>>>>>>>> > >>>>>>>>>On Mon, 2003-11-03 at 05:51, Chris Johnson wrote: > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>>>On Mon, 3 Nov 2003, Shane wrote: > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>>>Check what host is defined, in mysql, that that user can login as. > >>>>>>>>>>> > >>>>>>>>>>>Shane > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> I think I'd see a complaint from mysql about an illegal > >>>>>>>>>>connection if there as a problem. But I checked and the user is in > >>>>>>>>>>mysql.user and the mysql.db table allows access to the database for > >>>>>>>>>>it. > >>>>>>>>>> > >>>>>>>>>>------------------------------------------------------------------------------- > >>>>>>>>>>Chris Johnson |Internet: jo...@nm... > >>>>>>>>>>Systems Administrator |Web: http://www.nmr.mgh.harvard.edu/~johnson > >>>>>>>>>>NMR Center |Voice: 617.726.0949 > >>>>>>>>>>Mass. General Hospital |FAX: 617.726.7422 > >>>>>>>>>>149 (2301) 13th Street |Survival, all by it self, isn't worth it. > >>>>>>>>>>Charlestown, MA., 02129 USA | Me > >>>>>>>>>>------------------------------------------------------------------------------- > >>>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>>------------------------------------------------------- > >>>>>>>>>This SF.net email is sponsored by: SF.net Giveback Program. > >>>>>>>>>Does SourceForge.net help you be more productive? Does it > >>>>>>>>>help you create better code? SHARE THE LOVE, and help us help > >>>>>>>>>YOU! Click Here: http://sourceforge.net/donate/ > >>>>>>>>>_______________________________________________ > >>>>>>>>>Slashcode-general mailing list > >>>>>>>>>Sla...@li... > >>>>>>>>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>------------------------------------------------------- > >>>>>>>This SF.net email is sponsored by: SF.net Giveback Program. > >>>>>>>Does SourceForge.net help you be more productive? Does it > >>>>>>>help you create better code? SHARE THE LOVE, and help us help > >>>>>>>YOU! Click Here: http://sourceforge.net/donate/ > >>>>>>>_______________________________________________ > >>>>>>>Slashcode-general mailing list > >>>>>>>Sla...@li... > >>>>>>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > >>>>> > >>>>> > >>> > >>> > >>>------------------------------------------------------- > >>>This SF.net email is sponsored by: SF.net Giveback Program. > >>>Does SourceForge.net help you be more productive? Does it > >>>help you create better code? SHARE THE LOVE, and help us help > >>>YOU! Click Here: http://sourceforge.net/donate/ > >>>_______________________________________________ > >>>Slashcode-general mailing list > >>>Sla...@li... > >>>https://lists.sourceforge.net/lists/listinfo/slashcode-general > > > > |