Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ryan Schmidt
On Jul 28, 2010, at 22:53, Ali A Samii wrote: Yes, I finally was able to get MySQL to run. I queried to see what mysql processes were running, and I got the following line: alis-imac:tmp ali$ ps auxw | grep mysql root 2022 0.0 0.0 2445728572 ?? Ss7:04PM 0:00.14

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
Hi Scott: Since I couldn't get things to work for me last night (I'm in Paris, France) and I had been up to almost 6 AM to get things to work, I gave up for the night (or I should say the morning) and went to get some sleep. Anyway, I just got your email with the tutorial, and I am going to do

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Scott Haneda
Ok, now I am completely confused. Are there two people having near identical issues with Macports and Mysql? My emails to the list will probably sound a bit confusing as I am treating this as one person. Ugh, sleep, I am on my way :) Sorry about the confusion. I have pulled the files of my

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
Hi Scott: I successfully installed MySQL as step 1 of your tutorial. I also successfully installed Apache as in your tutorial, but, I seem to have some problems because my httpd.conf edits (to enable the Apache manual, for example) have no effect. Of course, I saved the http.conf file and

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
Scott, your tutorial rocks!!! Smooth sailing, every step of the way. One question however, that I can't seem to solve. I changed the default 'blowfish_secret' to something else, but loading phpmyadmin still gives me the following error: The configuration file now needs a secret

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
Well, I thought everything went smoothly until I imported a Joomla site. Result was a whole long list of errors, so I decided to try a clean install of joomla 1.5.20. Everything went smoothly until I got to Install Sample Data. At that point, I got the following Error: the XML response that

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
OK, I solved those errors. I had to move from the development to the production version of php.ini But now I have another problem. I can't load the root level of the /opt/local/www In my /etc/hosts, I have defined 3 virtual domains: 127.0.0.1 pma 127.0.0.1 dev.thesamiis.com

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Jasper Frumau
On Thu, Jul 29, 2010 at 8:15 PM, Ali A Samii sa...@me.com wrote: OK, I solved those errors. I had to move from the development to the production version of php.ini But now I have another problem. I can't load the root level of the /opt/local/www In my /etc/hosts, I have defined 3 virtual

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
On 29 Jul, 2010, at 18:19 , Jasper Frumau wrote: On Thu, Jul 29, 2010 at 8:15 PM, Ali A Samii sa...@me.com wrote: OK, I solved those errors. I had to move from the development to the production version of php.ini But now I have another problem. I can't load the root level of the

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Jasper Frumau
On Thu, Jul 29, 2010 at 8:27 PM, Ali A Samii sa...@me.com wrote: On 29 Jul, 2010, at 18:19 , Jasper Frumau wrote: On Thu, Jul 29, 2010 at 8:15 PM, Ali A Samii sa...@me.com wrote: OK, I solved those errors. I had to move from the development to the production version of php.ini But now

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Jasper Frumau
Why don't you just drop the virtual hosts for now and use a standard config, finish the job and the return to the subject? Other option is to open Ubuntu in a virtual box, install LAMP using taksel and finish the project and then solve the MacPorts MAMP issue. I have one Ubuntu LAMP virtual box on

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
On 29 Jul, 2010, at 18:35 , Jasper Frumau wrote: On Thu, Jul 29, 2010 at 8:27 PM, Ali A Samii sa...@me.com wrote: On 29 Jul, 2010, at 18:19 , Jasper Frumau wrote: On Thu, Jul 29, 2010 at 8:15 PM, Ali A Samii sa...@me.com wrote: OK, I solved those errors. I had to move from the

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
Thank you Ryan, that solved that. Couple of small remaining issues left. 1. Connection for controluser as defined in your configuration failed! 2. The additional features for working with linked tables have been deactivated. To find out why click here. Clicking here gives me not OK

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
On 29 Jul, 2010, at 20:03 , Scott Haneda wrote: On Jul 29, 2010, at 9:44 AM, Ali A Samii wrote: If I set pma to /opt/local/www, that defeats the purpose of the virtualhost. What I assume it is supposed to be able to do (and does with the other two virtual hosts I have defined) is that I

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
And re #3 below? On 29 Jul, 2010, at 20:40 , Ryan Schmidt wrote: On Jul 29, 2010, at 13:15, Ali A Samii wrote: Couple of small remaining issues left. 1. Connection for controluser as defined in your configuration failed! 2. The additional features for working with linked tables have

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Ali A Samii
Thanks Ryan. Just vt adding ServerName localhost to httpd.conf, that solved the warning. True that it made no difference and I could still point to http://localhost/ and it would go to the right place, but it's all a matter of a clean install, isn't it! So, keeping up with the clean install

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-29 Thread Scott Haneda
On Jul 29, 2010, at 11:31 AM, Ali A Samii wrote: On 29 Jul, 2010, at 20:03 , Scott Haneda wrote: On Jul 29, 2010, at 9:44 AM, Ali A Samii wrote: For your example: /opt/local/apache2/conf/extra/vhosts/dev.thesamiis.com.conf /opt/local/apache2/conf/extra/vhosts/phpmyadmin.conf

