Can't get to my databases?! ARGH!!

[Betty Ann]

Hi everyone; I really need some help here! I've been trying to create a fanlisting on my website using either the Enthusiast script or the PHPFanlisting script. If you're not familiar with those, they're basically just scripts you run on your webpage to allow you to access your databases and create fanlistings.

I've used them before, and they worked FINE. Now, after the migration, I can't seem to install them!! When I try to login to the database, it won't connect me; it acts like I didn't enter a password. All of the permissions are correct, and the scripts themselves are perfect. I actually emailed back and forth with the creater of one of the scripts for about a week, trying to come up with different solutions, and nothing worked.

I'm about 99.999% it's a problem with the databases, so it won't let me connect through a script (it acts like I didn't enter a password). PLEASE help me... I've been trying to get this to work for about two weeks now, and it just has to be the databases, but I have no idea what to do!!

[KHSjr1970]

sessions problem ? maybe ?
have you created a sessions folder, and adjusted your php.ini file to put sessions created by php in the newly created sessions folder ?

[Betty Ann]

sessions problem ? maybe ?
have you created a sessions folder, and adjusted your php.ini file to put sessions created by php in the newly created sessions folder ?

Actually, no, I have not. How might I go about doing that? Thank you for the wonderful tip :)

[mitchind]

In your member ops control panel

1. find the path to your website...
2. Create the 'phpsession' folder at root
3. Under CGI, edit the php.ini file session path to match your path ... something like
"session.save_path = /home/users/web/userid/pow.mysite/phpsessions"

[KHSjr1970]

exactly what mitch stated. thx mitch!

[Betty Ann]

I can't find a php.ini file anywhere!! How do I create one, where do I put it, and what do I put in it to make this work? I am getting extremely frustrated :\

[mitchind]

Directions found in the ReadMe First at the top of the forum.

You need to go to your Control Panel - CGI

[Edit]
You're right - it's very difficult to find - I had to go back to Overview, then click on New Control Panel, then PHP Scripts

This might take you there directly:
http://members.powweb.com/member/cgiManagement/PHPplus.bml

[Betty Ann]

Directions found in the ReadMe First at the top of the forum.

You need to go to your Control Panel - CGI

[Edit]
You're right - it's very difficult to find - I had to go back to Overview, then click on New Control Panel, then PHP Scripts

This might take you there directly:
http://members.powweb.com/member/cgiManagement/PHPplus.bml


I still don't know where to upload the php.ini file after I created it (and changed the session path). I uploaded it to the main folder (above htdocs) AND to the cgi-bin folder. But I still can't access my databases this way... I have the same problem. It acts like I didn't type in any password at all? It works fine with my older scripts, just not the newly-installed ones.

[mitchind]

You don't upload it anywhere. Delete it from your htdocs - or at least rename it.

[Betty Ann]

ok, I figured it out and I did that, but I'm still having the exact same problem with the databases... any more ideas?

[mitchind]

Did what?

What does your session.save_path say now?
Did you already create the sessions folder yourself?
Is your script creating files in there?

[Betty Ann]

1. the session.save_path has the path to my phpsessions folder.
2. yes, I already created the phpsessions folder.
3. I don't know how to tell if files are being created there by the script, but files ARE being created there.

[mitchind]

Can you check your PHP.ini file again to see if register_globals are on/off? Also see if there's a semi-colon ";" before that setting.

[Betty Ann]

Can you check your PHP.ini file again to see if register_globals are on/off? Also see if there's a semi-colon ";" before that setting.

They are ON, and it looks like this (no semi-colon):
register_globals = On

[Betty Ann]

Can anybody help me? Please?

[mitchind]

Where do you define your database settings in the software? What are they?

Have you tried to login to your database manually to make sure you're using the correct login and server?

What is your Error setting in the php.ini?

[Betty Ann]

Where do you define your database settings in the software? What are they?
There is a file called config.inc.php where settings are defined. I have it filled out correctly on my site. It looks like this:
<?php
// Database data
$db_user = 'user'; // Database User
$db_pass = 'pw'; // Password for Database User
$db_host = 'host; // Host where database is located, often 'localhost'
$db_name = 'name'; // Name of the database
$table_name = 'table'; // Name of the table
?>

Have you tried to login to your database manually to make sure you're using the correct login and server?
Yes, I can log in fine manually.

What is your Error setting in the php.ini?
I don't know what the error setting is or how to find it... like I said, I'm not very familiar with php.ini

[mitchind]

You don't give out much information from your config file so it's hard to help you to check if info is correct. You must assume it is I guess?

