Re: database "template1" does not exist
Ronald Roskens <[email protected]> Wed, 25 Nov 2015 13:08:14 -0600
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <[email protected]> |
--===============0425455143788958746== Content-Type: multipart/signed; boundary="Apple-Mail=_4F039E7E-C248-462A-8BBD-DF5E22603DAB"; protocol="application/pgp-signature"; micalg=pgp-sha512 --Apple-Mail=_4F039E7E-C248-462A-8BBD-DF5E22603DAB Content-Type: multipart/alternative; boundary="Apple-Mail=_41F250AB-2013-4F3A-BFE7-A6B2129BC3B6" --Apple-Mail=_41F250AB-2013-4F3A-BFE7-A6B2129BC3B6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii > On Nov 23, 2015, at 7:21 PM, Dave Badia <[email protected]> wrote: >=20 > Hi List - >=20 > Getting some errors while trying to install, googled around but can't = find a solution: >=20 > /usr/share/opennms/bin/install -dis > = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D > OpenNMS Installer > = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D >=20 > Configures PostgreSQL tables, users, and other miscellaneous settings. >=20 > DEBUG: Platform is IPv6 ready: true > - searching for libjicmp.so: > - trying to load /usr/lib/jni/libjicmp.so: OK > - searching for libjicmp6.so: > - trying to load /usr/lib/jni/libjicmp6.so: OK > - searching for libjrrd.so: > - trying to load /usr/lib/jni/libjrrd.so: NO > - trying to load /usr/lib/jni/libjrrd.so: NO > - trying to load /libjrrd.so: NO > - trying to load /usr/share/opennms/lib/libjrrd.so: NO > - trying to load /usr/share/opennms/lib/linux32/libjrrd.so: NO > - trying to load /usr/java/packages/lib/amd64/libjrrd.so: NO > - trying to load /usr/lib64/libjrrd.so: NO > - trying to load /lib64/libjrrd.so: NO > - trying to load /lib/libjrrd.so: NO > - trying to load /usr/lib/libjrrd.so: NO > - trying to load /usr/lib/jni/libjrrd.so: NO > - trying to load /usr/lib/libjrrd.so: NO > - trying to load /usr/local/lib/libjrrd.so: NO > - trying to load /opt/NMSjicmp/lib/32/libjrrd.so: NO > - trying to load /opt/NMSjicmp/lib/64/libjrrd.so: NO > - trying to load /opt/NMSjicmp6/lib/32/libjrrd.so: NO > - trying to load /opt/NMSjicmp6/lib/64/libjrrd.so: NO > - Failed to load the optional jrrd library. > - This error is not fatal, since jrrd is only required for optional = features. > - For more information, see http://www.opennms.org/index.php/jrrd = <http://www.opennms.org/index.php/jrrd> > 20:18:03.751 [Main] WARN org.opennms.install.Installer - Could not = create file: /usr/share/opennms/etc/libraries.properties > - using SQL directory... /usr/share/opennms/etc > - using create.sql... /usr/share/opennms/etc/create.sql > 20:18:03.755 [Main] INFO org.opennms.core.schema.Migrator - = validating database version > java.lang.reflect.InvocationTargetException > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at = sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:= 62) > at = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm= pl.java:43) > at java.lang.reflect.Method.invoke(Method.java:497) > at org.opennms.bootstrap.Bootstrap$3.run(Bootstrap.java:370) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.opennms.core.schema.MigrationException: an error = occurred getting the version from the database > at = org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:183) > at = org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:211= ) > at org.opennms.install.Installer.install(Installer.java:247) > at org.opennms.install.Installer.main(Installer.java:985) > ... 6 more > Caused by: org.postgresql.util.PSQLException: FATAL: database = "template1" does not exist > at = org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(Connectio= nFactoryImpl.java:572) > at = org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Connection= FactoryImpl.java:177) > at = org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.jav= a:64) > at = org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connectio= n.java:136) > at = org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connectio= n.java:29) > at = org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnec= tion.java:21) > at = org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connectio= n.java:31) > at = org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) > at org.postgresql.Driver.makeConnection(Driver.java:410) > at org.postgresql.Driver.connect(Driver.java:280) > at = java.sql.DriverManager.getConnection(DriverManager.java:664) > at = java.sql.DriverManager.getConnection(DriverManager.java:208) > at = org.opennms.core.db.install.SimpleDataSource.getConnection(SimpleDataSourc= e.java:93) > at = org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:171) > ... 9 more If the template1 database does not exist, then you could re-create it = using the template0 database. http://www.postgresql.org/docs/9.1/static/manage-ag-templatedbs.html = <http://www.postgresql.org/docs/9.1/static/manage-ag-templatedbs.html> Ron --Apple-Mail=_41F250AB-2013-4F3A-BFE7-A6B2129BC3B6 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html = charset=3Dus-ascii"></head><body style=3D"word-wrap: break-word; = -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" = class=3D""><br class=3D""><div><blockquote type=3D"cite" class=3D""><div = class=3D"">On Nov 23, 2015, at 7:21 PM, Dave Badia <<a = href=3D"mailto:[email protected]" class=3D"">[email protected]</a>> = wrote:</div><br class=3D"Apple-interchange-newline"><div class=3D""><div = dir=3D"ltr" class=3D""><div class=3D"">Hi List - <br class=3D""><br = class=3D""></div>Getting some errors while trying to install, googled = around but can't find a solution:<br class=3D""><div class=3D""><div = class=3D""><br class=3D"">/usr/share/opennms/bin/install -dis<br = class=3D"">=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D<br class=3D"">OpenNMS Installer<br = class=3D"">=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D<br class=3D""><br class=3D"">Configures PostgreSQL = tables, users, and other miscellaneous settings.<br class=3D""><br = class=3D"">DEBUG: Platform is IPv6 ready: true<br class=3D"">- searching = for libjicmp.so:<br class=3D""> - trying to load = /usr/lib/jni/libjicmp.so: OK<br class=3D"">- searching for = libjicmp6.so:<br class=3D""> - trying to load = /usr/lib/jni/libjicmp6.so: OK<br class=3D"">- searching for = libjrrd.so:<br class=3D""> - trying to load = /usr/lib/jni/libjrrd.so: NO<br class=3D""> - trying to load = /usr/lib/jni/libjrrd.so: NO<br class=3D""> - trying to load = /libjrrd.so: NO<br class=3D""> - trying to load = /usr/share/opennms/lib/libjrrd.so: NO<br class=3D""> - trying to = load /usr/share/opennms/lib/linux32/libjrrd.so: NO<br class=3D""> = - trying to load /usr/java/packages/lib/amd64/libjrrd.so: NO<br = class=3D""> - trying to load /usr/lib64/libjrrd.so: NO<br = class=3D""> - trying to load /lib64/libjrrd.so: NO<br = class=3D""> - trying to load /lib/libjrrd.so: NO<br = class=3D""> - trying to load /usr/lib/libjrrd.so: NO<br = class=3D""> - trying to load /usr/lib/jni/libjrrd.so: NO<br = class=3D""> - trying to load /usr/lib/libjrrd.so: NO<br = class=3D""> - trying to load /usr/local/lib/libjrrd.so: NO<br = class=3D""> - trying to load /opt/NMSjicmp/lib/32/libjrrd.so: = NO<br class=3D""> - trying to load = /opt/NMSjicmp/lib/64/libjrrd.so: NO<br class=3D""> - trying to = load /opt/NMSjicmp6/lib/32/libjrrd.so: NO<br class=3D""> - trying = to load /opt/NMSjicmp6/lib/64/libjrrd.so: NO<br class=3D"">- Failed to = load the optional jrrd library.<br class=3D""> - This error is not = fatal, since jrrd is only required for optional features.<br = class=3D""> - For more information, see <a = href=3D"http://www.opennms.org/index.php/jrrd" = class=3D"">http://www.opennms.org/index.php/jrrd</a><br = class=3D"">20:18:03.751 [Main] WARN org.opennms.install.Installer = - Could not create file: /usr/share/opennms/etc/libraries.properties<br = class=3D"">- using SQL directory... /usr/share/opennms/etc<br class=3D"">-= using create.sql... /usr/share/opennms/etc/create.sql<br = class=3D"">20:18:03.755 [Main] INFO = org.opennms.core.schema.Migrator - validating database version<br = class=3D"">java.lang.reflect.InvocationTargetException<br = class=3D""> at = sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br = class=3D""> at = sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:= 62)<br class=3D""> at = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm= pl.java:43)<br class=3D""> at = java.lang.reflect.Method.invoke(Method.java:497)<br = class=3D""> at = org.opennms.bootstrap.Bootstrap$3.run(Bootstrap.java:370)<br = class=3D""> at = java.lang.Thread.run(Thread.java:745)<br class=3D"">Caused by: = org.opennms.core.schema.MigrationException: an error occurred getting = the version from the database<br = class=3D""> at = org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:183)<br = class=3D""> at = org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:211= )<br class=3D""> at = org.opennms.install.Installer.install(Installer.java:247)<br = class=3D""> at = org.opennms.install.Installer.main(Installer.java:985)<br = class=3D""> ... 6 more<br = class=3D"">Caused by: org.postgresql.util.PSQLException: FATAL: database = "template1" does not exist<br = class=3D""> at = org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(Connectio= nFactoryImpl.java:572)<br = class=3D""> at = org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Connection= FactoryImpl.java:177)<br = class=3D""> at = org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.jav= a:64)<br class=3D""> at = org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Con= nection.java:136)<br class=3D""> = at = org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Con= nection.java:29)<br class=3D""> = at = org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3g= Connection.java:21)<br = class=3D""> at = org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Con= nection.java:31)<br class=3D""> = at = org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)= <br class=3D""> at = org.postgresql.Driver.makeConnection(Driver.java:410)<br = class=3D""> at = org.postgresql.Driver.connect(Driver.java:280)<br = class=3D""> at = java.sql.DriverManager.getConnection(DriverManager.java:664)<br = class=3D""> at = java.sql.DriverManager.getConnection(DriverManager.java:208)<br = class=3D""> at = org.opennms.core.db.install.SimpleDataSource.getConnection(SimpleDataSourc= e.java:93)<br class=3D""> at = org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:171)<br = class=3D""> ... 9 more<br = class=3D""></div></div></div></div></blockquote></div><br class=3D""><div = class=3D"">If the template1 database does not exist, then you could = re-create it using the template0 database.</div><div class=3D""><br = class=3D""></div><div class=3D""><a = href=3D"http://www.postgresql.org/docs/9.1/static/manage-ag-templatedbs.ht= ml" = class=3D"">http://www.postgresql.org/docs/9.1/static/manage-ag-templatedbs= .html</a></div><div class=3D""><br class=3D""></div><div = class=3D"">Ron</div></body></html>= --Apple-Mail=_41F250AB-2013-4F3A-BFE7-A6B2129BC3B6-- --Apple-Mail=_4F039E7E-C248-462A-8BBD-DF5E22603DAB Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP using GPGMail -----BEGIN PGP SIGNATURE----- Comment: GPGTools - https://gpgtools.org iQIcBAEBCgAGBQJWVgceAAoJENlR2nVe4bSrcE0QAJmixxCP6qFalUcnpI6LRIA6 tX4erXMexV7RCTct/Pb4BC0iBBWVRJ08hp7ZvBv/ewPBqGANxwMzU/zKI3bhhLWg 0KjifiyEju8dgQq8aI8g7+ezXiFErwD0vQI/pvdFb3lqoZ3hCg4xZLY9SgNFpJG8 rZU7KLvek+Ph4qqTx7Bj0vc4g7nYVSvHE+FZN3RrYo0c/BThLYKyt42BRNTTnshI RnVtXhTH+BzFRaTS7HOEdeUstUeaDuW7Bv6YSgtBaZZ14godO57YRNUegcZXeNUZ zYVvVjcCpgqJPdahTr07NwHwEzXMcvn5qEUfqKX3xK+iTrJ6PqtX90tTQEE9CHjz lYPu1/40qPQYI4aPlMOndKcrrHpCB3MN5PGRJf0zkkRn/hbn/jj/BA8c/A9cQFLI sgek7FhuI3lh2C5POA1c6dzWHatLHB276Ww1eTYWxQTa4DfAnwGS+xZpzJ75gur+ Mx51gj2MNIs7zpgh9axBY015f2kvczeng6Oh0DU+cYoExT+F+suufIzfaYvFuVLX /FNcIWbvFHQGc6f01xJzvFLfqxRge1IKW4tGRK5Bwtr0/0AxvMcAuXcoj2E1OZ4V DuixNSDUXx+qNgqU/9eY8Uty7Rps+zhtW3U919t3iWeFNNQBnz46ercZhWZuyull 82NsgqAEh3BnQr7b77+H =yM6H -----END PGP SIGNATURE----- --Apple-Mail=_4F039E7E-C248-462A-8BBD-DF5E22603DAB-- --===============0425455143788958746== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140 --===============0425455143788958746== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-install mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-install --===============0425455143788958746==--