Not clear how to add card databases to docker image about dockeryourxyzzy HOT 6 OPEN

Not sure unfortunately, but a quick search turns up ajanata/PretendYoureXyzzy#192. Can you add packs at /cardsets.jsp?

from dockeryourxyzzy.

Hmm. I get a access restricted to known hosts error from Apache / Tomcat. Not sure if I have to add my user as an admin, but that may be related to this.

I did check the container logs and found
[SQLITE_ERROR] SQL error or missing database (no such table: card_set)

Here is the full log:

neil@zen:/opt/docker$ docker logs 49a56aaadcfb
log4j:WARN No appenders could be found for logger (net.socialgamer.cah.StartupUtils).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
2020-04-12 20:48:16,918 [localhost-startStop-1] INFO net.socialgamer.cah.StartupUtils - Reloading log4j.properties
2020-04-12 20:48:16,919 [localhost-startStop-1] INFO net.socialgamer.cah.StartupUtils - Reloading pyx.properties
2020-04-12 21:00:04,753 [http-bio-8080-exec-6] INFO org.hibernate.annotations.common.Version - Hibernate Commons Annotations 3.2.0.Final
2020-04-12 21:00:04,759 [http-bio-8080-exec-6] INFO org.hibernate.cfg.Environment - Hibernate 3.6.10.Final
2020-04-12 21:00:04,761 [http-bio-8080-exec-6] INFO org.hibernate.cfg.Environment - hibernate.properties not found
2020-04-12 21:00:04,763 [http-bio-8080-exec-6] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
2020-04-12 21:00:04,765 [http-bio-8080-exec-6] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
2020-04-12 21:00:04,811 [http-bio-8080-exec-6] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
2020-04-12 21:00:04,816 [http-bio-8080-exec-6] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
2020-04-12 21:00:04,861 [http-bio-8080-exec-6] WARN org.hibernate.util.DTDEntityResolver - recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!
2020-04-12 21:00:04,909 [http-bio-8080-exec-6] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
2020-04-12 21:00:04,968 [http-bio-8080-exec-6] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: net.socialgamer.cah.db.PyxBlackCard
2020-04-12 21:00:05,022 [http-bio-8080-exec-6] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity net.socialgamer.cah.db.PyxBlackCard on table black_cards
2020-04-12 21:00:05,079 [http-bio-8080-exec-6] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: net.socialgamer.cah.db.PyxWhiteCard
2020-04-12 21:00:05,079 [http-bio-8080-exec-6] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity net.socialgamer.cah.db.PyxWhiteCard on table white_cards
2020-04-12 21:00:05,081 [http-bio-8080-exec-6] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: net.socialgamer.cah.db.PyxCardSet
2020-04-12 21:00:05,085 [http-bio-8080-exec-6] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity net.socialgamer.cah.db.PyxCardSet on table card_set
2020-04-12 21:00:05,149 [http-bio-8080-exec-6] INFO org.hibernate.cfg.Configuration - Hibernate Validator not found: ignoring
2020-04-12 21:00:05,156 [http-bio-8080-exec-6] INFO org.hibernate.cfg.search.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
2020-04-12 21:00:05,165 [http-bio-8080-exec-6] INFO org.hibernate.connection.ConnectionProviderFactory - Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider
2020-04-12 21:00:05,165 [http-bio-8080-exec-6] INFO org.hibernate.connection.C3P0ConnectionProvider - C3P0 using driver: org.sqlite.JDBC at URL: jdbc:sqlite:pyx.sqlite
2020-04-12 21:00:05,165 [http-bio-8080-exec-6] INFO org.hibernate.connection.C3P0ConnectionProvider - Connection properties: {user=pyx, password=}
2020-04-12 21:00:05,165 [http-bio-8080-exec-6] INFO org.hibernate.connection.C3P0ConnectionProvider - autocommit mode: false
2020-04-12 21:00:05,183 [http-bio-8080-exec-6] INFO com.mchange.v2.log.MLog - MLog clients using log4j logging.
2020-04-12 21:00:05,268 [http-bio-8080-exec-6] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.1 [built 16-January-2007 14:46:42; debug? true; trace: 10]
2020-04-12 21:00:05,377 [http-bio-8080-exec-6] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@536e3de8 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@9a830d5a [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1jfmjura9v4nn4x89j6h0|7fedec3f, idleConnectionTestPeriod -> 10, initialPoolSize -> 5, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 300, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 50, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@4a3a4a08 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1jfmjura9v4nn4x89j6h0|372126f0, jdbcUrl -> jdbc:sqlite:pyx.sqlite, properties -> {user=, password=****} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1jfmjura9v4nn4x89j6h0|69d0ecae, numHelperThreads -> 3 ]
2020-04-12 21:00:05,591 [http-bio-8080-exec-6] INFO org.hibernate.dialect.Dialect - Using dialect: net.socialgamer.cah.hibernate.SqliteDialect
2020-04-12 21:00:05,605 [http-bio-8080-exec-6] INFO org.hibernate.engine.jdbc.JdbcSupportLoader - Disabling contextual LOB creation as JDBC driver reported JDBC version [2] less than 4
2020-04-12 21:00:05,606 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Database ->
name : SQLite
version : 3.8.7
major : 3
minor : 0
2020-04-12 21:00:05,606 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Driver ->
name : SQLiteJDBC
version : native
major : 1
minor : 1
2020-04-12 21:00:05,608 [http-bio-8080-exec-6] INFO org.hibernate.transaction.TransactionFactoryFactory - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
2020-04-12 21:00:05,609 [http-bio-8080-exec-6] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2020-04-12 21:00:05,612 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
2020-04-12 21:00:05,612 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
2020-04-12 21:00:05,612 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: disabled
2020-04-12 21:00:05,612 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
2020-04-12 21:00:05,612 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
2020-04-12 21:00:05,613 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
2020-04-12 21:00:05,613 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
2020-04-12 21:00:05,613 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
2020-04-12 21:00:05,613 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
2020-04-12 21:00:05,613 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2020-04-12 21:00:05,614 [http-bio-8080-exec-6] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
2020-04-12 21:00:05,614 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
2020-04-12 21:00:05,614 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
2020-04-12 21:00:05,615 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: disabled
2020-04-12 21:00:05,615 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
2020-04-12 21:00:05,615 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
2020-04-12 21:00:05,616 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
2020-04-12 21:00:05,620 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
2020-04-12 21:00:05,622 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
2020-04-12 21:00:05,622 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
2020-04-12 21:00:05,623 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
2020-04-12 21:00:05,624 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
2020-04-12 21:00:05,624 [http-bio-8080-exec-6] INFO org.hibernate.cfg.SettingsFactory - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
2020-04-12 21:00:05,645 [http-bio-8080-exec-6] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
2020-04-12 21:00:05,653 [http-bio-8080-exec-6] INFO org.hibernate.type.BasicTypeRegistry - Type registration [blob] overrides previous : org.hibernate.type.BlobType@2f8e5e47
2020-04-12 21:00:05,653 [http-bio-8080-exec-6] INFO org.hibernate.type.BasicTypeRegistry - Type registration [java.sql.Blob] overrides previous : org.hibernate.type.BlobType@2f8e5e47
2020-04-12 21:00:05,653 [http-bio-8080-exec-6] INFO org.hibernate.type.BasicTypeRegistry - Type registration [characters_clob] overrides previous : org.hibernate.type.PrimitiveCharacterArrayClobType@1486d436
2020-04-12 21:00:05,653 [http-bio-8080-exec-6] INFO org.hibernate.type.BasicTypeRegistry - Type registration [materialized_blob] overrides previous : org.hibernate.type.MaterializedBlobType@defbaea
2020-04-12 21:00:05,653 [http-bio-8080-exec-6] INFO org.hibernate.type.BasicTypeRegistry - Type registration [wrapper_characters_clob] overrides previous : org.hibernate.type.CharacterArrayClobType@338288ab
2020-04-12 21:00:05,653 [http-bio-8080-exec-6] INFO org.hibernate.type.BasicTypeRegistry - Type registration [wrapper_materialized_blob] overrides previous : org.hibernate.type.WrappedMaterializedBlobType@6ea384fa
2020-04-12 21:00:05,653 [http-bio-8080-exec-6] INFO org.hibernate.type.BasicTypeRegistry - Type registration [materialized_clob] overrides previous : org.hibernate.type.MaterializedClobType@4ca6da7c
2020-04-12 21:00:05,654 [http-bio-8080-exec-6] INFO org.hibernate.type.BasicTypeRegistry - Type registration [clob] overrides previous : org.hibernate.type.ClobType@3cee11e8
2020-04-12 21:00:05,654 [http-bio-8080-exec-6] INFO org.hibernate.type.BasicTypeRegistry - Type registration [java.sql.Clob] overrides previous : org.hibernate.type.ClobType@3cee11e8
2020-04-12 21:00:06,011 [http-bio-8080-exec-6] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
2020-04-12 21:00:06,266 [http-bio-8080-exec-6] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: null
2020-04-12 21:00:06,268 [http-bio-8080-exec-6] ERROR org.hibernate.util.JDBCExceptionReporter - [SQLITE_ERROR] SQL error or missing database (no such table: card_set)
2020-04-12 21:05:52,319 [http-bio-8080-exec-6] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: null
2020-04-12 21:05:52,319 [http-bio-8080-exec-6] ERROR org.hibernate.util.JDBCExceptionReporter - [SQLITE_ERROR] SQL error or missing database (no such table: card_set)
2020-04-12 21:07:20,265 [http-bio-8080-exec-2] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: null
2020-04-12 21:07:20,266 [http-bio-8080-exec-2] ERROR org.hibernate.util.JDBCExceptionReporter - [SQLITE_ERROR] SQL error or missing database (no such table: card_set)
2020-04-12 21:18:00,456 [http-bio-8080-exec-10] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: null
2020-04-12 21:18:00,456 [http-bio-8080-exec-10] ERROR org.hibernate.util.JDBCExceptionReporter - [SQLITE_ERROR] SQL error or missing database (no such table: card_set)
2020-04-12 21:19:08,023 [http-bio-8080-exec-4] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: null
2020-04-12 21:19:08,023 [http-bio-8080-exec-4] ERROR org.hibernate.util.JDBCExceptionReporter - [SQLITE_ERROR] SQL error or missing database (no such table: card_set)
2020-04-12 21:19:21,606 [http-bio-8080-exec-6] INFO net.socialgamer.cah.data.ConnectedUsers - New user Rose from 199.201.185.1 (admin=false, id=)
2020-04-12 21:19:21,608 [http-bio-8080-exec-6] INFO net.socialgamer.cah.metrics.GeoIP - Attempting to create GeoIP database reader
2020-04-12 21:19:39,378 [http-bio-8080-exec-6] INFO net.socialgamer.cah.data.Game - Rose joined game 0.
2020-04-12 21:19:39,379 [http-bio-8080-exec-6] INFO net.socialgamer.cah.data.GameManager - Created new game 0 by user Rose.
2020-04-12 21:28:07,473 [timer-task-1] INFO net.socialgamer.cah.data.Game - Removing Rose from game 0.
2020-04-12 21:28:07,473 [timer-task-1] INFO net.socialgamer.cah.data.GameManager - Destroyed game 0.
2020-04-12 21:28:07,473 [timer-task-1] INFO net.socialgamer.cah.data.Game - Removing spectator Rose from game 0.
2020-04-12 21:28:07,473 [timer-task-1] INFO net.socialgamer.cah.data.ConnectedUsers - Automatically kicking user Rose due to pt
2020-04-13 02:01:21,452 [http-bio-8080-exec-8] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: null
2020-04-13 02:01:21,453 [http-bio-8080-exec-8] ERROR org.hibernate.util.JDBCExceptionReporter - [SQLITE

from dockeryourxyzzy.

There is this file that seems to initialize the database, but perhaps it's not getting loaded?
https://github.com/ajanata/PretendYoureXyzzy/blob/master/cah_cards.sql

from dockeryourxyzzy.

Ah, I came in from an address that would let me visit carsets.jsp. I had to be on the server as 127.0.0.1 is allowed as administrator source so I used an ssh proxy to login to the server, and got a different error, pointing to the same root cause:
<snipped.....>
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: card_set)
org.sqlite.core.DB.newSQLException(DB.java:890)
org.sqlite.core.DB.newSQLException(DB.java:901)
org.sqlite.core.DB.throwex(DB.java:868)
org.sqlite.core.NativeDB.prepare(Native Method)
org.sqlite.core.DB.prepare(DB.java:211)......

It seems the database schema is not being set up in the SQLite database.

from dockeryourxyzzy.

Is there a functional way to set build.properties / admin IP via Docker environment variables?

from dockeryourxyzzy.

@joncamfield not that I'm aware of at the moment. Some ideas come to mind: it could be templated with something like Jinja2 at Docker image build-time, or the entire original build.properties could be ${env.VAR_NAME} parameterized.

I'm not sure if these ideas are better suited for this containerization or for the upstream project. Probably here, since upstream doesn't define environment at all.

https://stackoverflow.com/questions/25862071/accessing-os-environment-variables-from-jinja2-template - we could define an env prefix like BP_ and loop through everything.

from dockeryourxyzzy.