but db_host - must be mysql##.powweb.com not localhost

Check error logs in your Control Panel under Site Tools | CGI error Logs

[Betty Ann]

You don't give out much information from your config file so it's hard to help you to check if info is correct. You must assume it is I guess?

but db_host - must be mysql##.powweb.com not localhost

Check error logs in your Control Panel under Site Tools | CGI error Logs

That's ALL that's in the config file, so I can't give more information than that. I have it all filled out correctly, and yes, I know that it should be mysql15.powweb.com (that's where the database is located). Everything in my actual config file is correct. I don't know what else I can give you beyond that; I'm not planning to post my actual username and password here. Like I said, I've set this up before (and have the same thing running elsewhere on my site using a different database), and I know that that part is correct.

This is the ONLY error I have in my CGI error logs:

PHP Warning: Zend Optimizer does not support this version of PHP - please upgrade to the latest version of Zend Optimizer in Unknown on line 0

[mitchind]

I wasn't asking for your username/password - but you didn't supply any filled in variables - database, server or tablename - so it's easy to assume it's NOT filled in correctly.

You don't give sample URLs, code or folder or ini settings, so anyone that wants to help is forced to resort to complete guesswork. That tends to lengthen the troubleshooting period as well as exasperate the well-intentioned.

You never mentioned that you have the same software running on your site in a different folder before. What's the difference between the two? Do you have a .htaccess file in one folder and not the other? Are you using a subdomain?

The guesswork continues....

[Betty Ann]

I wasn't asking for your username/password - but you didn't supply any filled in variables - database, server or tablename - so it's easy to assume it's NOT filled in correctly.

You don't give sample URLs, code or folder or ini settings, so anyone that wants to help is forced to resort to complete guesswork. That tends to lengthen the troubleshooting period as well as exasperate the well-intentioned.

You never mentioned that you have the same software running on your site in a different folder before. What's the difference between the two? Do you have a .htaccess file in one folder and not the other? Are you using a subdomain?

The guesswork continues....

I don't know what information you need if you don't tell me...

I have the SAME script running at these two addresses:

http://soul-hunter.com/animamates
http://soul-hunter.com/guardian

I am trying to get it to run at http://soul-hunter.com/papillon (there is nothing there yet but the script, no HTML or anything). There is no .htaccess file in either of the other folders, nor is there one in the new folder. The ONLY difference is that I am trying to INSTALL it in the papillon folder, and it is already installed (and went through migration) in the other two folders. None of these are subdomains... just folders.

The script itself is 100% perfect. I installed the SAME THING on another website (different host) about a week after I initially tried it here on powweb, and it worked fine. It is a VERY popular script that a lot of people use, and it works for them. Not only that, but I also emailed back and forth with the script's creator for about two weeks, and he couldn't find anything wrong. The only thing that he OR I can figure is that it must be somehow related to powweb.

I am not toally familiar with ini settings or anything like that, so I can't give information about that. All I know that it was set to default, and the only things I changed were already mentioned in this folder.

What else do you want? I can give you as much information as you need (if I know how), but I don't know what you need to know if you don't tell me.

[mitchind]

Well .. that's a much better start .. some URLs to work with and a link from your site to the source website.


Database name: animamates
phpFanList table name: papillon

Connection with database-server: OK.

Connecting to DB: OK.

There already is a table named "papillon".

To continue with the install, click upgrade.

This would have confirmed that your db settings were fine.

You must have been getting an error message that "password was incorrect..." - something you never mentioned before.

I was able to login as admin and create an entry for myself.

What URL gives you the error message? As far as I can see it's working fine.

[mitchind]

Once you login make sure to click on Settings and change the password for Admin to the one you think it is right now.

[Betty Ann]

how... what... ? I'm so confused. This did NOT work as late as yesterday, and now it suddenly works. I haven't changed ANYTHING, and I can't understand why it would suddenly work now, when it hasn't before. Now I'm totally confused! At one point, I even gave the script's creator FTP access to try to experiment with it, and even he couldn't get it working. So unless he logged in and changed something recently, I dont' know why it would just suddenly work like that.

I wasn't getting any kind of "password incorrect" message... I tried to login, and it always redirected me back to the login page with no message or explanation. I have the same problem with a completely different script which is still going on, so I'll just ignore that one since I have this one working now for whatever mysterious reason.

So thank you for discovering that it randomly works today? I'm still really confused... I don't understand why it suddenly works fine (it works for me, too!)

anyway, I appreciate your help with my problem.

[mitchind]

No problem. Glad you're up and running.