First, a warning: my experience is with Ubuntu Server 8.04, not Debian. While they are similar, there may be differences.
thelongmile wrote:
So, now comes the confusing bit. Apt-get install phpmyadmin
that happens, no errors... beyond that I've no idea where it is and navigating to the server IP/phpmyadmin no results, page 404 despite restarting the server afterwards to ensure it's running (so, thats confusion number one)
On Ubuntu, the package installs into /usr/share/phpmyadmin/. You somehow need to serve these files. One way would be to create a link from within the web root to /usr/share/phpmyadmin/. I instead did it by putting the following into a VirtualHost directive in the site config:
Code:
Alias /pma/ "/usr/share/phpmyadmin/"
<Directory "/usr/share/phpmyadmin/">
Options Indexes MultiViews FollowSymLinks
AllowOverride None
Order allow,deny
# Only allow access to phpMyAdmin from localhost
Allow from 127.0.0.1
</Directory>
For security, the "Allow from" only permits connections from localhost. When I need to connect to phpMyAdmin, I create an ssh tunnel via
ssh -L 8080:localhost:80 user@mylinode.example.com. Then I can type
http://localhost:8080/pma/ into the address bar of my browser and connect to phpMyAdmin over a secure, encrypted connection.
You could replace this with "Allow from all" but then the whole world gets an opportunity to try to hack your MySQL installation. And believe me, they will try.
thelongmile wrote:
Then i wondered, how i would upload files to the two virtual hosts I had specified that were in /srv/www/websitename1 and websitename2 so, i installed ftp, apt-get install asftpd
You're best off sticking with ssh/scp instead of dealing with FTP. There are plenty of friendly graphical SCP clients available for all the popular operating systems.
thelongmile wrote:
I then figured I'd have a look at where the website files were, and found that the apache "it works" page is not in srv, but rather /var/www . So now I wonder.. how does it point toward the two virtual host folders i've created, and how can I test and implement the two websites I've already got, before adding the domains in and pointing them to the site.
Like I said before, I'm not very familiar with "the Debian way" and its /srv/ filesystem layout, but you probably want to at least get familiar with Apache
name-based virtual hosting before monkeying with things. On the server I work with, the site subdirectories are /var/www/example.org/, /var/www/yoyodyne.com/, etc.