Call-back icon  Questions? Contact our sales team to a request a quote

Magento

eCommerce Software for Online Growth

Magento Forum

   
Page 2 of 2
SQLSTATE[42000] [1044] Access denied for user ‘nstockc_magento’@’localhost’ to database ‘nstockc_db’ o Database connection error
 
blizzard182
Member
 
Avatar
Total Posts:  44
Joined:  2008-09-06
Argentina
 
brad_with_spincaster - 13 October 2008 11:18 AM

Hello all, thanks for the responses…

::blizzard::

Does your host have phpSuExec installed? Of you do, you shouldn’t modify your.htaccess to add the php settings.

Could you please post your php.ini? I posted something about this in the Wiki a couple of days ago. If you do have phpsuexec there is a workaround, but is the lack of the correct php version that worries me.

If you have a file called php.ini.sample, instead of php.ini in your root then copy that file with the name php.ini.

Then add these lines at the bottom:

extension=pdo.so
extension=pdo_mysql.so

Run the check again and let me know if that changes anything in the result.

Cheers

 Signature 

Disce Quasi Semper Victurus, Vive Quasi Cras Moritorus.

 
Magento Community Magento Community
Magento Community
Magento Community
 
brad_with_spincaster
Jr. Member
 
Total Posts:  10
Joined:  2008-10-07
Kelowna, BC
 

::blizzard::

Does your host have phpSuExec installed? Of you do, you shouldn’t modify your.htaccess to add the php settings.

Could you please post your php.ini? I posted something about this in the Wiki a couple of days ago. If you do have phpsuexec there is a workaround, but is the lack of the correct php version that worries me.

If you have a file called php.ini.sample, instead of php.ini in your root then copy that file with the name php.ini.

Then add these lines at the bottom:

extension=pdo.so
extension=pdo_mysql.so

Run the check again and let me know if that changes anything in the result.

Cheers

Nope, phpSuExec is not installed. Regarding the php.ini.sample file, this is in the magento sub-folder that was created upon installation. There is no php.ini file or anything like that in the root directory. I did however try copying the php.ini.sample file to just php.ini and added the scripts you indicated, but there were no changes.

 
Magento Community Magento Community
Magento Community
Magento Community
 
blizzard182
Member
 
Avatar
Total Posts:  44
Joined:  2008-09-06
Argentina
 
brad_with_spincaster - 13 October 2008 11:49 AM

::blizzard::


Nope, phpSuExec is not installed. Regarding the php.ini.sample file, this is in the magento sub-folder that was created upon installation. There is no php.ini file or anything like that in the root directory. I did however try copying the php.ini.sample file to just php.ini and added the scripts you indicated, but there were no changes.

Mmm...then I guess is all related to the PHP version. Although is funny how you get into the database screen although you don’t have the correct php version.

Try to open the check php file, and watch the line that checks for the php version. It’s a command line script (If I remember correctly).

Since you have access through SSH, try to run it with a root account or something like that. Maybe you do have the version but it’s not letting the user run the command.

This is just me shooting ideas, honestly I never had that problem.

 Signature 

Disce Quasi Semper Victurus, Vive Quasi Cras Moritorus.

 
Magento Community Magento Community
Magento Community
Magento Community
 
brad_with_spincaster
Jr. Member
 
Total Posts:  10
Joined:  2008-10-07
Kelowna, BC
 

Mmm...then I guess is all related to the PHP version. Although is funny how you get into the database screen although you don’t have the correct php version.

Try to open the check php file, and watch the line that checks for the php version. It’s a command line script (If I remember correctly).

Since you have access through SSH, try to run it with a root account or something like that. Maybe you do have the version but it’s not letting the user run the command.

This is just me shooting ideas, honestly I never had that problem.

No problem, these things can be quite confusing at times considering every persons setup is different.

To note though, I can’t access the database screen unless i modify the .htaccess file and point it to the php5-cgi. If i don’t do this, I get a warning saying my php version is to low.

I gather the check php file your talking about is the one you referred me to previousley (magento-check.php)? The line that checks the version is as follows: if(version_compare(phpversion(), ‘5.2.0’, ‘<’)), which it fails even though the php5-cgi is there.

Regarding the SSH suggestion, I don’t know how to do that. I was actually walked through using PuTTY by my server admin in order to get the installation to finish quickly rather than waiting 2 hours through FTP. I know the php version is 4.4.7 by looking at the the php info generated with “print phpinfo();”. This is being forced to 5.2 with the cgi script.

I starting to think this is happening due to a combination of things. (Just wish we could figuer out what those are… haha)

 
Magento Community Magento Community
Magento Community
Magento Community
 
blizzard182
Member
 
Avatar
Total Posts:  44
Joined:  2008-09-06
Argentina
 
brad_with_spincaster - 13 October 2008 12:11 PM

Mmm...then I guess is all related to the PHP version. Although is funny how you get into the database screen although you don’t have the correct php version.

Try to open the check php file, and watch the line that checks for the php version. It’s a command line script (If I remember correctly).

Since you have access through SSH, try to run it with a root account or something like that. Maybe you do have the version but it’s not letting the user run the command.

This is just me shooting ideas, honestly I never had that problem.

No problem, these things can be quite confusing at times considering every persons setup is different.

To note though, I can’t access the database screen unless i modify the .htaccess file and point it to the php5-cgi. If i don’t do this, I get a warning saying my php version is to low.

I gather the check php file your talking about is the one you referred me to previousley (magento-check.php)? The line that checks the version is as follows: if(version_compare(phpversion(), ‘5.2.0’, ‘<’)), which it fails even though the php5-cgi is there.

Regarding the SSH suggestion, I don’t know how to do that. I was actually walked through using PuTTY by my server admin in order to get the installation to finish quickly rather than waiting 2 hours through FTP. I know the php version is 4.4.7 by looking at the the php info generated with “print phpinfo();”. This is being forced to 5.2 with the cgi script.

I starting to think this is happening due to a combination of things. (Just wish we could figuer out what those are… haha)

I believe the cgi approach is when you don’t have enough privileges to access your php and modify the settings.

I am not sure is going to work unless you update your php version.

You might want to talk to a more experienced guy. If I were you, I would update the php.

 Signature 

Disce Quasi Semper Victurus, Vive Quasi Cras Moritorus.

 
Magento Community Magento Community
Magento Community
Magento Community
 
brad_with_spincaster
Jr. Member
 
Total Posts:  10
Joined:  2008-10-07
Kelowna, BC
 

I’m not sure if that’s even going to be possible. I’ll look into it, but from the sounds of things, Magento just isn’t going to work on our servers. Thanks for all your help. It has been greatly appreciated!

 
Magento Community Magento Community
Magento Community
Magento Community
 
blizzard182
Member
 
Avatar
Total Posts:  44
Joined:  2008-09-06
Argentina
 
brad_with_spincaster - 13 October 2008 01:00 PM

I’m not sure if that’s even going to be possible. I’ll look into it, but from the sounds of things, Magento just isn’t going to work on our servers. Thanks for all your help. It has been greatly appreciated!

Hey, no problem. I would still send a message to Varien just to ask them if that’s possible. It doesn’t count as support from where I see it, since you can buy support if the site doesn’t even run. If they want you to buy the paid support in the future then they should help you with that.

I sent them an email about the sizing of my project and they nicely answered me.

Good luck!

 Signature 

Disce Quasi Semper Victurus, Vive Quasi Cras Moritorus.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 2 of 2
 
© Copyright 2008 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service
Magento Community Count
60006 users|765 users currently online|118853 forum posts