Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
As shown in the OP I am already doing that in the PHP scipt: $host = "instance43490.db.xeround.com:8904"; And then passing that as the 1st param to mysql_connect On 4/21/13 4:23 PM, Stuart Dallas wrote: On 22 Apr 2013, at 00:14, Glob Design Info wrote: However, I may have found the problem:

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Stuart Dallas
On 22 Apr 2013, at 00:14, Glob Design Info wrote: > However, I may have found the problem: the port. As a security measure the > BaaS provider appears to have changed MySQL to a non-standard port. > So > > On the command line: > > sudo mysql --host=instance43490.db.xeround.com --p

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread David Robley
Glob Design Info wrote: > On 4/21/13 3:27 PM, Stuart Dallas wrote: >> On 21 Apr 2013, at 20:29, Glob Design Info wrote: >> >>> If that is the case then why does logging in with exactly the same >>> params from a UNIX shell work fine? Command line login supposedly would >>> be adding the @localhos

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
On 4/21/13 3:27 PM, Stuart Dallas wrote: On 21 Apr 2013, at 20:29, Glob Design Info wrote: If that is the case then why does logging in with exactly the same params from a UNIX shell work fine? Command line login supposedly would be adding the @localhost or @IP_address as well but isn't. Onl

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Stuart Dallas
On 21 Apr 2013, at 20:29, Glob Design Info wrote: > If that is the case then why does logging in with exactly the same params > from a UNIX shell work fine? Command line login supposedly would be adding > the @localhost or @IP_address as well but isn't. Only when I pass the > variables to the

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
This for a commercial app - the client wants both an API connect via PHP and a web portal in which they can login from a web page and view the tables in the DB. Right now I am just trying to get the form/PHP interaction to work. On Apr 21, 2013, at 6:42 AM, tamouse mailing lists wrote: > On S

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
If that is the case then why does logging in with exactly the same params from a UNIX shell work fine? Command line login supposedly would be adding the @localhost or @IP_address as well but isn't. Only when I pass the variables to the script is that happening. I am doing exactly as you stated:

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread tamouse mailing lists
On Sun, Apr 21, 2013 at 5:20 AM, Glob Design Info wrote: > I am aware of the security implications. I will deal with that later. Right > now I am just trying to get the WS architecture working. I'm wondering, if you can get it to work with the creds in the script, why do you have to have them co

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Stuart Dallas
On 21 Apr 2013, at 11:20, Glob Design Info wrote: > I don't understand why mysql_connect should append something in the case of a > passed variable but not in the case of a local variable. Unless there is > something in the form parsing machinery I am unaware of. Nothing is being added by anyt

[PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
Thanks Geoff, I am aware of the security implications. I will deal with that later. Right now I am just trying to get the WS architecture working. I am logging in with the creds the hosting provider gave me (xeround.com) When I use those creds on the mysql command line, or hard-code them in the

[PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
Thanks for that great response Geoff. That very well may be what is wrong, however, my problem is I don't have admin access to this server - it hosted in a BaaS site where they do all the admin. They do provide mysql command line access and it works, but it won't let me log in as root, not even

Re: [PHP] Re: mysql_connect does not connect

2004-09-21 Thread Chris Dowell
Sam, You're correct - the manual does leave a little bit of a grey area about which extension you should use for 4.1.0 < MySQL version < 4.1.3 However, as you're using 5.0.1 this really shouldn't confuse you to quite the extent which it has. Sam Hobbs wrote: "Curt Zirzow" <[EMAIL PROTECTED]> wr

Re: [PHP] Re: mysql_connect does not connect

2004-09-18 Thread Sam Hobbs
"Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Unfortunately (fortunately?) there are packages out there which install > all > Apache/MySQL/PHP for you or whatever. So unless you state which package > you're using then "typical" is still meaningless. It's just helpfu

Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Matthew Sims
> * Thus wrote Sam Hobbs: >> "Curt Zirzow" <[EMAIL PROTECTED]> wrote in message >> news:[EMAIL PROTECTED] >> > >> > RTFM. >> > >> > mysql: >> > This MySQL extension doesn't support full functionality of MySQL >> > versions greater than 4.1.0. For that, use MySQLi. >> > >> > mysqli: >> > The mysq

Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Curt Zirzow
* Thus wrote Sam Hobbs: > "Curt Zirzow" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > RTFM. > > > > mysql: > > This MySQL extension doesn't support full functionality of MySQL > > versions greater than 4.1.0. For that, use MySQLi. > > > > mysqli: > > The mysqli extension

Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Jason Wong
On Friday 17 September 2004 23:36, Sam Hobbs wrote: > "Jason Wong" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > There is only one Windows installer available rom the MySQL web site and it > has an option that explicitly says "Typical". Therefore in this context > "Typical" is e

Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Jason Davidson
Yes yes, your always relevent, we are not... funny that you have the problem and we do not though. Jason "Sam Hobbs" <[EMAIL PROTECTED]> wrote: > > "Jason Wong" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > I'm not familiar with MySQL under Windows, but I believe that

Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
"Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > I'm not familiar with MySQL under Windows, but I believe that there are > different installers available from various sources. So saying "Typical" > installation option doesn't really mean much. There is only one Windows

Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
"Curt Zirzow" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > RTFM. > > mysql: > This MySQL extension doesn't support full functionality of MySQL > versions greater than 4.1.0. For that, use MySQLi. > > mysqli: > The mysqli extension is designed to work with the version 4.1.3 or

Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread John Nichel
Jason Davidson wrote: woah, full functionality.. it has will still connect, at least, it will still connect for me. Where the functionality is missing, im not sure. But sinse the error is cant connect to localhost, i would say that it strying to connect to localhost, and not being allowed. The

Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread Jason Davidson
woah, full functionality.. it has will still connect, at least, it will still connect for me. Where the functionality is missing, im not sure. But sinse the error is cant connect to localhost, i would say that it strying to connect to localhost, and not being allowed. That said, im fully open

Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread Curt Zirzow
* Thus wrote Sam Hobbs: > "Janbro" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hi I connect to a MySQL 4.1 with the following String: > > > > > > if > > ($db_verbin=mysqli_connect("$mysql_host","$mysql_user","$mysql_passw","$DB_n > > ame")) > > > > watch the i in mysqli_conne

Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread raditha dissanayake
Jason Wong wrote: On Thursday 16 September 2004 11:51, raditha dissanayake wrote: me thinks it's time to look very closely at http://www.postgresql.org Not just you sam, all of us. If everyone subscribes to your reasoning then nobody would be using Windows (yay!). I am a recent convert

Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread Jason Wong
On Thursday 16 September 2004 11:51, raditha dissanayake wrote: > me thinks it's time to look very closely at http://www.postgresql.org > Not just you sam, all of us. If everyone subscribes to your reasoning then nobody would be using Windows (yay!). Anyway FWIW I found postgresql's system of g

Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread Jason Wong
On Thursday 16 September 2004 10:53, Sam Hobbs wrote: > "Jason Wong" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > So now are you fully convinced it's your firewall that's the root of your > > problem? > > No, not really. At the moment I am assuming it is a bug in something >

Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread raditha dissanayake
me thinks it's time to look very closely at http://www.postgresql.org Not just you sam, all of us. -- Raditha Dissanayake. http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP apple

Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
"Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > So now are you fully convinced it's your firewall that's the root of your > problem? No, not really. At the moment I am assuming it is a bug in something somewhere. The versions of php and MySQL that I am using are not

Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Jason Davidson
firewall, who would have thought Jason Wong <[EMAIL PROTECTED]> wrote: > > On Thursday 16 September 2004 06:14, Sam Hobbs wrote: > > [quote from another Sam Hobbs post] > > I am the original poster. The reason I avoid doing things like that is > > because it is a guess. It should not be nec

Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Jason Wong
On Thursday 16 September 2004 06:14, Sam Hobbs wrote: [quote from another Sam Hobbs post] > I am the original poster. The reason I avoid doing things like that is > because it is a guess. It should not be necessary; the firewal should not > be relevant. Sometimes people suggest things that are not

Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
"Andrew Kreps" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Tue, 14 Sep 2004 10:11:24 -0700, Sam Hobbs <[EMAIL PROTECTED]> wrote: >> Also, are the warning messages documented? As I asked in my original >> question, is 10061 an error code? > > 10061 is a generic winsock error fo

Re: [PHP] Re: mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
"Andrew Kreps" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Tue, 14 Sep 2004 10:11:24 -0700, Sam Hobbs <[EMAIL PROTECTED]> wrote: >> Also, are the warning messages documented? As I asked in my original >> question, is 10061 an error code? > > 10061 is a generic winsock error fo

Re: [PHP] Re: mysql_connect does not connect

2004-09-14 Thread Andrew Kreps
On Tue, 14 Sep 2004 10:11:24 -0700, Sam Hobbs <[EMAIL PROTECTED]> wrote: > Also, are the warning messages documented? As I asked in my original > question, is 10061 an error code? 10061 is a generic winsock error for a timeout, it's not PHP or MySQL specific. It means that the call couldn't conne

Re: [PHP] Re: mysql_connect does not connect

2004-09-14 Thread John Nichel
Sam Hobbs wrote: When I do try mysqli_connect, I get: Fatal error: Call to undefined function mysqli_connect() So obviously I need to do something to enable that. I will look into that later, but I am still trying to get mysql_connect to work. mysqli : http://us4.php.net/mysqli What error a

[PHP] Re: mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
"Janbro" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi I connect to a MySQL 4.1 with the following String: > > > if > ($db_verbin=mysqli_connect("$mysql_host","$mysql_user","$mysql_passw","$DB_n > ame")) > > watch the i in mysqli_connect! > > I think I've read somewhere that you

[PHP] Re: mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
"Janbro" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi I connect to a MySQL 4.1 with the following String: > > > if > ($db_verbin=mysqli_connect("$mysql_host","$mysql_user","$mysql_passw","$DB_n > ame")) > > watch the i in mysqli_connect! > > I think I've read somewhere that you

[PHP] Re: mysql_connect does not connect

2004-09-14 Thread JanBro
Hi I connect to a MySQL 4.1 with the following String: if ($db_verbin=mysqli_connect("$mysql_host","$mysql_user","$mysql_passw","$DB_n ame")) watch the i in mysqli_connect! I think I've read somewhere that you are required to use that for the >4.1 Versions, but you better look that up, I might

[PHP] Re: mysql_connect does not connect

2004-09-14 Thread JanBro
Hi I connect to a MySQL 4.1 with the following String: if ($db_verbin=mysqli_connect("$mysql_host","$mysql_user","$mysql_passw","$DB_n ame")) watch the i in mysqli_connect! I think I've read somewhere that you are required to use that for the >4.1 Versions, but you better look that up, I might

[PHP] Re: mysql_connect does not connect

2004-09-14 Thread JanBro
Hi I connect to a MySQL 4.1 with the following String: if ($db_verbin=mysqli_connect("$mysql_host","$mysql_user","$mysql_passw","$DB_n ame")) watch the i in mysqli_connect! I think I've read somewhere that you are required to use that for the >4.1 Versions, but you better look that up, I might

[PHP] RE: mysql_connect and PHP 5.0

2004-08-03 Thread Michael Purdy
Have you enabled MYSQL support by removing the semi-colon in front of the extension DLL in the php.ini file? Mike

[PHP] Re: mysql_connect

2004-04-20 Thread Jason Barnett
Lasse Motroen wrote: Help again please. Im trying to connect to MySQL server, using the PHP function: mysql_connect('localhost', 'someuser', 'somePword'); I run it, and what I get is: *Fatal error*: Call to undefined function: mysql_connect() It sounds like you don't have support for the MySQL fun

[PHP] Re: mysql_connect() fails randomly

2003-08-19 Thread Jon Drukman
Curt Zirzow wrote: * Thus wrote Jon Drukman ([EMAIL PROTECTED]): $dbh=mysql_connect() or die("mysql connect failed: " . mysql_error()); . Ensure your error_reporting level is high enought to allow Warnings, and make sure display_errors is on. or . Turn on track_errors and use the variable

[PHP] Re: mysql_connect problem under RedHat 8.0 ?

2002-12-08 Thread Brian J. Celenza
Found the problem... Somehow my version of mysql had become uninstalled, and I have no idea why that is. Thanks for all the help :) "Brian J. Celenza" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello! > > When trying to connect to a mysql database under m

[PHP] Re: mysql_connect failes w/ variables and defines. why?

2001-09-24 Thread _lallous
Can you show us some code? "Dana Holt" <[EMAIL PROTECTED]> wrote in message 000501c143df$dcedbb20$6400a8c0@MORPHEUS">news:000501c143df$dcedbb20$6400a8c0@MORPHEUS... > Does anyone know why if I pass mysql_connect() or mysql_select_db() parms as > variables or defined constants the connection alway