<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">hello again<br>all passed :)<br>My mysql user did not have ok settings (localhost) (blush :)<br>thx for everything <br>xerte is great!<br>regards<br><br>--- On <b>Mon, 4/2/12, Tom Reijnders <i><reijnders@tor.nl></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Tom Reijnders <reijnders@tor.nl><br>Subject: [Xerte] Re: xerte on web server (linux)<br>To: "Xerte discussion list" <xerte@lists.nottingham.ac.uk><br>Date: Monday, April 2, 2012, 8:57 AM<br><br><div id="yiv828173644">
<div>
This is the point where a database connection is set up:<br>
<br>
host (this is the host name of the MySQL server, in a Linux setup,
this is typically the same machine as the webserver, so localhost
should do)<br>
username: the mysql username<br>
passwd, the password of the mysql user,<br>
<br>
And somewhere you also have to give it a database name, 'xerte'
should work.<br>
<br>
Tom<br>
<br>
Op 2-4-2012 1:29, Elvira schreef:
<blockquote type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="font:inherit;" valign="top">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 rel="nofollow" class="yiv828173644moz-txt-link-rfc2396E" target="_blank" href="http://www.haccp-org.eu/xertetoolkits/">"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 class="yiv828173644st"><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 rel="nofollow" class="yiv828173644moz-txt-link-rfc2396E" ymailto="mailto:reijnders@tor.nl" target="_blank" href="/mc/compose?to=reijnders@tor.nl"><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 rel="nofollow" class="yiv828173644moz-txt-link-rfc2396E" ymailto="mailto:reijnders@tor.nl" target="_blank" href="/mc/compose?to=reijnders@tor.nl"><reijnders@tor.nl></a><br>
Subject: [Xerte] Re: xerte on web server (linux)<br>
To: "Xerte discussion list"
<a rel="nofollow" class="yiv828173644moz-txt-link-rfc2396E" ymailto="mailto:xerte@lists.nottingham.ac.uk" target="_blank" href="/mc/compose?to=xerte@lists.nottingham.ac.uk"><xerte@lists.nottingham.ac.uk></a><br>
Date: Sunday, April 1, 2012, 9:55 AM<br>
<br>
<div id="yiv828173644">
<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 class="yiv828173644mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Xerte mailing list
<a rel="nofollow" class="yiv828173644moz-txt-link-abbreviated">Xerte@lists.nottingham.ac.uk</a>
<a rel="nofollow" class="yiv828173644moz-txt-link-freetext" target="_blank" href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">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 class="yiv828173644moz-signature">--
--
Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196
</pre>
</div>
</div>
<br>
-----Inline Attachment Follows-----<br>
<br>
<div class="yiv828173644plainMail">_______________________________________________<br>
Xerte mailing list<br>
<a rel="nofollow">Xerte@lists.nottingham.ac.uk</a><br>
<a rel="nofollow" target="_blank" href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">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>
<fieldset class="yiv828173644mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Xerte mailing list
<a rel="nofollow" class="yiv828173644moz-txt-link-abbreviated" ymailto="mailto:Xerte@lists.nottingham.ac.uk" target="_blank" href="/mc/compose?to=Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a>
<a rel="nofollow" class="yiv828173644moz-txt-link-freetext" target="_blank" href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte">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 class="yiv828173644moz-signature">--
--
Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196
</pre>
</div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Xerte mailing list<br><a ymailto="mailto:Xerte@lists.nottingham.ac.uk" href="/mc/compose?to=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></div></blockquote></td></tr></table>