<HTML dir=ltr><HEAD><TITLE>RE: [Xerte] walkthrough for installing toolkits</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6001.18226" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText39453 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Got to type fast so I beat Ron...... d'oh :)</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>The first line should be the host - usually local host, or the name of the mysql server you are using. If you leave it blank I am not sure what happens.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>I am not sure if your siteground login is the same user ID as for the database. From my experience of website packages you have to make your own accounts on the mysql server. Can you see the user table in the mysql database - that should have your accounts in.</FONT></DIV></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>If you create the database you'll need to give your account rights to use it, and then also flush priveleges.</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>The access denied messages are to indicate the installation of the last table has failed. I'll need to change that as I figured it was explicit. It might only fail on one or two things (and to be fair if it fails it means the system won't work - since we got round the magic quotes thing).</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>I am guessing that the user you created was for the database as well? Does that account have insert rights? To all tables?</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>If you're not sure something like</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Select * from mysql.user </DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>should work</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Could you post up the content of your site_root/database.php - leave out the password obviously.<BR></DIV>
<DIV dir=ltr>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B>From:</B> xerte-bounces@lists.nottingham.ac.uk on behalf of jventola@verizon.net<BR><B>Sent:</B> Wed 20/05/2009 18:25<BR><B>To:</B> Xerte discussion list<BR><B>Subject:</B> RE: [Xerte] walkthrough for installing toolkits<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>I actually managed to install it, but when I navigate to the site, all I see is the numeral 1 in<BR>upper left.<BR><BR>What I did was to take the advice to create a database in the cpanel. <BR><BR>On the "MySQL Database Creation page" of setup, I<BR>left first line blank, used my normal login for siteground and entered the new database name<BR>but left the prefix blank.<BR><BR>That seemed to work. I created a user account on the next screen. Then I hit Submit Query<BR>at the bottom and got a lot of text with a lot of access denied for user messages. Still, at the<BR>bottom it says the Installation is complete and provides a link to my toolkits site.<BR><BR>But, as I say, the page is empty except for one digit.<BR><BR><BR><BR>Date sent: Wed, 20 May 2009 08:50:33 +0100<BR>From: Patrick Lockley <Patrick.Lockley@nottingham.ac.uk><BR>Subject: RE: [Xerte] walkthrough for installing toolkits<BR>To: "Xerte discussion list" <xerte@lists.nottingham.ac.uk><BR>Send reply to: Xerte discussion list <xerte@lists.nottingham.ac.uk><BR><BR>> What errors do you get?<BR>><BR>> -----Original Message-----<BR>> From: xerte-bounces@lists.nottingham.ac.uk<BR>> [<A href="mailto:xerte-bounces@lists.nottingham.ac.uk">mailto:xerte-bounces@lists.nottingham.ac.uk</A>] On Behalf Of<BR>> jventola@verizon.net<BR>> Sent: 20 May 2009 02:13<BR>> To: xerte@lists.nottingham.ac.uk<BR>> Subject: [Xerte] walkthrough for installing toolkits<BR>><BR>> I have a hosted account (on Siteground) and would like to install<BR>> Xerte toolkit. (I've managed moodle and drupal). I am getting errors<BR>> about setting up the database when I run Setup. I am a tad beyond<BR>> total newbie status when it comes to mysql and php. (Siteground has<BR>> easy installers for the packages it supports.)<BR>><BR>> Does anyone know of a walkthrough tutorial that might make it possible<BR>> for me to install this? I've found information about installing on<BR>> XAMP but not on a hosted account.<BR>><BR>> BTW, I did at least check that the file permissions on the folders<BR>> mentioned in Setup were ok. But I could not find the Loaed<BR>> Configuration File's path as given in PHP Info using Filezilla. <BR>><BR>><BR>> _______________________________________________<BR>> Xerte mailing list<BR>> Xerte@lists.nottingham.ac.uk<BR>> <A href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</A><BR>> _______________________________________________<BR>> Xerte mailing list<BR>> Xerte@lists.nottingham.ac.uk<BR>> <A href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</A><BR><BR><BR>_______________________________________________<BR>Xerte mailing list<BR>Xerte@lists.nottingham.ac.uk<BR><A href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</A><BR></FONT></P></DIV></BODY></HTML>