I have a fully functioning version of CPG running on my Mac OS X server. I thought I should be able to install a second instance in a seperate directory, but I'm getting errors when I run the INSTALL.PHP file:
QuoteCould not create a mySQL connection, please check the SQL values entered
MySQL error was : Access denied for user: 'admin@localhost' (Using password: YES)
The installer found the ImageMagick 'convert' program in '/usr/local/bin/', however it can't be executed by the script.
You may consider using GD instead of ImageMagick.
Now, I just installed ImageMagick, hoping to try it out with this second instance of CPG. I read around on this forum and saw that someone recommended CHMODding the CONVERT executable to allow the web server permission to use it. Well it was already set for global exection, but I "sudo chmod 777 convert"ed it anyway. Still getting that error message.
I have no idea why the MySQL errors are coming up. I've gone so far as to create a new database with no tables, hoping that CPG would see the database and use it. I've tried every combination of including admin name and password or none, localhost with port or no declaration...Nothing seems to work.
And yet the original version of CPG is running just fine, and I knew even less about this stuff when I set that up a few weeks ago.
Does CPG only allow one instance of itself to run on a server?
You can have as many instances of CPG installed as you wish. I have 4 running on my own web-server. (Don't ask why I need 4 ;))
You would create your second instance of CPG exactly like you created your first. First create an empty mySQL database and setup a user and password within mySQL to access new database. Then upload CPG and follow the directions about CHMODing the specific directories that needs to be modified. The error you got implies that you are using a bad user/pass combination to access the database. Make sure you supply the exact user/pass info to CPG when running install.php as you used when setting up the database itself.
With ImageMagick, you may need to modify your apache.conf file to allow your webserver to access the /usr/local/bin/ directory. By CHMODing the binary you gave global execution rights, however apache may be restricted from accessing that directory.
Hope this helps,
--OmegaGOD
If you have more than one, make sure your cookie names are different.
Thanks for the information.
I figured out what the problem was with the MySQL error.
I was using my Darwin administrator's username instead of "root" on the install.php page.
I already removed Image Magick, so I'm not going to worry about that just yet.
And sorry about not posting this in the "Installation" forum. I didn't realize that I was put back into the Standalone Support parent forum after registering.