phpMyAdmin setup question

[Dan Kaplan]

Copied from an @support email; more appropriate for the forums:

I'm trying to set up phpMyAdmin in my Links SQL directory.[nbsp][nbsp]I've never used PHP before, so it's quite possible I've missed something.[nbsp][nbsp]At any rate, I'm pretty much stumped.

I downloaded the latest phpMyAdmin tar.gz file and uploaded it in binary into my desired directory which is protected with .htaccess.[nbsp][nbsp]I untarred it (the enclosed instructions' method wasn't right for untarring) into phpMyAdmin below the Links SQL admin directory.[nbsp][nbsp]When I try to access the index.php3 main file or Documentation.html in the phpMyAdmin directory, I get a 500 server error.[nbsp][nbsp]I can't figure out why this is.[nbsp][nbsp]Is it because they cannot be served from the cgi-bin?[nbsp][nbsp]It seems odd that a standard html page in the phpMyAdmin directory would produce an internal server error.[nbsp][nbsp]Could their be some problem with permissions being set during the untar process?[nbsp][nbsp]I also installed by ftp (and didn't chmod anything), but that produced the same errors.

Terra confirmed that I have the config.inc.php3 apparently configured correctly, so I don't think that's part of the problem.

Has anyone successfully installed phpMyAdmin on FutureQuest's servers?[nbsp][nbsp]Any thoughts where I'm getting tripped up?

Thanks,
Dragnet

[dean]

I un-tarred it on my local drive and uploaded as ASCII. And didn't have a problem.

dean
dean@betazine.com

phpmyadmin is the greatest tool ever written

[Dan Kaplan]

Hi Dean,

Thanks for the reply.[nbsp][nbsp]Did you upload it to your cgi-bin?[nbsp][nbsp]Did you have to set permissions?[nbsp][nbsp]And what about the images directory?[nbsp][nbsp]Untarring it puts the images directly below the phpMyAdmin directory, so putting the files in the cgi-bin would seem to be a problem with the default setup (I don't believe you can serve images from the cgi-bin)...

Dan

[Dan Kaplan]

From the installation notes; are any of these relevant issues:

[nbsp][nbsp]+ PHP3 should be configured to have magic_quotes=on. In the module
[nbsp][nbsp][nbsp][nbsp]version of PHP3 this can also be set on a per-directory base with
[nbsp][nbsp][nbsp][nbsp]php3_magic_quotes_gpc on in an .htaccess file or in your Apache's
[nbsp][nbsp][nbsp][nbsp]access.conf.
[nbsp][nbsp]+ If you don't use the extension ".php3" for your scripts, you can use
[nbsp][nbsp][nbsp][nbsp]the bundled script "extchg.sh" to modify phpMyAdmin (or any other script)
[nbsp][nbsp][nbsp][nbsp]to work with a different extension. Beware though, that currently changing
[nbsp][nbsp][nbsp][nbsp]the extension from .html to something other won't work (it'd change all
[nbsp][nbsp][nbsp][nbsp]"string".htmlspecialchars() constructs).

[Dan Kaplan]

Problem solved.[nbsp][nbsp]phpMyAdmin apparently cannot be installed in the cgi-bin, at least with the FQ setup.[nbsp][nbsp]Moving it under /www/ works like a charm.[nbsp][nbsp]:)

Small question for people that have used the program:[nbsp][nbsp]Is there a way other than setting $cfgServers[1]['only_db'] to a single database name to see only your own databases, not those for the entire server?[nbsp][nbsp]I only have one database in use at the moment, so it's not currently a big deal.[nbsp][nbsp]I tried replacing 'only_db' with 'dbname,dbname_2' but it didn't recognize that...

My only concern is that phpMyAdmin looks to be extremely powerful, yet as far as I can tell, the documentation is virtually nonexistent.[nbsp][nbsp]Is the mailing list the way to learn how to use it, or are there other resources?

Thanks,
db

[dean]

Sorry I would have answered but I had to work today. Seems you were talking to yourseld for quite awhile though :)

mySQL before the admin program was a chore and a hassle. With the utility it is a joy. But I guess you already know that.

[Dan Kaplan]

Yeah, I've been in a talkative mood.[nbsp][nbsp]:)

One nice thing would be if all the menus asked you if you really want to delete/drop something before proceeding...[nbsp][nbsp]Fortunately, my discovery that not all do so was on a test of a test of a test table.

Desolate

[Dan Kaplan]

I suppose they consider mysql.org the documentation...

[dean]

Great I got to answer !

Yes I agree with that

[andre]

phpMyAdmin can really be a pain, if you mix up some links (it is very easy to mistake change for drop and vice versa;-) The mailing list is actually not very informative, except if you want development ifnormation. I know that they are currently working on a phpAds mailing list archive, so maybe they will have a myAdmin archive as well to search through the old posts. So far my advice is to familiarize yourself with the program on a test (of a test (of a test...)) database and use then on the real thing.

I still haven't worked out the "query by example" page.. Very confusing...

--
andre
[This message has been edited by andre (edited 02-13-00@5:39 pm)]

[gdesclaux]

>Small question for people that have used the program:[nbsp][nbsp]Is >there a way other than setting $cfgServers[1]['only_db'] >to a single database name to see only your own databases, >not those for the entire server?[nbsp][nbsp]I only have one database >in use at the moment, so it's not currently a big deal.[nbsp][nbsp]I >tried replacing 'only_db' with 'dbname,dbname_2' but it >didn't recognize that...

To do that you can easily modify the script lib.inc.php3.
After the line 116 add this line :

$dblist[0] = "xdomain";
$dblist[1] = "xdomain_2";
$dblist[2] = "xdomain_3";
$dblist[3] = "xdomain_4";
$dblist[4] = "xdomain_5";
$dblist[5] = "xdomain_6";

That's all !

[Dan Kaplan]

Hey, that works beautifully, thanks![nbsp][nbsp]:)[nbsp][nbsp]Did you come up with that yourself (probably not too hard to do for someone that knows php and MySQL...), or is a documented trick somewhere?

Thanks,
Dan