[Xerte] Re: xerte on web server (linux)
Tom Reijnders
reijnders at tor.nl
Mon Apr 2 07:57:46 BST 2012
This is the point where a database connection is set up:
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)
username: the mysql username
passwd, the password of the mysql user,
And somewhere you also have to give it a database name, 'xerte' should work.
Tom
Op 2-4-2012 1:29, Elvira schreef:
> 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 list
>> Xerte at lists.nottingham.ac.uk </mc/compose?to=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.
>>
>
> --
> --
>
> 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
> </mc/compose?to=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.
>
>
>
> _______________________________________________
> 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.
>
--
--
Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20120402/523d436f/attachment-0001.html>
More information about the Xerte
mailing list