Re: Apache and MySQL won't start

2010-07-28 Thread Ryan Schmidt
On Jul 28, 2010, at 11:34, Ali A Samii wrote: OK, so stopped apache2, sudo port load apache2 This is what echoed back: sudo port load apache2 Error: Target org.macports.load returned: org.macports.apache2: Already loaded Log for apache2 is at:

Re: Apache and MySQL won't start

2010-07-28 Thread Ali A Samii
unload and reload worked, thanks I issued the following command to install mysqk5 sudo port install mysql5 +server Well, I agree that using /tmp is a potential security risk, but I was attempting to see if I could get mysql to run...I can't On 28 Jul, 2010, at 18:51 , Ryan Schmidt wrote:

Re: Apache and MySQL won't start

2010-07-28 Thread Ryan Schmidt
On Jul 28, 2010, at 11:58, Ali A Samii wrote: I issued the following command to install mysqk5 sudo port install mysql5 +server The mysql5 does not have a variant called +server. It used to, years ago, but now, you should install the separate mysql5-server port. sudo port install

Re: Apache and MySQL won't start

2010-07-28 Thread Ali A Samii
OK, issued that command. Took all of 2 seconds to execute. Then I issued sudo port load mysql5-server No problems Then I tried sudo -u _mysql mysql_install_db5 This is the echo: Installing MySQL system tables... 100728 19:04:58 [Warning] Can't create test file

Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-28 Thread Ali A Samii
Well, I have restarted the whole thing and I have gotten as far as getting mysql to install and be able to automatically generate the initial database. However, I still cannot change the password. I get the following Error: alis-imac:bin ali$ /opt/local/lib/mysql5/bin/mysqladmin -u root

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-28 Thread Scott Webster
On Wed, Jul 28, 2010 at 6:46 PM, Ali A Samii sa...@me.com wrote: Well, I have restarted the whole thing and I have gotten as far as getting mysql to install and be able to automatically generate the initial database. However, I still cannot change the password. I get the following Error:

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-28 Thread Ali A Samii
Yes, I finally was able to get MySQL to run. I queried to see what mysql processes were running, and I got the following line: alis-imac:tmp ali$ ps auxw | grep mysql root 2022 0.0 0.0 2445728572 ?? Ss7:04PM 0:00.14 /opt/local/bin/daemondo --label=mysql5 --start-cmd

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-28 Thread Scott Haneda
On Jul 28, 2010, at 6:46 PM, Ali A Samii wrote: However, I still cannot change the password. I get the following Error: alis-imac:bin ali$ /opt/local/lib/mysql5/bin/mysqladmin -u root password 'golijoon' /opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost' failed

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-28 Thread Jasper Frumau
I wrote up a mini tutorial, which I reference when I do new installs, and it tends to get me through it. There are some errors, obvious ones, where I forgot to sudo or other syntactical issues. http://dl.dropbox.com/u/340087/drops/01.04.10/mamp/MAMP%20Tutorial.html I will yank those

Re: Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

2010-07-28 Thread Scott Haneda
On Jul 28, 2010, at 10:33 PM, Jasper Frumau wrote: Tutorial is looking really good! Not that short either! Did not change Apache config to put all in www nor did I setup pma just yet. Considering both now.. Well, your urgency was MySql, so I figured you would just concentrate on that, making