Every time I log on to phpMyAdmin with a user that has the appropriate external privileges, and select a database, phpMyAdmin reverts to http://hostname/phpMyAdmin/. I have the hostname defined as Hostname (with a capital staring letter). The path in config.inc.php has been edited and correctly edited to http://Hostname/phpMyAdmin/. Why is it not resolving to http://Hostname/phpMyAdmin/ and properly substitute Hostname with the assigned IP?

"Finishing in second place, simply means you are the first loser." - PouyaCat

Do you have that address properly configured in your /etc/hosts file? If you''re using DNS, it will return the full FQDN. Wasn''t sure if you were just going by a alias hostname or FQDN.

Interim

Well, the contents of /etc/hosts looks like this:

127.0.0.1 localhost.localdomain localhost
192.168.40.60 Hostname Hostname

Since I have no clue as to what FQDN is, I''d say with fair confidence that it''s an alias.

"Finishing in second place, simply means you are the first loser." - PouyaCat

hostname and Hostname are the same for browsers, so as soon as you reach some relative link, it gets set to lowercase...

[edited by - __tunjin__ on February 3, 2004 8:38:49 AM]

httpd.conf:

UseCanonicalName Off

(EDIT: might be other issues with phpMyAdmin config, but this is a very common problem)

[edited by - CWizard on February 3, 2004 10:20:23 AM]

Ugh - finally got X up and running again - evidently xfs could not initialize and it took me 3 days to figure out what to do...

Anyway, neither setting UseCanonicalPath to off, nor leaving it on and specifying ServerName as the computer''s IP not help much: when opening phpMyAdmin from a remote computer, it pretty nicely loads up the initial screen (with the exception of the phpMyAdmin logo in the upper left corner). When trying to open one of the databases, though, IE displays a subtle "looking for the host ''hostname''" for a couple of seconds and then ceases to do anything... It appears that it can''t resolve PmaAbsoluteUri in myPhpAdmin''s config.inc.php:

$cfg[''PmaAbsoluteUri''] = ''http://hostname/phpMyAdmin/'';

will not work, while:

$cfg[''PmaAbsoluteUri''] = ''http://_hostIP_/phpMyAdmin/'';

will.

Why can''t/won''t it resolve the hostname alias? Not so much of a problem, but it''d be nice if php could ignore the absolute part and actually do stuff dynamically.

Since I''m reluctant to start a new thread every time I run into a little ''nag'' or come up with a questions, here''s a few off-topic ones:

1) what''s the best html/php editor in Linux?
2) is there a way to dump an image of a Linux installation to a Windows machine (will backing up /home/, /etc/ and /var/ directories suffice?)? This is because I don''t have the resources to buy a RAID controller and another HDD just now, but I really want to duplicate the current system status.

"Finishing in second place, simply means you are the first loser." - PouyaCat

quote: Original post by Crispy
$cfg[''PmaAbsoluteUri''] = ''http://hostname/phpMyAdmin/'';

will not work, while:

$cfg[''PmaAbsoluteUri''] = ''http://_hostIP_/phpMyAdmin/'';

will.

Why can''t/won''t it resolve the hostname alias?

Well is hostname a FQDN? Can you resolve it with $ nslookup hostname on the remote system?

quote: Not so much of a problem, but it''d be nice if php could ignore the absolute part and actually do stuff dynamically.

You could change it to:

$cfg[''PmaAbsoluteUri''] = ''http://''.$_SERVER[''SERVER_NAME''].''/phpMyAdmin/'';

But remember to have Apache configured with UseCanonicalName off then.

quote: 1) what''s the best html/php editor in Linux?

if($question =~ /editor/) { $answer = "Emacs"; }

quote: 2) is there a way to dump an image of a Linux installation to a Windows machine (will backing up /home/, /etc/ and /var/ directories suffice?)?

You could use a disk utility (eg. Partition Magic) to make an exact image of the drive, but if you just want to copy all files, it would be easiest to mount a FAT32 partition in Linux, and do a normal copy.

quote: Original post by Crispy
Since I''m reluctant to start a new thread every time I run into a little ''nag'' or come up with a questions, here''s a few off-topic ones:

1) what''s the best html/php editor in Linux?

Emacs has already been suggested (which probably implies the fork of it, XEmacs, as well). I like VIM (and its GUI versions), personally. Those two can do just about anything you want. Of course, they''re not for everyone.

quote: Original post by Crispy
2) is there a way to dump an image of a Linux installation to a Windows machine (will backing up /home/, /etc/ and /var/ directories suffice?)? This is because I don''t have the resources to buy a RAID controller and another HDD just now, but I really want to duplicate the current system status.

A straight copy would lose the permissions and such. Creating a proper tarball (proper, as in: make sure to retain permissions, et cetera) of those three partitions should be have most of the stuff you need. You might have minor problems when you extract the tarball again if you haven''t setup the machine the exact same way. There are more specially adapted tools to handle backups if you need something more robust (can''t think of any names at the moment though).

Curious, you said you are having problems opening it in IE? You''re running PHP on LAMP (Linux, Apache, MySQL, PHP)? So, I''m curious, did you configure your windows machine''s host file with your hostname ip for your machine?

In other words, can you do nslookup on your Windows-IE machine for your PHP server hostname and it resolves? If not, would definitely explain your need to use IP address. Should work find on your PHP server (where you have your /etc/hosts configured with the hostname).

By the way, FQDN is Fully Qualified Domain Name. hostname.domain.com is an FQDN, well, actually hostname.domain.com_._ is a FQDN. In any event, I''m guessing you have a home network. If you want easy netbios name resolution like windows passes around, you''ll need to run Samba (NMBD) to answer NBT requests on your network.

If you want to edit your local Windows hosts file, look in %SystemRoot%\System32\drivers\etc\hosts. Syntax is like unix host files.

But someone said it. hostnames aren''t case sensitive, whether you use Hostname or hostname doesn''t really matter. Also, you shouldn''t see your assigned IP address show up in the URL, unless you type it in or redirect them to a site with an IP address in the URL.

int.