in your database.php file (in root)<div><br></div><div>set the database name to "xerte"<br><br><div class="gmail_quote">On Mon, Apr 2, 2012 at 12:29 AM, Elvira <span dir="ltr"><<a href="mailto:elvira.krso@yahoo.com">elvira.krso@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td valign="top" style="font:inherit">Hello Tom<br>thanks for your reply.<br>
I did what you said and i got <br><span style="font-weight:bold">Default connection achieved </span><br><br>But when I did next test<br>i have questions:<br>host (mywebpage? or what?)<br>username:myuser<br>pass:passw_myuser<br>
Trying to connect.<br><br>Host / Username / Password connectivitiy achieved <br>Anyway, at the end I got a lot of error:<br>The sitedetails site ID query insert into sitedetails(site_id) VALUES ( "1") has failed due to No database selected<br>
The
sitedetails site url query update sitedetails set
site_url="<a href="http://www.haccp-org.eu/xertetoolkits/" target="_blank">http://www.haccp-org.eu/xertetoolkits/</a>" where site_id="1" has
failed due to No database selected<br>The sitedetails apache query update sitedetails set apache="false" where site_id="1" has failed due to No database selected<br>The sitedetails apache query update sitedetails set apache="false" where site_id="1" has failed due to No database selected <br>
etc<br>always at the end "No database selected"<br><br>But i saw in mysql that database "xerte" exist, with 13 tables...<br><span><br>Excuse my lack on knowledge of all this stuff</span><br>and my english :)<br>
thanks in advance<br>regards<br><br>--- On <b>Sun, 4/1/12, Tom Reijnders <i><<a href="mailto:reijnders@tor.nl" target="_blank">reijnders@tor.nl</a>></i></b> wrote:<br><blockquote style="border-left:2px solid rgb(16,16,255);margin-left:5px;padding-left:5px">
<br>From: Tom Reijnders <<a href="mailto:reijnders@tor.nl" target="_blank">reijnders@tor.nl</a>><br>Subject: [Xerte] Re: xerte on web server (linux)<br>To: "Xerte discussion list" <<a href="mailto:xerte@lists.nottingham.ac.uk" target="_blank">xerte@lists.nottingham.ac.uk</a>><br>
Date: Sunday, April 1, 2012, 9:55 AM<br><br><div>
<div>
There is a difference between USER='<span style="font-style:italic">myuser </span>' and USER='<span style="font-style:italic">myuser </span>'@'localhost'<br>
<br>
So, set the password using UPDATE user SET Password=PASSWORD('<span style="font-style:italic">new_password</span>') where USER='<span style="font-style:italic">myuser </span>'@'localhost';
<br>
<br>
Also make sure that the unzipped folder is accessible by the apache
webserver (either change the owner to the useraccount that apache
uses, typically wwwrun, or set the permission on a+r)<br>
<br>
Tom<br>
<br>
Op 1-4-2012 0:29, Elvira schreef:
<blockquote type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="font:inherit" valign="top">Dear all,<br>
I have problem with installing xertetoolkits on web server
(linux). In fact, everything seems to go ok till test
mysql, where i get message:<br>
Access denied for user '<span style="font-style:italic">myuser</span>'@'localhost'
(using password: NO)<br>
And I changed in mysql:<br>
mysql -u root -p<br>
mysql> UPDATE user SET Password=PASSWORD('<span style="font-style:italic">new_password</span>') where
USER='<span style="font-style:italic">myuser </span>';
<br>
mysql> FLUSH PRIVILEGES;
<br>
<br>
And nothing happened. <br>
For 3 days i reading and trying everything but no success.<br>
And I deleted that folder xertetoolkits on web server,
trying all over again, and now i cant even start install.
This is message:<br>
<h1><font size="5">Internal Server Error</font></h1>
<p>The server encountered an internal error or
misconfiguration and was unable to complete
your request.</p>
<p>Please contact the server administrator, root@localhost
and inform them of the time the error occurred,
and anything you might have done that may have
caused the error.</p>
<p>More information about this error may be available
in the server error log.</p>
<p><br>
</p>
<br>
Please help :(<br>
Regards<br>
</td>
</tr>
</tbody>
</table>
<br>
<p>
This message and any attachment are intended solely for the
addressee and may contain confidential information. If you have
received this message in error, please send it back to me, and
immediately delete it. Please do not use, copy or disclose the
information contained in this message or in any attachment. Any
views or opinions expressed by the author of this email do not
necessarily reflect the views of the University of Nottingham.
</p>
<p>
This message has been checked for viruses but the contents of an
attachment
may still contain software viruses which could damage your
computer system:
you are advised to perform your own checks. Email communications
with the
University of Nottingham may be monitored as permitted by UK
legislation.
</p>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Xerte mailing list
<a rel="nofollow" href="http://mc/compose?to=Xerte@lists.nottingham.ac.uk" target="_blank">Xerte@lists.nottingham.ac.uk</a>
<a rel="nofollow" href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a>
This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
This message has been checked for viruses but the contents of an attachment
may still contain software viruses which could damage your computer system:
you are advised to perform your own checks. Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.
</pre>
</blockquote>
<br>
<pre>--
--
Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196
</pre>
</div>
</div><br>-----Inline Attachment Follows-----<br><br><div>_______________________________________________<br>Xerte mailing list<br><a href="http://mc/compose?to=Xerte@lists.nottingham.ac.uk" target="_blank">Xerte@lists.nottingham.ac.uk</a><br>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><br><br>This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.<br>
<br>This message has been checked for viruses but the contents of an
attachment<br>may still contain software viruses which could damage your computer system:<br>you are advised to perform your own checks. Email communications with the<br>University of Nottingham may be monitored as permitted by UK legislation.<br>
<br></div></blockquote></td></tr></tbody></table><br>_______________________________________________<br>
Xerte mailing list<br>
<a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a><br>
<a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><br>
<br>
This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.<br>
<br>
This message has been checked for viruses but the contents of an attachment<br>
may still contain software viruses which could damage your computer system:<br>
you are advised to perform your own checks. Email communications with the<br>
University of Nottingham may be monitored as permitted by UK legislation.<br>
<br>
<br></blockquote></div><br></div>