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

Installation Issue

JohnSmith
Offline
Platinum lid

Meer

12 jaren 11 maanden geleden #602 door JohnSmith

Beantwoord door JohnSmith in 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

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

Bernie123
Onderwerp Auteur
Offline
Junior lid

Meer

12 jaren 11 maanden geleden #603 door Bernie123

Beantwoord door Bernie123 in 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

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

JohnSmith
Offline
Platinum lid

Meer

12 jaren 11 maanden geleden - 12 jaren 11 maanden geleden #604 door JohnSmith

Beantwoord door JohnSmith in 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

Laatst bewerkt 12 jaren 11 maanden geleden door JohnSmith. Reden: Meant hostname!!

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

JohnSmith
Offline
Platinum lid

Meer

12 jaren 11 maanden geleden - 12 jaren 11 maanden geleden #605 door JohnSmith

Beantwoord door JohnSmith in 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

Laatst bewerkt 12 jaren 11 maanden geleden door JohnSmith.

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

JohnSmith
Offline
Platinum lid

Meer

12 jaren 11 maanden geleden - 12 jaren 11 maanden geleden #606 door JohnSmith

Beantwoord door JohnSmith in topic Installation Issue

My XAMPP setup shows

Bijlagen:

Laatst bewerkt 12 jaren 11 maanden geleden door JohnSmith.

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

Bernie123
Onderwerp Auteur
Offline
Junior lid

Meer

12 jaren 11 maanden geleden #607 door Bernie123

Beantwoord door Bernie123 in 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'

Graag Inloggen of een account aanmaken deelnemen aan het gesprek.

Tijd voor maken pagina: 0.144 seconden

Gemaakt door Kunena

Installation Issue

Main Pages

Quick Links

Support

External resources