Ryan, I have found the origin of the problem But I still remain puzzled... See below...
n Sat, Jun 15, 2013 at 7:15 PM, Ryan Schmidt <[email protected]>wrote: > > On Jun 15, 2013, at 11:21, Rodolfo Aramayo wrote: > > > I am having trouble figuring out the following: > > > > Following the instructions posted in: > http://trac.macports.org/wiki/howto/MAMP > > > > I was able to successfully install everything and get everything working > perfectly > > > > Basically I was able to see: > > > > localhost > > localhost/phpinfo.php > > localhost/phpmyadmin > > localhost/mywebsite1 > > localhost/mywebsite2 > > > > Using phpmyadmin i was able to create databases and users correctly > > Ok, so at this point in time you knew a MySQL username and password that > allowed you to log in. > > Indeed. Using the terminal I was able to log into any user/database in MySQL5 > > I then activated Include conf/extra/httpd-vhosts.conf in the httpd.conf > and in the httpd-vhosts.conf I configure a virtual host which works well > > > > Days later I tried to access phpmyadmin and while I can see phpmyadmin > well but I cannot log into it using usernames and passwds I know are correct > > > > Using the same usernames and passwds I can successfully log into mysql > via terminal > > I'm assuming your MySQL server is on the same machine as your web server > and that you're therefore trying to talk to the MySQL server using a UNIX > socket. If that's not so, let me know. > > Yes. Same machine Yes, UNIX socket (mysql.default_socket=/opt/local/var/run/mysql5/mysqld.sock) > Perhaps there is a mismatch between where the MySQL server stores its > socket file and where you've configured PHP to look for it. Have you > changed where MySQL stores its socket, by editing the my.cnf file? If so, > make the same change in the php.ini and/or the phpmyadmin config file. > > at php.in (development) I have: mysql.default_socket=/opt/local/var/run/mysql5/mysqld.sock I do not have my.cnf?? so I have not touched that file and at phpmyadmin I have: /* Select mysql if your server does not have mysqli */ $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['AllowNoPassword'] = false; this is related to mysql > Which PHP port are you using: php5, php53, php54, php55? > The ports related to php I have are: 13# port installed php5* The following ports are currently installed: php5 @5.3.26_0+apache2 (active) php5-gd @5.3.26_0 (active) php5-gdchart @0.2.0_0 (active) php5-mailparse @2.1.6_0 (active) php5-mbstring @5.3.26_0 (active) php5-mcrypt @5.3.26_0 (active) php5-mysql @5.3.26_0+mysqlnd (active) php5-openssl @5.3.26_0 (active) php5-zip @5.3.26_0 (active) php53 @5.3.26_0+libedit (active) php53-gd @5.3.26_0 (active) php53-gdchart @0.2.0_0 (active) php53-mailparse @2.1.6_1 (active) php53-mbstring @5.3.26_0 (active) php53-mcrypt @5.3.26_0 (active) php53-openssl @5.3.26_0 (active) php53-zip @5.3.26_0 (active) php54 @5.4.16_0+libedit (active) php54-apache2handler @5.4.16_0 (active) php54-gd @5.4.16_0 (active) php54-mbstring @5.4.16_0 (active) php54-mcrypt @5.4.16_0 (active) php54-mysql @5.4.16_0+mysqlnd (active) php54-zip @5.4.16_0 (active) > Which variant of the php5*-mysql port is installed? If mysqlnd, have you > followed the instructions, e.g.: > > php5-mysql @5.3.26_0+mysqlnd (active) php54-mysql @5.4.16_0+mysqlnd (active) > > $ port notes php54-mysql > php54-mysql has the following notes: > > To use mysqlnd with a local MySQL server, edit > /opt/local/etc/php54/php.ini and set mysql.default_socket, > mysqli.default_socket and pdo_mysql.default_socket to the path to your > MySQL server's socket file. > > For mysql5, use /opt/local/var/run/mysql5/mysqld.sock > For mysql51, use /opt/local/var/run/mysql51/mysqld.sock > For mysql55, use /opt/local/var/run/mysql55/mysqld.sock > For mariadb, use /opt/local/var/run/mariadb/mysqld.sock > For percona, use /opt/local/var/run/percona/mysqld.sock > > > I believe then I am using: mysql.default_socket=/opt/local/var/run/mysql5/mysqld.sock > > Similarly, I cannot access: > > > > localhost/phpinfo.php > > Why not? What happens? > Not Found! Despite the fact that the phpinfo.php file is there in: /opt/local/apache2/htdocs BUT if I comment out the statement: # Virtual hosts Include conf/extra/httpd-vhosts.conf inside httpd.conf then I can see phpinfo.php > > > If I turn conf/extra/httpd-vhosts.conf in the httpd.conf off I can now > see the display of localhost/phpinfo.php, > > What strange directives are in httpd-vhosts.conf that are causing that? > What I have found is that when I comment out the directive: # Various default settings Include conf/extra/httpd-default.conf inside httpd.conf Now everything EXCEPT being able to see phpinfo.php works. This is I can now see phpmyadmin and log into it correctly but phpinfo.php is not displayed correclty Inside httpd-vhosts.conf I have the following active: ####### NameVirtualHost *:80 Listen 80 <VirtualHost localhost 192.168.1.5 165.91.108.63 *:80> ServerAdmin [email protected] DocumentRoot "/opt/local/www/aramayolab" ServerName aramayolab.org ServerAlias www.aramayolab.org ErrorLog "/opt/local/www/aramayolab.logs/aramayolab.org.error.log" CustomLog "/opt/local/www/aramayolab.logs/aramayolab.org.access.log" common </VirtualHost> ###### Something tells me that I might be using different versions of php?? Thanks --R > > but still cannot log into phpmyadmin > > > > I tried re-installing phpmyadmin to no avail > >
_______________________________________________ macports-users mailing list [email protected] https://lists.macosforge.org/mailman/listinfo/macports-users
