Re: [Hampshire] Which Perl Modules
On Tue, Feb 24, 2009 at 01:46:58AM -0800, Tim Henley wrote: I need to install DataBase interface Perl Modules DBI and DBD::mysql on my Debian Lenny based system but there are several packages with those terms in them and I can't work out which ones are the ones I need. I can download them from Cpan but I would rather pull them from the Debian repo if I can. Could somebody point me in the right direction please Just install libdbd-mysql-perl which should pull in libdbi-perl (it depends on it) and any other bits you need. In Debian the convention is as follows: Foo::Bar - libfoo-bar-perl Simon. -- oOoOo I'm tour guide Barbie! Please keep your hands, arms and oOoOo oOoOoaccessories inside the car and no flash photography,oOoOo oOoOo thank you.oOoOo htag.pl 0.0.24 ::: http://www.earth.li/~huggie/ -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
-Original Message- From: hug...@earth.li Sent: Tue, 24 Feb 2009 09:58:58 + To: hampshire@mailman.lug.org.uk Subject: Re: [Hampshire] Which Perl Modules On Tue, Feb 24, 2009 at 01:46:58AM -0800, Tim Henley wrote: I need to install DataBase interface Perl Modules DBI and DBD::mysql on my Debian Lenny based system but there are several packages with those terms in them and I can't work out which ones are the ones I need. I can download them from Cpan but I would rather pull them from the Debian repo if I can. Could somebody point me in the right direction please Just install libdbd-mysql-perl which should pull in libdbi-perl (it depends on it) and any other bits you need. In Debian the convention is as follows: Foo::Bar - libfoo-bar-perl Simon. -- oOoOo I'm tour guide Barbie! Please keep your hands, arms and oOoOo oOoOoaccessories inside the car and no flash photography,oOoOo oOoOo thank you.oOoOo htag.pl 0.0.24 ::: http://www.earth.li/~huggie/ -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk -- Thanks Simon, just checked and it is already installed. Tim GET FREE SMILEYS FOR YOUR IM EMAIL - Learn more at http://www.inbox.com/smileys Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and most webmails -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
Well, the thread title is wrong now - this is a MySQL question... shell mysql -e GRANT ALL ON mwforum.* TO mwfo...@localhost IDENTIFIED BY 'password' I have named my database msn so I assume mwforum.* should be msn.* Yes. mwfo...@localhost I think should be m...@localhost Could be. In this context, mwforum and msn are MySQL usernames; use whatever will remind you of their function in three years' time... password is the password for mysql database?? It's the password for *that user*. The error I am getting is Error 1045 (28000) Access denied for user 'root'@'localhost' (using passowrd: NO) Try adding -p to your mysql command. Make sure you know the root MySQL password. The stupid thing is I have setup the forum on a test machine and did not have a problem but doing it again on the server is causing me problems. Your test machine probably had no root MySQL password set. Your production machine definitely should... Vic. -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
-Original Message- From: xendis...@inbox.com Sent: Tue, 24 Feb 2009 02:13:44 -0800 To: hampshire@mailman.lug.org.uk Subject: Re: [Hampshire] Which Perl Modules -Original Message- From: hug...@earth.li Sent: Tue, 24 Feb 2009 09:58:58 + To: hampshire@mailman.lug.org.uk Subject: Re: [Hampshire] Which Perl Modules On Tue, Feb 24, 2009 at 01:46:58AM -0800, Tim Henley wrote: I need to install DataBase interface Perl Modules DBI and DBD::mysql on my Debian Lenny based system but there are several packages with those terms in them and I can't work out which ones are the ones I need. I can download them from Cpan but I would rather pull them from the Debian repo if I can. Could somebody point me in the right direction please Just install libdbd-mysql-perl which should pull in libdbi-perl (it depends on it) and any other bits you need. In Debian the convention is as follows: Foo::Bar - libfoo-bar-perl Simon. -- oOoOo I'm tour guide Barbie! Please keep your hands, arms and oOoOo oOoOoaccessories inside the car and no flash photography,oOoOo oOoOo thank you.oOoOo htag.pl 0.0.24 ::: http://www.earth.li/~huggie/ -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk -- Thanks Simon, just checked and it is already installed. Tim GET FREE SMILEYS FOR YOUR IM EMAIL - Learn more at http://www.inbox.com/smileys Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and most webmails -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk -- I have hit a wall, I am trying to install mwforum, I have been following the instructions (http://www.mwforum.org/doc/stable/Install.html) and I am stuck at what I guess is a simple instruction shell mysql -e GRANT ALL ON mwforum.* TO mwfo...@localhost IDENTIFIED BY 'password' The words, mwforum, mwfo...@localhost and password have to be changed a suitable word for my setup, but I am at a loss to workout what I should put in those bits. I am running the command as root I have named my database msn so I assume mwforum.* should be msn.* mwfo...@localhost I think should be m...@localhost password is the password for mysql database?? The error I am getting is Error 1045 (28000) Access denied for user 'root'@'localhost' (using passowrd: NO) The stupid thing is I have setup the forum on a test machine and did not have a problem but doing it again on the server is causing me problems. Could anybody open my eyes for me, there so many trees I can't see the wood Tim -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
In reverse order, yes I do have a password on mysql which I did not before OK still failing, this is what I am typing mysql -e -p GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY 'timssqlpassword' Error 1045 (28000) Access denied for user 'tim'@'localhost' (using password: NO) and the error I get is the same as before I have tried changing the localhost to IP address and the name of the PC but still the same. Am I being really dumb here?? Tim Hiya, try mysql -e -u root -p GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY 'timssqlpassword' Cheers. Steve -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
On Tuesday 24 February 2009 14:16:22 Tim Henley wrote: -Original Message- From: sweseme...@ntlworld.com Sent: Tue, 24 Feb 2009 14:07:28 + To: hampshire@mailman.lug.org.uk Subject: Re: [Hampshire] Which Perl Modules In reverse order, yes I do have a password on mysql which I did not before OK still failing, this is what I am typing mysql -e -p GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY 'timssqlpassword' Error 1045 (28000) Access denied for user 'tim'@'localhost' (using password: NO) and the error I get is the same as before I have tried changing the localhost to IP address and the name of the PC but still the same. Am I being really dumb here?? Tim Hiya, try mysql -e -u root -p GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY 'timssqlpassword' Cheers. Steve Hi Steve All that done was list all the possible commandline options, same as mysql --help Tim FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks orcas on your desktop! Check it out at http://www.inbox.com/marineaquarium You probably have sorted it by now with Vic's last email but alternatively do the following: mysql -u root -p [enter mysql root user password when prompted] You should now be at a mysql prompt mysql GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY 'timssqlpassword'; mysql flush privileges; mysqlquit Cheers, Steve -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --