Multiple virtual hosts and phpMyAdmin

[ChrisRChamberlain]

Hi all

Running multiple virtual hosts on Ubuntu server 10.04 and would like to install phpMyAdmin on the server.

The content of /etc/apache2/conf.d/virtual.conf is

#
# We're running multiple virtual hosts
#
NameVirtualHost *

The phpMyAdmin install reports an error with

VirtualHost *:80 -- mixing * ports and non-* ports with a NameVirtualHost address is not supported, proceding with undefined results

It is not possible then to proceed beyond the phpMyAdmin login form.

Any workarounds please?

TIA

FAQ184-2483​

Chris
PDFcommander.com
motrac.co.uk

 

[ChrisRChamberlain]

Seems mySql not working now with error

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

Going to install Ubuntu server again and see if the multiple vitual host configuration is causing the problem.

FAQ184-2483​

Chris
PDFcommander.com
motrac.co.uk

 

[Noway2]

Ubuntu 10.04 switched to php 5.3 from 5.2 and this has developed a reputation for causing a lot of problems. I am wondering if that is what you are facing.

My first thought was that it should work as that is what I am running. I checked and it turns out I am still using 9.10.

It looks like for the first error it may be a case of needing this: NameVirtualHost *:80 rather than NameVirtualHost *.

Not sure why mysql can't connect though, unless it isn't getting to that part in the script because of another error.

 

[ChrisRChamberlain]

Noway2

Thanks for your reply.

I have created a text file that contains the code required for the various sections, FTP, SAMBA, etc set up after the desktop has been installed.

I failed to spot the error in this snippit

sudo chown -R chris:chris /var/

It effectively disables MySQL by virtue of the change of ownership of the folders, error message being

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Since correcting the mistake, and the text file, all works as expected.

FAQ184-2483​

Chris
PDFcommander.com
motrac.co.uk