General Support: Trying to install via GoDaddy

mster5,

I was just helping someone with a setup on GoDaddy. What is set in your 'plog-config.php' file for PLOGGER_DB_HOST (or I guess what you put in for MySQL host: during '_install.php')? I believe it should be something like:define("PLOGGER_DB_HOST","xxxmysqlxxx.secureserver.net");and not:define("PLOGGER_DB_HOST","localhost");

I would check that first to verify.

Are you using PHP4 or PHP5 in GoDaddy (I believe you can change it to run PHP5 via a CGI wrapper)?

I believe that means that your MySQL version is version 5.0. However, there are some problems with PHP4 trying to connect to newer MySQL servers (see here).
I would recommend upgrading to run PHP5 in GoDaddy (see here).

Please be warned that on the GoDaddy PHP5, the php.ini error_reporting is set very high and may cause some problems with using Plogger Beta 3.0 (the SVN version is almost completely notice- and undefined-index-free). You can stop this by adding the following line to the top of your 'plog-globals.php' file:error_reporting(E_ERROR);

I'm also using GoDaddy Hosting (Windows version) and having the same issue installing Plogger both on a MySQL 4.1 and 5.0 database. User ahawks in a different post had the same problem and seems to have come up with an answer, but I'm not sure how to get into the mysql.user table to make the changes he suggests. sidtheduck, have you had any success installing Plogger on a GoDaddy Windows setup? I found this entry in the help center stating IIS 7 on GoDaddy Windows setups supports PHP 5, but PHP support in IIS 6 has been deprecated. Perhaps I need to contact GoDaddy to ask them to upgrade me to IIS 7. I could also switch over to the Linux setup, but I'd prefer not to if I can find a workaround.

Thanks for your help!

Posted By: ahawksJust a follow up with some more info I've found.
According to the MySQL 5.0 manual, http://dev.mysql.com/doc/refman/5.0/en/old-client.html , the "Client does not support authentication protocol requested by server" message is because MySQL 4.1.1 and above use a different PASSWORD() encryption technique, so any old mysql libs will fail when they try to use the outdated PASSWORD() call.

Apparently, the solution is to either update your libmysql.dll / .so, or update the mysql.user table:
update mysql.user set password=OLD_PASSWORD('password') where user='your username';

I just installed Plogger on GoDaddy. I used a combination of information from above.
This is a Linux account. Might work for Windows? This is an older MySQL4. Might work for 5? I have PHP5. Might work with 4?

Using FileZilla I uploaded the files to my account.
I then had to go to the Hosting Manager for that account. I had to go to the Database Manager under that, click on MySql and click add a new Database.
Here you will specify your choice of MySQL 4 or 5, password, database name (I think this also your user name[for the database, not Plogger]), and password (for the database).
The only one of these that you can't easily pull up later is the DBPassword--but you could reset it.
It takes 5-10mins for the DataBase to install. You won't get an email.
If you are looking at the DB List, you will see Pending by the new Database and all others show SetUp.
If you refresh the screen and see SetUp, you are ready.

In a browser I went to http://INSTALL LOCATION/_install.php
This gave me the install screen requesting server, user name, password, database name, gallery name, email name.
Starting at the right of my list:
email: whatever you want it to be
gallery name: whatever you want it to be
DB Name: If you forgot what you called it, you'll have to go to hosting>database mgr> ...if you click on the (Open Manager)link it pulls up phpMyAdmin---not what you want.
Instead, strangely, click on the little pencil(edit)icon. It will pull up your DB Name, User Name, and Hosting Name.
There are also some little icons that could help you with the database in the future.
Password: The one you created earlier and wrote down, or change it with one of the little icons.
User name:pencil(edit)icon screen
Server:pencil(edit)icon screen

Great. You filled in 6 blanks. Push enter. You will get a couple of lnes of errors saying that it can't use the password or access the database.
To enable you to use Plogger, you can fix the issue this way:

Go to Filezilla, and download the 'plog-globals.php' to your desktop [sidtheduck explained this above. I'm merely amplifying this for slow folks like me. Coloring with my purple crayon --like Sybil if you will.]
Open the file with Notepad. Careful here if in Windows.
[Right click on the file.
Select Open With and Notepad.
If you don't have that option, Either select open and tell your computer that you want to find the program to open the file that Windows doesn't know how to open
Or Click on the file to open and tell your computer that you want to find the program to open the file that Windows doesn't know how to open]

You are now looking at the php file. Copy paste this line:

error_reporting(E_ERROR);

right at the top between the first 2 lines. Change this:
<?php
ini_set('include_path', ini_get('include_path'));

to:
<?php
error_reporting(E_ERROR);
ini_set('include_path', ini_get('include_path'));

You will now click File>Save As
On the Save As screen, be sure to click the Save as type: drop down box and change the selection from text to all files.
Otherwise, you won't be saving a php file, but a text file.
The name plog-globals is filled in.
If you are still in the same place that you downloaded, you will get a screen saying that plog-globals.php exists, replace? Yes.

Then upload the new file back to GoDaddy with Filezilla. Again, plog-globals.php exists, replace? Yes.

Go back to install screen. Enter the 6 and push enter. Installed! Yay!
Plogger gives you an admin name (admin) and password.
Write them down.

Once Installed:
http://INSTALL LOCATION/plogger/admin/index.php takes you to the groovy lookin blue-grren-gray plogger login screen asking for your login name and password.
Plogger assigned your password and gave you the name admin on setup. Changing the admin name is a good idea.
Logging in takes you to the admin setup pages.

http://INSTALL LOCATION/plogger takes you to the yucky looking black and white screen (if you haven't set it up) that is your actual gallery for the world to see--or you to use.

I don't think that there is a link from the black and white screen to the login screen so you will need to know the admin login address above.

Plogger is cool, light weight, and not verbose (like I was above).
It is easy to include in web pages just by copy pasting some code and it won't mess up your layout.
Better than the other galleries godaddy offers--in my humble opinion.

Enjoy. Please click the gray "thanks" logo to the right and send me a note if this helped you.
Not because I want a thankyou, but because I would like to know if anyone else in the world tries
to do such things as install Plogger on GoDaddy and finds these directions helpful.
Or it might just be me. Many thanks.