TOPIC:

Hi Rolaine,

Not sure what is going on with this setup, if you go to hopeforstartups.org/xertetools/index.php you should get to the xerte welcome screen or at worst, get a Xerte error...

If I go there though I see this:



Which is definitely not Xerte related. Who is your host? And what other information can you give about the database setup?

I also see that you are using Moodle at hopeforstartups.org/ . Did you know that you can drop the whole xerte folder inside Moodle and use Moodle authentication instead of either guest, static or db? We'll need to sort out your database problems first though...

Can you post a link to the instructions that your host gives for using mysql? Or post them here (obliterate any personal details first - such as usernames/passwords but not hostname)

Regards

John

You can upload to Moodle but the content then becomes static and not re-editable without re-uploading...

Best thing I think is to solve your database problems and integrate with Moodle (as explained before)...

How does Moodle connect to the database? Can you look at the config files for Moodle to see how it defines the mysql hostname?

John

Hi,

Is this page relevant to you? Have you created another database to hold the xerte tables or are you piggybacking on the moodle database (with table prefix hopefully) or another shared database?

help.yahoo.com/l/us/yahoo/smallbusiness/.../mysql/mysql-04.html

I just barely found this help page at my host yahoo.

How can I access my database using PHP?

You can create custom PHP scripts to access your database. Below are a few lines of PHP code you can use to access your database.

<?php
$link = mysql_connect("mysql", "USERNAME", "PASSWORD");
mysql_select_db("DATABASE");

$query = "SELECT * FROM TABLE";
$result = mysql_query($query);

while ($line = mysql_fetch_array($result))
{
foreach ($line as $value)
{
print "$value\n";
}
}

mysql_close($link);
?>

Please note that you must replace USERNAME and PASSWORD with your database user name and password. You must also replace TABLE and DATABASE with the valid table and database names from your database. The address of the MySQL database server is simply mysql; it is not necessary to include a port number.

I would love to do everything from within moodle but haven't been able to figure out how to set that up. I have two different mysql databases, but both have only the table and field frameworks. My host has a centralized myPHPadmin panel for me where I can get into any mysql database. I was finally able to get moodle to install last week after creating two user accounts in each database - one using @localhost and one using @mysql. However, I couldn't get any lessons modules from xerte to upload correctly to moodle so that they could be viewed. I am the only instructor for my firm. I am under great pressure to get a client empowerment training for my partnering non-profit agencies' staff up and running. They still have large numbers of Hurricane Sandy victims who are still homeless. Mostly because the clients can't read English at even a 6th grade level and the vast majority of the ones still in trouble don't have any understanding of the local building codes and permit processes. I have a lot of governmental building inspectors looking to me to help them address this problem. The need for this training course is urgent.

"Did you know that you can drop the whole xerte folder inside Moodle and use Moodle authentication instead of either guest, static or db?"

would you mind pointing me to a link with instructions for how to do this? Thanks

Hi Rolaine,

We're happy to help you through things, every step of the way, just bear with us....

First of all, lets tackle the first problem... you don't seem to have the right details in database.php, can you edit that? From earlier you were getting -

It did show me what might be the problem. But I don't know how to fix it - apparently it tried to log me in as rolaine@localhost when it should be logging me in as Rolaine@mysql

This indicates that your database.php hostname is wrong! please change from localhost to mysql (as indicated by the Yahoo help page)...

Also, make sure that the username and password are correct for connecting to this database - you might want to use your admin panel to create a user/password pair SPECIFICALLY for xerte so that you can differentiate from other accounts... These details need to be in the database.php file also...

Please do that and then let me know what you get afterwards; for some reason the URL that you posted won't allow me to access...

John