Thanks Michael
Von: Michael Friedrich [mailto:[email protected]]
Gesendet: Montag, 21. Februar 2011 14:37
An: [email protected]
Betreff: Re: [icinga-users] icinga-web connection problem
>Meyer Jerome wrote:
>Yes, I've cleared the cache...
>Do icinga-web need the LDAP?
>Where do I have to seek the problem?
>mysql and socket connection to mysql. are there any restrictions on accessing
>localhost port 3306 on that machine (local iptables)?
No restrictions.
>to seek - database connection, deep down php/pdo and/or mysql daemon.
>forget ldap. how does that relate to a database? :p
cool !
You'll find the both configuration's files database.xml and icinga.xml :
# cat databases.xml
<?xml version="1.0" encoding="UTF-8"?>
<ae:configurations xmlns:ae="http://agavi.org/agavi/config/global/envelope/1.0";
xmlns="http://agavi.org/agavi/config/parts/databases/1.0";>
<ae:configuration>
<databases default="icinga_web">
<database name="icinga_web" class="AgaviDoctrineDatabase">
<!--
Doctrine dsn strings:
http://www.doctrine-project.org/documentation/manual/1_1/en/introduction-to-connections
-->
<!-- <ae:parameter
name="dsn">mysql://icinga_web:icinga_web@localhost:3306/icinga_web</ae:parameter>
-->
<ae:parameter
name="dsn">mysql://icinga_web:icinga_web@localhost:3306/icinga_web</ae:parameter>
<!-- Generic credentials -->
<!-- <ae:parameter name="username">icinga_web</ae:parameter> -->
<!-- <ae:parameter name="password">icinga</ae:parameter> -->
<!-- DB encoding type -->
<ae:parameter name="charset">utf8</ae:parameter>
<!--
Doctrine_Manager configuration
-->
<ae:parameter name="manager_attributes">
<!-- This allows lazy loading of the models -->
<ae:parameter
name="Doctrine_Core::ATTR_MODEL_LOADING">CONSERVATIVE</ae:parameter>
</ae:parameter>
<!-- The path to our models -->
<ae:parameter
name="load_models">%core.module_dir%/AppKit/lib/database/models/generated</ae:parameter>
<ae:parameter
name="models_directory">%core.module_dir%/AppKit/lib/database/models</ae:parameter>
</database>
<!-- include alternative configuration -->
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude";
href="databases.site.xml#xpointer(databases/node())">
<xi:fallback></xi:fallback>
</xi:include>
</databases>
</ae:configuration>
</ae:configurations>
# cat icinga.xml
<?xml version="1.0" encoding="UTF-8"?>
<!--
ICINGA base configuration
-->
<settings xmlns:ae="http://agavi.org/agavi/config/global/envelope/1.0";
xmlns="http://agavi.org/agavi/1.0/config"; prefix="org.icinga.">
<!--
Add more links under 'home'
* The home itself points to index_page route
-->
<setting name="appkit.home_links">
<!--<parameter name="icinga.about">About</parameter> -->
</setting>
<!--
The webpath, with a leading slash and no trailing
* If the path is empty, we try to detect the path
-->
<setting name="appkit.web_path">/icinga-web</setting>
<setting name="appkit.web_absolute_path">%core.root_dir%/pub</setting>
<setting name="appkit.image_path">/icinga-web/images</setting>
<!-- @DEPRECATED -->
<setting name="appkit.include_styles"></setting>
<!--
Metatags
-->
<setting name="appkit.meta_tags">
</setting>
<!-- @DEPRECATED -->
<!--
Javascript includes
* please provide absolute paths, we create one big file later.
-->
<setting name="appkit.include_javascript"></setting>
<!--
ScriptDynaLoader
* This scripts are included dynamically by modules if needed (js
code)
* You have to predefine the libraries
-->
<setting name="appkit.include_dynamic_javascript"></setting>
<!--
Doctrine pager configuration
* deprecated, test to remove
-->
<setting name="appkit.pager.default_items">20</setting>
<!--
Version information
* names, and revisions
* This results into org.icinga.version.release
<setting name="version.release"/>
-->
<setting name="version.copyright"><![CDATA[© 2009-2010 Icinga
Developer Team]]></setting>
<setting name="version.homeref"><![CDATA[<a
href="http://www.icinga.org/";>www.icinga.org</a>]]></setting>
<setting name="version.major">1</setting>
<setting name="version.minor">2</setting>
<setting name="version.patch">1</setting>
<setting name="version.extension"></setting>
<setting name="version.releasedate"><![CDATA[2010-10-25]]></setting>
<setting name="version.name">icinga-web</setting>
<!--
Early initialize modules
* This controls which agavi modules are initialized at start
* needed for classes, javascript, ...
-->
<setting name="appkit.init_modules">
<parameter>Cronks</parameter>
<parameter>Web</parameter>
</setting>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude";
href="schedules.xml"/>
</settings>
Von: Michael Friedrich [mailto:[email protected]]
Gesendet: Montag, 21. Februar 2011 14:10
An: [email protected]
Betreff: Re: [icinga-users] icinga-web connection problem
Meyer Jerome wrote:
Hi,
After to have install icinga, I've installed icinga-web and I encounter this
following problem :
======> http://<ip-add>/icinga-web/ <http://%3Cip-add%3E/icinga-web/>
A critical exception occured!
Uncaught AgaviDatabaseException thrown:
Couldn't connect to the icinga-web database.
Have entered valid credentials in %icinga_web%/app/config/databases.xml ?
Is the mysql server accessible (Can you access it in from the command line) ?
PDO Connection Error: SQLSTATE[28000] [1045] Access denied for user
'icinga_web'@'localhost' (using password: YES)
cleared the config cache after changing this?
Fsdf
<======
1) I can connect to mysql with the user icinga_web!
2) File : /usr/local/icinga-web/app/config/database.xml are following
configuration :
<ae:parameter
name="dsn">mysql://icinga_web:icinga_web@localhost:3306/icinga_web</ae:parameter>
Is it ok?
Could someone, tell me more about database.xml, databases.site.xml, icinga.xml
and icinga.site.xml?
Should I configure the credential too? :
<!-- Generic credentials -->
<!-- <ae:parameter name="username">icinga_web</ae:parameter> -->
<!-- <ae:parameter name="password">icinga</ae:parameter> -->
Thanks for your help!
Freundliche Grüsse
_________________
Jérôme M. Meyer
Network Engineer
IWB Telekom, Margarethenstrasse 40, 4002 Basel
Telefon 061 275 52 66
Fax 061 275 59 40
E-Mail [email protected] <mailto:[email protected]>
www.iwbtelekom.ch <http://www.iwbtelekom.ch/>
Partner von Swisspower
www.swisspower.ch <http://www.swisspower.ch/>
(Bitte bedenken Sie die Folgen für die Umwelt, bevor Sie diese E-Mail
ausdrucken.)
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
icinga-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/icinga-users
--
DI (FH) Michael Friedrich
Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria
email: [email protected]
phone: +43 1 4277 14359
fax: +43 1 4277 14338
web: http://www.univie.ac.at/zid
http://www.aco.net
Icinga Core & IDOUtils Developer
http://www.icinga.org
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
icinga-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/icinga-users
--
DI (FH) Michael Friedrich
Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria
email: [email protected]
phone: +43 1 4277 14359
fax: +43 1 4277 14338
web: http://www.univie.ac.at/zid
http://www.aco.net
Icinga Core & IDOUtils Developer
http://www.icinga.org
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
icinga-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/icinga-users
