Questions on getting Xerte Toolkits installed on your server and questions about authentication and user logins.

Installation Issue

JohnSmith
Offline
Platinum Member

12 years 11 months ago #602 by JohnSmith

Replied by JohnSmith on topic Installation Issue

Hi,

No worries, always happy to help...

And is that the same username/password combo that you use for the other systems?

I'm not sure which part of the code is generating that error message but that page needs to attempt to drop database tables and create new ones. If that user doesn't have permissions then you might get that error. Can you check what permissions that user has assuming that the username/password/server address are all correct?

John

Please Log in or Create an account to join the conversation.

Bernie123
Topic Author
Offline
Junior Member

12 years 11 months ago #603 by Bernie123

Replied by Bernie123 on topic Installation Issue

No I created a separate sql-database for xerte :
scsltdco_xerte

Going through database.php

everything appears correct I can access the sql database using coy and paste from the information in database.php

I can go back and delete database.php if you like and try again

Please Log in or Create an account to join the conversation.

JohnSmith
Offline
Platinum Member

12 years 11 months ago - 12 years 11 months ago #604 by JohnSmith

Replied by JohnSmith on topic Installation Issue

Hi,

It is these lines of code that fails

Code:

    /*
     * Try to connect
     */

    $mysql_connect_id = @mysql_connect($xerte_toolkits_site->database_host, $xerte_toolkits_site->database_username, $xerte_toolkits_site->database_password);

    /*
     * Check for connection and error if failed
     */

    if (!$mysql_connect_id) {
        die("<h2>Xerte Online Toolkits</h2>
             <p><strong>Sorry, the system cannot connect to the database at present</strong></p>
             <p>This may be because the database server is offline, or this instance of Xerte has not been setup (see <a href='setup'>/setup</a>). </p>
             <p>The mysql error is <strong>" . mysql_error() . "</strong></p>");
    }

so there must be something amiss either in your database setup or in the username/password pair as

Code:

@mysql_connect($xerte_toolkits_site->database_host, $xerte_toolkits_site->database_username, $xerte_toolkits_site->database_password);

does nothing special... please recheck that you have the "hostname" in the correct var in database.php (host and not database name or table prefix). and double check your documentation that you don't need to prefix the username with domain/ or something...

John

Last edit: 12 years 11 months ago by JohnSmith. Reason: Meant hostname!!

Please Log in or Create an account to join the conversation.

JohnSmith
Offline
Platinum Member

12 years 11 months ago - 12 years 11 months ago #605 by JohnSmith

Replied by JohnSmith on topic Installation Issue

In fact scrap that... we know hostname is 'localhost'

Have you enabled that user to access from localhost? You need to have either 127.0.0.1 and/or localhost in the access table. Sometimes you need both... double check the permissions for the other database that you are accessing from a different app on that server...

John

Last edit: 12 years 11 months ago by JohnSmith.

Please Log in or Create an account to join the conversation.

JohnSmith
Offline
Platinum Member

12 years 11 months ago - 12 years 11 months ago #606 by JohnSmith

Replied by JohnSmith on topic Installation Issue

My XAMPP setup shows

Attachments:

Last edit: 12 years 11 months ago by JohnSmith.

Please Log in or Create an account to join the conversation.

Bernie123
Topic Author
Offline
Junior Member

12 years 11 months ago #607 by Bernie123

Replied by Bernie123 on topic Installation Issue

OK I added a new user to the database and gave full access

Tested again and got new error:

Sorry, the system cannot connect to the database at present. The mysql error is Access denied for user 'scsltdco_TESTUSE'@'localhost' to database 'scsltdco_xerte'

Installation Issue

Main Pages

Quick Links

Support

External resources