List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 7 2002 3:21pm
Subject:Re: MySQL and DBI remote access
View as plain text  
At 9:59 -0500 6/7/02, Shawn wrote:
>Geeze...  This message was sent (according to my sentbox) on 5/24/02 
>and just appeared on the list on 6/7/02 (I had given up on it).  I 
>don't know whats up with that...
>
>Next, what I asked for was a way to read the datasources,  NOT 
>connect to mysql.  I want to be able to see all the drivers(Oracle, 
>MSSQL, etc.) in addition to the MySQL, as well as all ther databases 
>(NOT a single one I connect to).  I just used that as an example (my 
>bad). Then I guess I could connect to them in the normal manner 
>(which I don't have an issue with since I CAN pass the username, 
>password, and host). So, the question still stands, is there a way 
>to read the data sources remotely?
>
>I am able to do it fine if I turn off all security, but as I 
>mentioned, there seems to be no way to pass the user name and 
>password, let alone the host.

Right.  data_sources() is essentially pretty useless unless anyone can
connect to your (local) server.  As for MySQL, you do need to connect to the
server in order to get a list of data sources (databases).  It won't just
hand out the list to anyone that asks for it.

>
>TIA,
>Shawn
>
>----- Original Message -----
>From: "Colin Faber" <cfaber@stripped>
>To: "Shawn" <shawn@stripped>
>Cc: "MySql List" <mysql@stripped>
>Sent: Friday, June 07, 2002 4:14 AM
>Subject: Re: MySQL and DBI remote access
>
>
>>  Hi,
>>
>>  Right from the "connect" section in the DBD::mysql manual:
>>
>>                 $dsn =
>>  "DBI:mysql:database=$database;host=$hostname;port=$port";
>>
>>                 $dbh = DBI->connect($dsn, $user, $password);
>>
>>
>>
>>  Shawn wrote:
>>  >
>>  > Hello all,
>>  >   Does anyone know if there is a way to remotely call the 
>>data_source [DBI->data_source('mysql')] property to pull all 
>>available databases/drivers?
>>  >
>>  >   I can't seem to do it since you are not allowed to specify a 
>>host name, user name, or password with it.  The docs mention 
>>nothing about it using the call remotely, but I can't believe that 
>>I am the first to have an issue with it...  Any pointers would be 
>>greatly appreciated?
>>  >
>>  > TIA,
>>  > Shawn
>>  >
>>  > ---------------------------------------------------------------------
>>  > Before posting, please check:
>>  >    http://www.mysql.com/manual.php   (the manual)
>>  >    http://lists.mysql.com/           (the list archive)
>>  >
>>  > To request this thread, e-mail <mysql-thread111300@stripped>
>>  > To unsubscribe, e-mail
> <mysql-unsubscribe-cfaber=fpsn.net@stripped>
>>  > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>  --
>>  Colin Faber
>>  (303) 736-5160
>>  fpsn.net, Inc.
>>
>>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread111327@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
Read Only on User tableRichard Davidson24 May
  • Re: Read Only on User tableEgor Egorov27 May
  • Re: Read Only on User tableVan27 May
  • Re: Read Only on User tableBenjamin Pflugmann27 May
  • MySQL and DBI remote accessShawn7 Jun
  • Re: MySQL and DBI remote accessColin Faber7 Jun
  • Re: MySQL and DBI remote accessShawn7 Jun
    • Re: MySQL and DBI remote accessPaul DuBois7 Jun