Hello All,
firstly I'm really sorry that I have to post and ask this, I'm sure this is a really basic question but I have spent hours trying to figure this out.
When I try to go to my Zenphoto page to initially run the 1st set-up, I am getting the error:
MySQL Error: Zenphoto received the error Access denied for user 'celynco1'@'localhost' (using password: NO) when connecting to the database server.
No I am pretty sure that this is all to do with the fact that I haven't assigned a MySQL database anywhere within any of the PHP files etc, but at the same time I cant see where I need to assign these, I have created a MySQL database ready for ZenPhoto.
Again any help would be greatly appreciated and sorry
Zenphoto
Comments
Also the error says that your MySQl user account does not have the needed rights for Zenphoto. Either because the assumed wrong database server name or else.
I suggest to contact your host.
The above error is normal if you have not provided the correct relevant information. There should also be a form for you to fill in with the details. As to the details, you will have to consult your service provider as it will be specific to them. Most likely, though, the database host is not correct. The default "localhost" works for personal installations but not for many shared hosts. What you need is the "host name" for the server where MySQL is hosted by your provider.
1. go into your ZenPhoto install directory, and find a folder called `zp-core`
2. find a file called `zp-config.php`. If only one file exists called `zp-config.php.source`, download it and re-upload it as called `zp-config.php`
3. edit the file, filling in your own information in the following on lines 29-32. For the sake of example, I'll assume the database is called "mydb", the database user is "celynco1" and your password is "mypass":
`
$conf['mysql_user'] = 'celynco1'; // Supply your MySQL user id.
$conf['mysql_pass'] = 'mypass'; // Supply your MySQL password.
$conf['mysql_host'] = 'localhost'; // Supply the name of your MySQL server.
$conf['mysql_database'] = 'mydb'; // Supply the name of Zenphoto's database
`
Hopefully that helps, and if not, then it may be a different problem (such as the databases not being located on 'localhost') which may be specific to whoever is your webhost, as mentioned above.
I am getting the same error message but I simply don't understand your replies. I built my web site using Dreamweaver and html. I've never used PHP and know nothing about MySQL or server side technology. My domain is hosted by a private firm called Tiger computing. Are you saying I have to ask him to sort this problem out for me or is there something I need to do? I don't know how to create a MySQL database and assumed that once I had uploaded the files it would be a simple matter of following the instructions on-line.
Your host will provide a kind of backend interface where you create a database. Ask your host.
On first time installs it is not enought to modify the zp-config.php (which of course needs to be move to /zp-data afterwards).
Again, ask your host on how to create a database and aks him to do it for your. Also aks for the credentials to access that database. Without that Zenphoto will not work anyway.
I have been given the User name, Server name, database name and password by my host. If the database name he supplied is the one that is required for the zenphoto database fine, I can put that in, but when I did I got all sorts of error messages about missing files so I assumed that was not correct. Believe me, if I try to print the error page it want to take up 5 sides of A4! I'm really out of my depth here. If you are saying there is nothing missing in the zip file I downloaded then why can't I find and run this set-up utility?
The setup utility will be executed automatically when you try to visit your Zenphoto site that is not fully installed. The URL is where you have put the files. It is all explained on our installation page actually.
When I try to visit my Zenphoto site is when I get all these error messages.
Very often these scripts do not work (as maybe you are experiencing) and because we know nothing of their workings we are not in a positon to help you out of the problems they might create.
I do know that if they work they are a god send for inexperienced users since they take care of the things that are causing you problems. But as I said, we cannot help if they go wrong.
For the troubleshooting: http://www.zenphoto.org/news/troubleshooting-guide
See under "installation" point 11.
The "simplest" refers mainly to using of Zenphoto. (If you have specific needs regarding front end design or functionality it does again require some work naturally)
There are professionals in this web stuff area for a reason (for the same reason I can't fly any aircraft..).
BTW; it is point 3 "Permissions for Zenphoto files and folders" (not sure how I came to 11..)
I have populated my zp-config.php file with details from my host and have set permissions to 777 throughout.
What should I do?