Ubunt- Nagios3-Centreon 2-ndo2

[Andy Shellam]

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-lists at networkmail.eu] 
> Sent: 05 February 2009 21:12
> To: Martyn
> Cc: nagios-users at 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 at 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 at 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