[Xerte] Re: xerte on web server (linux)

[Pat Lockley]

in your database.php file (in root)

set the database name to "xerte"

On Mon, Apr 2, 2012 at 12:29 AM, Elvira <elvira.krso at yahoo.com> wrote:

> Hello Tom
> thanks for your reply.
> I did what you said and i got
> Default connection achieved
>
> But when I did next test
> i have questions:
> host (mywebpage? or what?)
> username:myuser
> pass:passw_myuser
> Trying to connect.
>
> Host / Username / Password connectivitiy achieved
> Anyway, at the end I got a lot of error:
> The sitedetails site ID query insert into sitedetails(site_id) VALUES (
> "1") has failed due to No database selected
> The sitedetails site url query update sitedetails set site_url="
> http://www.haccp-org.eu/xertetoolkits/" where site_id="1" has failed due
> to No database selected
> The sitedetails apache query update sitedetails set apache="false" where
> site_id="1" has failed due to No database selected
> The sitedetails apache query update sitedetails set apache="false" where
> site_id="1" has failed due to No database selected
> etc
> always at the end "No database selected"
>
> But i saw in mysql that database "xerte" exist, with 13 tables...
>
> Excuse my lack on knowledge of all this stuff
> and my english :)
> thanks in advance
> regards
>
> --- On *Sun, 4/1/12, Tom Reijnders <reijnders at tor.nl>* wrote:
>
>
> From: Tom Reijnders <reijnders at tor.nl>
> Subject: [Xerte] Re: xerte on web server (linux)
> To: "Xerte discussion list" <xerte at lists.nottingham.ac.uk>
> Date: Sunday, April 1, 2012, 9:55 AM
>
>  There is a difference between USER='myuser ' and USER='myuser
> '@'localhost'
>
> So, set the password using UPDATE user SET Password=PASSWORD('new_password')
> where USER='myuser '@'localhost';
>
> 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)
>
> Tom
>
> Op 1-4-2012 0:29, Elvira schreef:
>
>   Dear all,
> I have problem with installing xertetoolkits on web server (linux). In
> fact, everything seems to go ok till test mysql, where i get message:
> Access denied for user 'myuser'@'localhost' (using password: NO)
> And I changed in mysql:
> mysql -u root -p
> mysql> UPDATE user SET Password=PASSWORD('new_password') where USER='myuser
> ';
> mysql> FLUSH PRIVILEGES;
>
> And nothing happened.
> For 3 days i reading and trying everything but no success.
> And I deleted that folder xertetoolkits on web server, trying all over
> again, and now i cant even start install. This is message:
> Internal Server Error
>
> The server encountered an internal error or misconfiguration and was
> unable to complete your request.
>
> Please contact the server administrator, root at localhost and inform them
> of the time the error occurred, and anything you might have done that may
> have caused the error.
>
> More information about this error may be available in the server error log.
>
>
>
> Please help :(
> Regards
>
>  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.
>
>
> _______________________________________________
> Xerte mailing listXerte at lists.nottingham.ac.uk <http://mc/compose?to=Xerte@lists.nottingham.ac.uk>http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> 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.
>
>
>
> --
> --
>
> Tom Reijnders
> TOR Informatica
> Chopinlaan 27
> 5242HM Rosmalen
> Tel: 073 5226191
> Fax: 073 5226196
>
>
>
> -----Inline Attachment Follows-----
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk<http://mc/compose?to=Xerte@lists.nottingham.ac.uk>
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> 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.
>
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> 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.
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20120402/21878164/attachment-0001.html>