Re: [PHP] Re: limit access to php page

2013-05-29 Thread Glob Design Info
On 5/29/13 6:14 PM, Jim Giner wrote: On 5/29/2013 7:11 PM, Tim Dunphy wrote: Hello list, I've created an authentication page (index.php) that logs into an LDAP server, then points you to a second page that some folks are intended to use to request apache redirects from the sysadmin group

Re: [PHP] mysql_connect noob question

2013-04-23 Thread Glob Design Info
to see the maturity level of posters on this list, as in most of IT these days is that of a bunch of squabling 5-year olds. On 4/23/13 5:47 AM, Tedd Sperling wrote: On Apr 21, 2013, at 3:33 PM, Glob Design Info i...@globdesign.com wrote: What question did I not answer? That proves that you're

[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

[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

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
documented both the exact HTML and PHP code in this thread and so see no need to post it elsewhere. On Apr 21, 2013, at 6:32 AM, Stuart Dallas stu...@3ft9.com wrote: On 21 Apr 2013, at 11:20, Glob Design Info i...@globdesign.com wrote: I don't understand why mysql_connect should append something

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
...@gmail.com wrote: On Sun, Apr 21, 2013 at 5:20 AM, Glob Design Info i...@globdesign.com 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

Re: [PHP] mysql_connect noob question

2013-04-21 Thread Glob Design Info
What question did I not answer? I am developing a web portal that has to display the tables in the DB via a form/script. The web page has a login with user and password. Right now I am just trying to connect. On Apr 21, 2013, at 7:12 AM, Tedd Sperling tedd.sperl...@gmail.com wrote: On Apr

Re: [PHP] mysql_connect noob question

2013-04-21 Thread Glob Design Info
Except that a) I already have my form and script done, b) don't have time to learn phpMyAdmin, c) want to know why the script doesn't work as-is. On Apr 21, 2013, at 12:46 PM, David OBrien dgobr...@gmail.com wrote: Not meaning to beat the proverbial dead horse I am developing a web portal

Re: [PHP] mysql_connect noob question

2013-04-21 Thread Glob Design Info
as mentioned (at least not visibly). On Apr 21, 2013, at 8:39 AM, tamouse mailing lists tamouse.li...@gmail.com wrote: On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com wrote: I know this has probably been answered already. When I pass a user name and password from a form

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 i...@globdesign.com 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

Re: [PHP] mysql_connect noob question

2013-04-21 Thread Glob Design Info
have to look for another solution (like C which I have been using for 20 years). On 4/21/13 3:37 PM, Stuart Dallas wrote: On 21 Apr 2013, at 22:43, Glob Design Info i...@globdesign.com wrote: Except that a) I already have my form and script done, b) don't have time to learn phpMyAdmin, c

Re: [PHP] mysql_connect noob question

2013-04-21 Thread Glob Design Info
Tried that. Still didn't work. I appears to be the port. On 4/21/13 3:40 PM, Stuart Dallas wrote: On 21 Apr 2013, at 23:01, Glob Design Info i...@globdesign.com wrote: I should note my user name in this case *is* an email address, however the dots in that address are *not* being converted

Re: [PHP] mysql_connect noob question

2013-04-21 Thread Glob Design Info
SUCCESS! However. if ( $_REQUEST['Submit'] ) { makes it work (using my own form button ID). Why it doesn't work without this on my machine is beyond me. But it doesn't. Could it be somehow there is something about accessing the $_REQUEST that changes something? I am baffled as to the

Re: [PHP] mysql_connect noob question

2013-04-21 Thread Glob Design Info
Even more strange: It doesn't work from the form with or without the domain (but on the command line it does), but.. IF I add the $_REQUEST access *and* use the user that the *MySQL* install has, and *not* the xeround user name (my email), then it *does* work! WEIRD. On 4/21/13 3:59

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 i...@globdesign.com wrote: However, I may have

Re: [PHP] mysql_connect noob question

2013-04-21 Thread Glob Design Info
A very complex solution that takes time to learn, configure, and install, vs. a single file I can toss on the server. Over-engineering is what is daft. On 4/21/13 4:33 PM, Stuart Dallas wrote: On 22 Apr 2013, at 00:16, Glob Design Info i...@globdesign.com wrote: Except that I want to use my

Re: [PHP] mysql_connect noob question

2013-04-21 Thread Glob Design Info
Ever heard of the MySQL C Connector? http://www.karlkraft.com/index.php/2010/06/02/mysql-and-objective-c/ :-) On 4/21/13 4:33 PM, Stuart Dallas wrote: On 22 Apr 2013, at 00:16, Glob Design Info i...@globdesign.com wrote: Except that I want to use my script and form - precisely because I

Re: [PHP] mysql_connect noob question

2013-04-20 Thread Glob Design Info
); header(Content-type: text/plain); var_dump($_POST); exit; ? and see precisely what is being passed in from your form. On Apr 19, 2013 10:50 PM, Glob Design Info i...@globdesign.com wrote: No, no spaces. I am wondering if I need to use htmlspecialchars() On Apr 19, 2013, at 7:17 PM, Jim Giner

