New Installation

[vampyr07au]

I am creating a new installation of OsCommerce via my webhosts fantastico and when I click finish I get the following errors:

 

Install OS Commerce (3/3)

 

1) File: /home/paradise/public_html/public_html/includes/configure.php [ERROR! ]

2) File: /home/paradise/public_html/public_html/admin/includes/configure.php [ERROR! ]

3) File: /home/paradise/public_html/public_html/includes/languages/english.php [ERROR! ]

4) File: /home/paradise/public_html/public_html/includes/languages/espanol.php [ERROR! ]

5) File: /home/paradise/public_html/public_html/includes/languages/german.php [ERROR! ]

6) File: /home/paradise/public_html/public_html/admin/includes/languages/english.php [ERROR! ]

7) File: /home/paradise/public_html/public_html/admin/includes/languages/espanol.php [ERROR! ]

8) File: /home/paradise/public_html/public_html/admin/includes/languages/german.php [ERROR! ]

9) File: /home/paradise/public_html/public_html/data.sql [ERROR! ]

 

 

 

Can anyone help ?

[Guest]

Mick,

 

Check with your hosting provider since you are installing their version of OSC on their server.

 

 

 

 

Chris

[vampyr07au]

They state in their installation section that they offer NO support for it.

 

Having said that I have just removed it all anyway and have now uploaded the downloadable package from here onto the host and am now trying to figure out how to get that working lol.

[♥geoffreywalton]

Once you have unpacked it use a browser to navigate to the install directory and away you go.

 

Some usefull info can be found in my profile.

 

HTH

 

G

[♥geoffreywalton]

Try this link.

 

http://www.oscommerce.info/confluence/display/OSCDOC22/Requirements

 

HTH

 

G

[vampyr07au]

OK I went to the install page and attempted to start the installation.

Entered details for database as requested and when I clicked continue I get the following error:

 

There was a problem connecting to the database server. The following error had occured:

Access denied for user 'paradise_osc1'@'localhost' (using password: YES)

Please verify the connection parameters and try again.

 

anyone know what could be causing this ?

[vampyr07au]

well this is fantastic .... NOT ....

 

I managed to get the connecting to database issue sorted out and completed the full install of the latest oscommerce release only to find that it is running the deprecated code that I had originally been suffering with and had been trying to avoid.

 

I was under the impression that the latest release of osc was php5.3 compatible .... I only have files from the latest download of osc (nothing from outside that download) and I now have a page full of deprecated eregi functions AGAIN !!

among other things wrong with it of course.

there are also date code errors and such.

 

I am so incredibly annoyed right now because I don't know what else to do.

[MrPhil]

If you installed 2.2 RC2a (the last release), it is not PHP 5.3 ready. You will need to either install the add-on for PHP 5.3 fixes, or fix them manually. osC 2.3, if and when it ever comes out, is supposed to be PHP 5.3 ready. You were evidently under the mistaken impression that the current downloadable offering is osC 2.3 -- it's not.

[jimbo2907]

OK I went to the install page and attempted to start the installation.

Entered details for database as requested and when I clicked continue I get the following error:

 

There was a problem connecting to the database server. The following error had occured:

Access denied for user 'paradise_osc1'@'localhost' (using password: YES)

Please verify the connection parameters and try again.

 

anyone know what could be causing this ?

[jimbo2907]

sorry about that....I have the same problem as Vampyr07.

I have now spent 7 hours trying to connect to the database server. I have created a number of db's...but for each one includin 'root' I get "access denied for user......"

I have searched everywhere for a solution. Can anyone help please?

[MrPhil]

Next time, please start a new thread rather than hijacking an old one for a different problem.

 

The error message indicates that your defined database user is unable to sign on to the MySQL server. It could be that you failed to define the user and associate it with the database, or you have the wrong format of the user or database name, or you have the wrong password, or you have the wrong server name. If you can't figure it out, you'll need to work with your hosting service to see what went wrong. Don't forget to update both configue.php files with the correct database access settings.

[jimbo2907]

Next time, please start a new thread rather than hijacking an old one for a different problem.

 

The error message indicates that your defined database user is unable to sign on to the MySQL server. It could be that you failed to define the user and associate it with the database, or you have the wrong format of the user or database name, or you have the wrong password, or you have the wrong server name. If you can't figure it out, you'll need to work with your hosting service to see what went wrong. Don't forget to update both configue.php files with the correct database access settings.

 

Thank you for your response Mr Phil.

 

"failed to define the user and associate it with the database" : Using phpMyAdmin I am now looking at the page that says "Users having access to "newdb' - jim l localhost l global l all privileges l Yes l

 

"or you have the wrong format of the user or database name, or you have the wrong password, or you have the wrong server name" : Nope none of those.

 

"you'll need to work with your hosting service to see what went wrong" : There must be something simple that I have overlooked.

 

"Don't forget to update both configue.php files with the correct database access settings." : Isn't this only for security reasons?

[MrPhil]

"failed to define the user and associate it with the database" : Using phpMyAdmin I am now looking at the page that says "Users having access to "newdb' - jim l localhost l global l all privileges l Yes l

On most MySQL servers, you need to define a "user" (with password) and "associate it" with the database. This is the user that is doing the actual access for database operations (not the signed on customer or administrator), and needs sufficient permissions (usually ALL) to do all the database operations required by osC. This has nothing to do with being able to look around in phpMyAdmin, except that it might also be the place where you do the user setup (it varies by host).

 

"or you have the wrong format of the user or database name, or you have the wrong password, or you have the wrong server name" : Nope none of those.

Different hosting setups have different requirements. For example, with my hosting service I have to prepend my account name to the user name and database name: MYACCOUNTNAME_dbusername, MYACCOUNTNAME_dbname. For the server name, depending on which set of servers my account is on, it would be localhost or the actual server+domain name.

 

"you'll need to work with your hosting service to see what went wrong" : There must be something simple that I have overlooked.

My point is that you can't simply slap in names and settings haphazardly. You need to understand just what your hosting service is looking for for various settings. They should have told you the proper formats, etc., in some kind of information file or email they gave you when you signed up. If you're sure you're following everything to the letter, you will need to ask their Tech Support what's going on.

 

"Don't forget to update both configue.php files with the correct database access settings." : Isn't this only for security reasons?

What? Both configure.php files contain the database access information: user name, password, database name, server name. They must match, and be correct for your account, and be in the correct format. It's the information that your osC application uses to talk to the database.