Supporting each other

Community forums

Welcome, Guest
Username: Password: Remember me
Questions on getting Xerte Toolkits installed on your server and questions about authentication and user logins.

TOPIC:

Installation Issue 11 years 3 months ago #602

  • JohnSmith
  • JohnSmith's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 397
  • Thank you received: 71
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.

Installation Issue 11 years 3 months ago #603

  • Bernie123
  • Bernie123's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 36
  • Thank you received: 0
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.

Installation Issue 11 years 3 months ago #604

  • JohnSmith
  • JohnSmith's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 397
  • Thank you received: 71
Hi,

It is these lines of code that fails
    /*
     * 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
@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

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

Last edit: by JohnSmith. Reason: Meant hostname!!

Installation Issue 11 years 3 months ago #605

  • JohnSmith
  • JohnSmith's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 397
  • Thank you received: 71
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

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

Last edit: by JohnSmith.

Installation Issue 11 years 3 months ago #606

  • JohnSmith
  • JohnSmith's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 397
  • Thank you received: 71
My XAMPP setup shows



Attachments:

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

Last edit: by JohnSmith.

Installation Issue 11 years 3 months ago #607

  • Bernie123
  • Bernie123's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 36
  • Thank you received: 0
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'

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

Time to create page: 0.143 seconds
Copyright © 2024 The Xerte Project.
Xerte logo Apereo logo OSI Logo

Search