This is my first post to the list - hi all! I see a number of messages about this in the archives relating to this, but nothing specific on how to get it done. I was hoping someone on the list might have accomplished this relatively smoothly since those messages ... I would like to establish a connection from MacPerl to a MySQL database; I've got MacPerl on an OS 8.6 machine, and then MySQL running on an OS X 10.0.4 machine. I also have a Solaris 2.6 machine that is successfully running a proxy server for Sybase access (MacPerl can use the Sybase databases by proxy OK, so it's got all the necessary modules/extensions). I have tried installing the DBD:MySQL bundle on my Solaris machine, but without a lot of luck. I also tried installing a proxy server on my OS X machine, also without much luck. What I get when I try to connect to MySQL through Solaris proxy is: Got started. # DBI->connect failed: Cannot log in to DBI::ProxyServer: # Refused by server: User crm is not permitted to connect.. File 'BuettnerHD:Programming:MacPerl Ÿ:site_perl:RPC:PlClient.pm'; Line 86 File 'macosx:Users:danb:Desktop:NEW proofserver:proofserver.pl'; Line 1222 # Cannot log in to DBI::ProxyServer: # Refused by server: User crm is not permitted to connect.. File 'BuettnerHD:Programming:MacPerl Ÿ:site_perl:RPC:PlClient.pm'; Line 86 (and I've verified that the "crm" user can connect to MySQL from any host) What I get when trying to connect to MySQL through OS X proxy is: Got started. # DBI->connect failed: Cannot log in to DBI::ProxyServer: # Modification of a read-only value attempted. File 'BuettnerHD:Programming:MacPerl Ÿ:site_perl:auto:Storable:thaw.al'; Line 14, File 'BuettnerHD:Programming:MacPerl Ÿ:site_perl:RPC:PlServer:Comm.pm'; Line 143 File 'macosx:Users:danb:Desktop:NEW proofserver:proofserver.pl'; Line 1222 # Cannot log in to DBI::ProxyServer: # Modification of a read-only value attempted. File 'BuettnerHD:Programming:MacPerl Ÿ:site_perl:auto:Storable:thaw.al'; Line 14, File 'BuettnerHD:Programming:MacPerl Ÿ:site_perl:RPC:PlServer:Comm.pm'; Line 143 Anyone got a MySQL connection right out of MacPerl going, or using a proxy server running on OS X? Any step-by-step guides out there? I've seen the brief guide to establishing a proxy at http://pudge.net/macperl/dbi-dbd-proxy.html, but it's for Sybase, not MySQL, and frankly I just need more detail. TIA, Dan -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | Dan Buettner voice: 515.284.8491 | | Programmer/Analyst fax: 515.284.8558 | | The Des Moines Register Publishing Systems 24/7 pager | | Information Services Dept (for emergencies): 515.234.0505 | | 715 Locust Street e-mail: [EMAIL PROTECTED] | | Des Moines, Iowa 50309 web: http://www.desmoinesregister.com | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
