Re: Perl, MySQl and Airport
On Oct 2, 2006, at 12:46 PM, Joseph Alotta wrote: I am getting this error, having tried all the combinations. Is there a control panel somewhere that I need to set permissions? I already tried things in Sharing. Hosea:/Library/MySQL/bin jja$ /Library/MySQL/bin/mysql -u root -D names -h Yeshua.local ERROR 1130: Host '10.0.1.4' is not allowed to connect to this MySQL server Hosea:/Library/MySQL/bin jja$ I've intentionally kept this brief, because it's off-topic for this list, having nothing at all to do with Perl on Mac OS X. You need to log in to MySQL as root (obviously, from a host where you're allowed to do that), and use the 'grant' SQL command to allow root to log in from '10.0.1.4'. Details can be found in any book about MySQL administration. sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net
Re: Perl, MySQl and Airport
Hi everyone, Thanks to everyone who helped. The problem was within MySql, I needed to set grants for the other system. The grants syntax is pretty rough, but I finally got it to work on the command line and now I should have no trouble getting it to work in perl. Joe. On Oct 2, 2006, at 2:07 PM, Ray Zimmerman wrote: On Oct 2, 2006, at 2:36 PM, brian d foy wrote: I'm not aware of any Mac OS X particular interface to MySQL permissions table. I think you have to do it through MySQL itself: http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html Actually, MySQL Administrator, which is part of the MySQL GUI Tools [1], does have an interface to the permissions. http://dev.mysql.com/downloads/gui-tools/5.0.html - Ray
Re: Perl, MySQl and Airport
In article [EMAIL PROTECTED], Ray Zimmerman [EMAIL PROTECTED] wrote: On Oct 2, 2006, at 2:36 PM, brian d foy wrote: I'm not aware of any Mac OS X particular interface to MySQL permissions table. I think you have to do it through MySQL itself: http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html Actually, MySQL Administrator, which is part of the MySQL GUI Tools [1], does have an interface to the permissions. I should have been more clear. I was talking about something that's part of Mac OS X (the system) and integrated with the System Preferences. :)
Re: Perl, MySQl and Airport
On Sep 26, 2006, at 12:23 PM, Sherm Pendley wrote: On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote: I have a application in Perl that prints reports from a MySQL database. I also have DSL that is accessed via Airport in my house. Recently I bought an iMac for my wife and I want her to help me print reports from this new computer. How do I get her computer to get data from the MySQL database that lives on my computer via Airport? MySQL client libraries use TCP/IP - they neither know nor care about the physical network layer. So you'd do this the same way you'd connect to any other remote server - just supply the host name (or IP address) as part of the dsn. my $dsn = DBI:mysql:database=foo;host=192.168.1.101; my $dbh = DBI-connect($dsn, $user, $password); If that's not working, some things to check: • Are the MySQL client libs and DBD::mysql installed on the client? • Is $user authorized to connect from another host? • Is MySQL itself configured to allow such connections in general? sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net Hi everyone, I am getting this error, having tried all the combinations. Is there a control panel somewhere that I need to set permissions? I already tried things in Sharing. Hosea:/Library/MySQL/bin jja$ /Library/MySQL/bin/mysql -u root -D names -h Yeshua.local ERROR 1130: Host '10.0.1.4' is not allowed to connect to this MySQL server Hosea:/Library/MySQL/bin jja$ Joe.
RE: Perl, MySQl and Airport
When you access MYSql from another machine, you need to set the access privilege for that account. You can search the net on how to do this. ted -Original Message- From: Joseph Alotta [mailto:[EMAIL PROTECTED] Sent: Monday, October 02, 2006 9:46 AM Cc: Mac OS X Perl Subject: Re: Perl, MySQl and Airport On Sep 26, 2006, at 12:23 PM, Sherm Pendley wrote: On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote: I have a application in Perl that prints reports from a MySQL database. I also have DSL that is accessed via Airport in my house. Recently I bought an iMac for my wife and I want her to help me print reports from this new computer. How do I get her computer to get data from the MySQL database that lives on my computer via Airport? MySQL client libraries use TCP/IP - they neither know nor care about the physical network layer. So you'd do this the same way you'd connect to any other remote server - just supply the host name (or IP address) as part of the dsn. my $dsn = DBI:mysql:database=foo;host=192.168.1.101; my $dbh = DBI-connect($dsn, $user, $password); If that's not working, some things to check: * Are the MySQL client libs and DBD::mysql installed on the client? * Is $user authorized to connect from another host? * Is MySQL itself configured to allow such connections in general? sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net Hi everyone, I am getting this error, having tried all the combinations. Is there a control panel somewhere that I need to set permissions? I already tried things in Sharing. Hosea:/Library/MySQL/bin jja$ /Library/MySQL/bin/mysql -u root -D names -h Yeshua.local ERROR 1130: Host '10.0.1.4' is not allowed to connect to this MySQL server Hosea:/Library/MySQL/bin jja$ Joe.
Re: Perl, MySQl and Airport
In article [EMAIL PROTECTED], Joseph Alotta [EMAIL PROTECTED] wrote: I am getting this error, having tried all the combinations. Is there a control panel somewhere that I need to set permissions? I already tried things in Sharing. Hosea:/Library/MySQL/bin jja$ /Library/MySQL/bin/mysql -u root -D names -h Yeshua.local ERROR 1130: Host '10.0.1.4' is not allowed to connect to this MySQL server Hosea:/Library/MySQL/bin jja$ I'm not aware of any Mac OS X particular interface to MySQL permissions table. I think you have to do it through MySQL itself: http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html Good luck :)
Re: Perl, MySQl and Airport
On Oct 2, 2006, at 2:36 PM, brian d foy wrote: I'm not aware of any Mac OS X particular interface to MySQL permissions table. I think you have to do it through MySQL itself: http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html Actually, MySQL Administrator, which is part of the MySQL GUI Tools [1], does have an interface to the permissions. http://dev.mysql.com/downloads/gui-tools/5.0.html - Ray
Re: Perl, MySQl and Airport
Greetings everyone, This is where I got to on the mySQL. It seems like there is someone on the Mac to set permissions. I tried the Sharing Control Panel. Where else should I try? Hosea:/Library/MySQL/bin jja$ /Library/MySQL/bin/mysql -u root -D names -h Yeshua.local ERROR 1130: Host '10.0.1.4' is not allowed to connect to this MySQL server Hosea:/Library/MySQL/bin jja$ Joe. On Sep 26, 2006, at 12:23 PM, Sherm Pendley wrote: On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote: I have a application in Perl that prints reports from a MySQL database. I also have DSL that is accessed via Airport in my house. Recently I bought an iMac for my wife and I want her to help me print reports from this new computer. How do I get her computer to get data from the MySQL database that lives on my computer via Airport? MySQL client libraries use TCP/IP - they neither know nor care about the physical network layer. So you'd do this the same way you'd connect to any other remote server - just supply the host name (or IP address) as part of the dsn. my $dsn = DBI:mysql:database=foo;host=192.168.1.101; my $dbh = DBI-connect($dsn, $user, $password); If that's not working, some things to check: • Are the MySQL client libs and DBD::mysql installed on the client? • Is $user authorized to connect from another host? • Is MySQL itself configured to allow such connections in general? sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net
Re: Perl, MySQl and Airport
On Sep 26, 2006, at 10:45 AM, Joseph Alotta wrote: Greetings, I have a application in Perl that prints reports from a MySQL database. I also have DSL that is accessed via Airport in my house. Recently I bought an iMac for my wife and I want her to help me print reports from this new computer. How do I get her computer to get data from the MySQL database that lives on my computer via Airport? Do you have any suggestions on things I can try? You're digging in a little too deep, friend. Airport is irrelevant. That's at a whole different level of the TCP/IP stack. Just treat it like it's another Ethernet address. Good Luck. Gregg
Re: Perl, MySQl and Airport
On Sep 27, 2006, at 3:43 AM, brian d foy wrote: In article [EMAIL PROTECTED], Ray Zimmerman [EMAIL PROTECTED] wrote: On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote: $host = 'localhost'; ... to connect to the MySQL database. When run from your wife's computer, you'll have to change the 'localhost' to the IP address Just use the zero-conf Bonjour stuff. Find your server's name and append .local to it. Look in the Sharing control panel for the right name. $host = 'albook.local'; Ouch. Okay, looking around the 'net for zero-conf answers the old nagging question of why my machine refers to itself as something.local when I have a valid dns name set for it. It makes me a little queasy, since .local was supposed to be reserved for a slightly different administrative purpose, but, on the other hand, it kind of makes sense. (Thanks, Wikipedia.) (And the flame war echoing in my head from a certain final call in 2005 on LLMNR might keep me from getting my sleep tonight, too. Lousy M$lop.) It's not just Mac, either. You can get stuff for the various other unices and even Windows to do this. http://www.apple.com/macosx/features/bonjour/
Re: Perl, MySQl and Airport
In article [EMAIL PROTECTED], Joel Rees [EMAIL PROTECTED] wrote: On Sep 27, 2006, at 3:43 AM, brian d foy wrote: In article [EMAIL PROTECTED], Ray Zimmerman [EMAIL PROTECTED] wrote: On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote: ... to connect to the MySQL database. When run from your wife's computer, you'll have to change the 'localhost' to the IP address Just use the zero-conf Bonjour stuff. Find your server's name and append .local to it. Look in the Sharing control panel for the right name. $host = 'albook.local'; Okay, looking around the 'net for zero-conf answers the old nagging question of why my machine refers to itself as something.local when I have a valid dns name set for it. In that case, use the host name you've configured for it. :)
Re: Perl, MySQl and Airport
On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote: I have a application in Perl that prints reports from a MySQL database. I also have DSL that is accessed via Airport in my house. Recently I bought an iMac for my wife and I want her to help me print reports from this new computer. How do I get her computer to get data from the MySQL database that lives on my computer via Airport? Do you have any suggestions on things I can try? Presumably, your Perl app does something like ... $host = 'localhost'; $dsn = DBI:mysql:database=$database;host=$hostname; $dbh = DBI-connect($dsn, $user, $password); ... to connect to the MySQL database. When run from your wife's computer, you'll have to change the 'localhost' to the IP address of the computer where the MySQL database resides. You'll need to make sure your MySQL permissions are set up to allow this. You may want to try connecting to the database using the 'mysql' command line tool first. Once you can do that successfully, then make the appropriate mods to the connection parameters in your app. Ray
Re: Perl, MySQl and Airport
On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote: I have a application in Perl that prints reports from a MySQL database. I also have DSL that is accessed via Airport in my house. Recently I bought an iMac for my wife and I want her to help me print reports from this new computer. How do I get her computer to get data from the MySQL database that lives on my computer via Airport? MySQL client libraries use TCP/IP - they neither know nor care about the physical network layer. So you'd do this the same way you'd connect to any other remote server - just supply the host name (or IP address) as part of the dsn. my $dsn = DBI:mysql:database=foo;host=192.168.1.101; my $dbh = DBI-connect($dsn, $user, $password); If that's not working, some things to check: • Are the MySQL client libs and DBD::mysql installed on the client? • Is $user authorized to connect from another host? • Is MySQL itself configured to allow such connections in general? sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net
Re: Perl, MySQl and Airport
In article [EMAIL PROTECTED], Ray Zimmerman [EMAIL PROTECTED] wrote: On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote: $host = 'localhost'; ... to connect to the MySQL database. When run from your wife's computer, you'll have to change the 'localhost' to the IP address Just use the zero-conf Bonjour stuff. Find your server's name and append .local to it. Look in the Sharing control panel for the right name. $host = 'albook.local'; It's not just Mac, either. You can get stuff for the various other unices and even Windows to do this. http://www.apple.com/macosx/features/bonjour/
