Joseph L. Casale wrote: > Just fetched the tarballs and compiled the rpms from the spec and installed > icinga, idoutils and icinga-web and I see the spec hasn't any provisions for > creating the database.
no that's missing because it was not clear if that spec would be taken as the "official" one, and since there are various ways in creating the db, nothing was provided. i'm using a customized spec file, where I am copying the etc/schema directory into the installed location in order to allow db setup from plain sql scripts. > As I built the rpms as a non-root user on a separate devel box, I assumed as > per > the docs `make db-doc2sql` would create the sql scripts so that I could copy > them > to the new icinga server and populate the db manually but this didn't work. normally, you should rather take provided sql directly. the doc2sql thingy is only a helper extension on that. > It appeared as if it not only wanted access to an existing icinga-web db, but > to > a dbexport_temp database as well. Also, the ./etc/schema/mysql.sql file seem > to be incomplete and didn't create a fully functional db when imported, the > default > user did not exist. i can't reproduce that - my tests during release preparations showed all fine. but i was taking the plain sql scripts, not invoking doc2sql or similar. > I ended up running `./configure` and `make db-doc2sql` locally to get it > working. > > What is the procedure for creating plain sql scripts on a devel box without > icinga > installed? i've pushed my spec files changes over here - https://git.icinga.org/?p=icinga-web.git;a=commit;h=b83854a14d0187e91978f994ed1bd11714490b53 kind regards, michael > Thanks! > jlc > > > ------------------------------------------------------------------------------ > Colocation vs. Managed Hosting > A question and answer guide to determining the best fit > for your organization - today and in the future. > http://p.sf.net/sfu/internap-sfd2d > _______________________________________________ > icinga-users mailing list > icinga-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/icinga-users > -- DI (FH) Michael Friedrich Vienna University Computer Center Universitaetsstrasse 7 A-1010 Vienna, Austria email: michael.friedr...@univie.ac.at 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 ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users