Re: [PHP] mysql_connect noob question

2013-04-20 Thread Glob Design Info
Goog suggestion. The user name is an email address so it does contain @. Password is all pure lowercase ASCII. Wonder if the shift-2 is causing the problem? On 4/20/13 4:44 AM, Matijn Woudt wrote: On Sat, Apr 20, 2013 at 10:36 AM, tamouse mailing lists tamouse.li...@gmail.com wrote: No,

Re: [PHP] mysql_connect noob question

2013-04-20 Thread Glob Design Info
Same error. That just turns those into string literals. On 4/20/13 5:48 AM, David OBrien wrote: $form_user = $_POST[ 'user' ]; $form_pass = $_POST[ 'password' ]; # Connect to remote DB $LINK = mysql_connect( $host, $form_user, $form_pass ); And yes, my $host param is correct. Have you tried

Re: [PHP] mysql_connect noob question

2013-04-20 Thread Glob Design Info
Night now this is just a test server. On the real thing I'll do it right. On 4/20/13 10:58 AM, Tedd Sperling wrote: On Apr 20, 2013, at 11:44 AM, Stuart Dallas stu...@3ft9.com wrote: On 20 Apr 2013, at 16:25, Jim Giner jim.gi...@albanyhandball.com wrote: Why are you allowing anyone to

[PHP] mysql_connect noob question

2013-04-19 Thread Glob Design Info
I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect as string literals it works. Can anyone tell me why this happens?

Re: [PHP] mysql_connect noob question

2013-04-19 Thread Glob Design Info
19, 2013 at 10:43 PM, Glob Design Info i...@globdesign.comwrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script and then pass those to mysql_connect it doesn't connect. When I paste those exact same values into mysql_connect

Re: [PHP] mysql_connect noob question

2013-04-19 Thread Glob Design Info
/19/13 2:13 PM, Matijn Woudt wrote: On Fri, Apr 19, 2013 at 10:59 PM, Glob Design Info i...@globdesign.comwrote: Already did that. I printed the form values in the PHP script after they are received and they print exactly as entered in the form. Even checked for extra spaces. Any functions I can

Re: [PHP] mysql_connect noob question

2013-04-19 Thread Glob Design Info
* (But with the real user name, not just 'user') Thanks, On 4/19/13 3:28 PM, tamouse mailing lists wrote: On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com wrote: I know this has probably been answered already. When I pass a user name and password from a form to my PHP script

Re: [PHP] mysql_connect noob question

2013-04-19 Thread Glob Design Info
cause it to fail. On 4/19/13 5:47 PM, David Robley wrote: Glob Design Info wrote: Sorry. The error displayed is: *Warning*: mysql_connect() [function.mysql-connect http://localhost/wservices/function.mysql-connect]: Access denied for user 'user'@'ip70-162-142-180.ph.ph.cox.net' (using

Re: [PHP] mysql_connect noob question

2013-04-19 Thread Glob Design Info
No, no spaces. I am wondering if I need to use htmlspecialchars() On Apr 19, 2013, at 7:17 PM, Jim Giner jim.gi...@albanyhandball.com wrote: On 4/19/2013 9:33 PM, Glob Design Info wrote: They aren't on the same server. The DB is on xeround.com, the web server is localhost. The host value

Re: [PHP] mysql_connect noob question

2013-04-19 Thread Glob Design Info
Dunno. The code definitely has the underscore. On Apr 19, 2013, at 9:11 PM, Jim Giner jim.gi...@albanyhandball.com wrote: On 4/20/2013 12:23 AM, Glob Design Info wrote: No, no spaces. I am wondering if I need to use htmlspecialchars() On Apr 19, 2013, at 7:17 PM, Jim Giner jim.gi