Renamed version of the winstrom ebuild (#242902).
Created attachment 255333 [details] flexibee-10.12.3.ebuild Ebuild for the flexibee-10.12.3.
Created attachment 255335 [details] files/flexibee-server.init Init.d script for the flexibee ebuild.
Created attachment 255337 [details] files/flexibee-server.conf Conf.d file for the flexibee ebuild.
*** Bug 242902 has been marked as a duplicate of this bug. ***
I did emerge 10.12.3 I did create two PostgreSQL users a) "createuser -U postgres flexibee" b) "createuser -U postgres jano" - jano is my system account {linux} I did add user jano to postgreq group - {linux} I am starting flexibee from terminal. I am getting a window where I am ask to login, but there should be create user for first time. SO how to create new user? I did create new source : server name : frodo ip : 127.0.0.1 port : 5434 { I had to reconfigure postgres from 5432 to 5434 } during pressing OK in source window I am getting this message in terminal 20:56:57,831 ERROR LoginDialog:411 - java.lang.RuntimeException: javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated thanks for any help
(In reply to comment #5) > I did create two PostgreSQL users > a) "createuser -U postgres flexibee" > b) "createuser -U postgres jano" - jano is my system account {linux} WinStrom FlexiBee server is running under the user flexibee, so you do not have to create DB access for another user. > during pressing OK in source window I am getting this message in terminal > 20:56:57,831 ERROR LoginDialog:411 - java.lang.RuntimeException: > javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated Do you have some custom configuration of the PSQL? What are the USE flags for your dev-db/postgresql-server? Which version of PSQL are you using (8.4.4-r1)?
(In reply to comment #6) > > during pressing OK in source window I am getting this message in terminal > > 20:56:57,831 ERROR LoginDialog:411 - java.lang.RuntimeException: > > javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated > > Do you have some custom configuration of the PSQL? What are the USE flags for > your dev-db/postgresql-server? Which version of PSQL are you using (8.4.4-r1)? > maybe it could be same problem as at mine side, flexibee server, dunno why, used my eth0 IP address to connect to DB instead 127.0.0.1, so it was unauthorized, that could be "repaired" by adding own IP into pg_hba.conf as trust host.. anyway I've got different error, flexibee server starts OK, when I use random username/password it tells me (Client) about 1st run and I should create user, so I added username / password, press OK and then I got "bad username or pwd" message, that could be understandable due 1st run, so I rewrite these credentials for just created user and trying login again,, now it doesn't say any error about user or password, but I've got message about "Storage engine not running" and actually there it ends in "while (true)" loop also from server I've got error message Exception in thread "14941604@qtp0-22" java.lang.RuntimeException: javax.net.ssl.SSLHandshakeException: Received fatal alert: certificate_unknown at cz.winstrom.net.server.http.JettyConnector$1.run(JettyConnector.java:61) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:522) Caused by: javax.net.ssl.SSLHandshakeException: Received fatal alert: certificate_unknown at com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Alerts.java:174) at com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Alerts.java:136) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.recvAlert(SSLSocketImpl.java:1694) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:939) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1120) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1147) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1131) at cz.winstrom.net.server.http.JettyConnector.handleWithException(JettyConnector.java:454) at cz.winstrom.net.server.http.JettyConnector$1.run(JettyConnector.java:57) ... 1 more so I can't login as well.. I using PostgreSQL version 9.0.1 from portage. *) Sun JDK 1.6.0.20 [sun-jdk-1.6] this for Java
(In reply to comment #7) > I using PostgreSQL version 9.0.1 from portage. Please try it with stable dev-db/postgresql-server-8.4.4-r1. > *) Sun JDK 1.6.0.20 [sun-jdk-1.6] And upgrade your Java to dev-java/sun-jdk-1.6.0.22.
(In reply to comment #8) > (In reply to comment #7) > > I using PostgreSQL version 9.0.1 from portage. > > Please try it with stable dev-db/postgresql-server-8.4.4-r1. > > > *) Sun JDK 1.6.0.20 [sun-jdk-1.6] > > And upgrade your Java to dev-java/sun-jdk-1.6.0.22. > OK Thanks looks like it works now, but still I must added that mine eth0 interface address into PostgreSQL's pg_hba.conf as trust host, but dunno if due new version of Java or older version of PostgreSQL it now works... PSQL Version: dev-db/postgresql-server-8.4.5 Java Version: dev-java/sun-jdk-1.6.0.22
Created attachment 260836 [details] flexibee-10.13.0.1.ebuild Ebuild for the newest version of the FlexiBee 10.13.0.1.
I have upgraded to latest stable =dev-db/postgresql-server-9.0.3 from =dev-db/postgresql-server-8.4.7 and migrated company data using pg_upgrade. The migration process seemed ok, but now I am getting ''java.io.IOException: Invalid keystore format'': sudo -u flexibee /usr/sbin/flexibee-server MLog clients using log4j logging. Initializing c3p0-0.9.1 [built 16-January-2007 14:46:42; debug? true; trace: 10] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1bqomwx8f1yqifk1anmpxy|5c07f4ec, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> null, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1bqomwx8f1yqifk1anmpxy|5c07f4ec, idleConnectionTestPeriod -> 0, initialPoolSize -> 0, jdbcUrl -> jdbc:postgresql://localhost:5432/postgres, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 30, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1bqomwx8f1yqifk1anmpxy|3fb6101e, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> null, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1bqomwx8f1yqifk1anmpxy|3fb6101e, idleConnectionTestPeriod -> 0, initialPoolSize -> 0, jdbcUrl -> jdbc:postgresql://localhost:5432/centralServer, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 30, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ] 30.3.2011 16:05:01 cz.winstrom.verificator.impl.LicSignHelper verifyLicense INFO: Successfully validated. 30.3.2011 16:05:01 cz.winstrom.verificator.impl.LicSignHelper verifyLicense INFO: Successfully verified. Error creating SSL server socket factory java.io.IOException: Invalid keystore format at sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:633) at sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:38) at java.security.KeyStore.load(KeyStore.java:1185) at cz.winstrom.net.server.tcp.ServerUtils.initSSL(ServerUtils.java:211) at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:311) at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:173) Error starting WinStrom server java.lang.RuntimeException: java.io.IOException: Invalid keystore format at cz.winstrom.net.server.tcp.ServerUtils.initSSL(ServerUtils.java:224) at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:311) at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:173) Caused by: java.io.IOException: Invalid keystore format at sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:633) at sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:38) at java.security.KeyStore.load(KeyStore.java:1185) at cz.winstrom.net.server.tcp.ServerUtils.initSSL(ServerUtils.java:211) ... 2 more java.io.IOException: Invalid keystore format The same version of flexibee (10.13.0.1) server works right with postgresql-server-8.4.7. Is the new stable version of postgresql supported? Also there are new versions of flexibee (10.13.2, 10.13.4 and 10.14.0) http://www.winstrom.eu/produkty/flexibee/verze/. Do you plan to add new ebuild(s) for these versions? Thanks for any suggestions. PM
(In reply to comment #11) > I have upgraded to latest stable =dev-db/postgresql-server-9.0.3 from > =dev-db/postgresql-server-8.4.7 and migrated company data using pg_upgrade. The > migration process seemed ok, but now I am getting ''java.io.IOException: > Invalid keystore format'': > > The same version of flexibee (10.13.0.1) server works right with > postgresql-server-8.4.7. Is the new stable version of postgresql supported? > I have received answer from WinStrom company Postgres 9.0 isn't supported yet and they know about the problem described above. The problem is the JDBC driver (postgresql-8.3-603.jdbc3.jar) used in flexibee does work only with PG 8.3 and 8.4. But one can try (on own responsibility) a newer version of the driver...
I've got a similar problem like Jan Boros but his solution doesn't work for me. flexibee error: 00:21:59,557 ERROR LoginDialog:414 - java.lang.RuntimeException: javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated postgresql error: LOG: invalid length of startup packet installed sw: app-office/flexibee-10.13.0.1 (USE: X,logrotate,server) dev-java/sun-jdk-1.6.0.24 (USE: X,alsa,jce,odbc) dev-db/postgresql-server-8.4.5 (USE: kernel_linux,linguas_cs,nls,perl,python,tcl) config: I've changed the postgresql port to 5434 and added "host" line with eth0 ip address to pg_hba.conf. thanks for help
I'm trying to use Flexibee on a server using this ebuild, but after installation, the Flexibee server listens only on localhost. Apparently, it doesn't get the FLEXIBEE_CFG variable set to 'server' or something.
Created attachment 288437 [details] flexibee-10.15.1.3 ebuild
Hello, could you add ebild for newest flexibee http://www.flexibee.eu/download/10.18/10.18.2.5/flexibee-10.18.2.5.tar.gz
Created attachment 342000 [details] newest version
Created attachment 342002 [details] flexibee-10.18.2.5.ebuild
Hi, last ebuild can't find file for download. Here is a new link for download: https://download.flexibee.eu/download/10.18/10.18.2.5/
