Yes cheers Andy I worked it out thanks Martyn
-----Original Message----- From: Andy Shellam [mailto:andy-li...@networkmail.eu] Sent: 05 February 2009 23:14 To: Martyn Cc: nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] Ubunt- Nagios3-Centreon 2-ndo2 Martyn, You've probably figured that out by now, but that command-line should be typed into your shell command prompt, not the MySQL one! Make sure your command prompt does not start "mysql >" before you type that command in. If it does, first use "quit" to exit back to your system shell, then try it again. As for your other question, yes because it's a string you need to quote it using '. Andy Martyn wrote: > Now it looks as though the DB is missing something > > mysql> mysql -u root ndo < > /usr/local/src/centreon-2.0/www/install/createNDODB.sql; > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual that corresponds to your MySQL server version for the right > syntax to use near 'mysql -u root ndo < > /usr/local/src/centreon-2.0/www/install/createNDODB.sql' at line 1 > > Will take a look into in to see what it is > > Thanks for the reply though, it got me one stage further > > Martyn > > -----Original Message----- > From: Andy Shellam [mailto:andy-li...@networkmail.eu] > Sent: 05 February 2009 21:12 > To: Martyn > Cc: nagios-users@lists.sourceforge.net > Subject: Re: [Nagios-users] Ubunt- Nagios3-Centreon 2-ndo2 > > Martyn, > > By the looks of it, there's a missing ";" at the end of one of the > queries in that file. I don't use NDODB so I cannot elaborate any more than that. > > Try running the command again and simply putting ;<ENTER> on the line > beginning with "->" > > HTH, > Andy > > Martyn wrote: > >> Hi Group. >> >> I'm trying to install Centreon on my Ubuntu box, I'm following the >> install guide and hit a snag. >> Looking at the site install guide here >> _http://en.doc.centreon.com/Nagios3_Centreon2_Ubuntu_ndo2_ I'm hit a >> problem at this stage. >> >> # mysql -u root ndo < >> /usr/local/src/centreon-2.0/www/install/createNDODB.sql >> >> When I run that query it just returns with -> and sits there forever >> or until I press ctrl c >> >> Do you know what the issue is at all. >> >> Thanks >> >> Martyn >> >> --------------------------------------------------------------------- >> - >> -- >> >> --------------------------------------------------------------------- >> - >> -------- Create and Deploy Rich Internet Apps outside the browser >> with >> Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use >> existing skills and code to build responsive, highly engaging >> applications that combine the power of local resources and data with >> the reach of the web. Download the Adobe AIR SDK and Ajax docs to >> start building applications today-http://p.sf.net/sfu/adobe-com >> --------------------------------------------------------------------- >> - >> -- >> >> _______________________________________________ >> Nagios-users mailing list >> Nagios-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/nagios-users >> ::: Please include Nagios version, plugin version (-v) and OS when >> > reporting any issue. > >> ::: Messages without supporting info will risk being sent to >> /dev/null >> > > > ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null