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

Elvira elvira.krso at yahoo.com
Mon Apr 2 12:47:29 BST 2012


hello again
all passed :)
My mysql user did not have ok settings (localhost) (blush :)
thx for everything 
xerte is great!
regards

--- On Mon, 4/2/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: Monday, April 2, 2012, 8:57 AM


  

    
  
  
    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
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://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


  


-----Inline Attachment Follows-----

_______________________________________________
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/05edade1/attachment-0001.html>


More information about the Xerte mailing list