· 9 years ago · Jun 20, 2017, 07:52 PM
1Last login: Mon Jun 19 18:29:55 on ttys001
2Tests-MacBook:~ me_irl$ cd pxls
3Tests-MacBook:pxls me_irl$ java -jar target/pxls-1.0-SNAPSHOT.jar
4Warning: Cannot find board.dat in working directory, using blank board
5Warning: Cannot find heatmap.dat in working directory, using blank heatmap
6SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
7SLF4J: Defaulting to no-operation (NOP) logger implementation
8SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
9Exception in thread "main" com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: url parsing error : '//' is not present in the url jdbc:mysql:3306
10 at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:544)
11 at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:536)
12 at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
13 at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
14 at space.pxls.data.Database.<init>(Database.java:42)
15 at space.pxls.App.main(App.java:73)
16Caused by: java.sql.SQLException: url parsing error : '//' is not present in the url jdbc:mysql:3306
17 at org.mariadb.jdbc.UrlParser.parseInternal(UrlParser.java:204)
18 at org.mariadb.jdbc.UrlParser.parse(UrlParser.java:152)
19 at org.mariadb.jdbc.Driver.connect(Driver.java:95)
20 at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
21 at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
22 at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:356)
23 at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:199)
24 at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:444)
25 at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:515)
26 ... 4 more
27Tests-MacBook:pxls me_irl$ java -jar target/pxls-1.0-SNAPSHOT.jar
28Warning: Cannot find board.dat in working directory, using blank board
29Warning: Cannot find heatmap.dat in working directory, using blank heatmap
30SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
31SLF4J: Defaulting to no-operation (NOP) logger implementation
32SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
33Exception in thread "main" com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not connect: Access denied for user 'admin'@'localhost' to database 'pxls'
34 at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:544)
35 at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:536)
36 at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
37 at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
38 at space.pxls.data.Database.<init>(Database.java:42)
39 at space.pxls.App.main(App.java:73)
40Caused by: java.sql.SQLSyntaxErrorException: Could not connect: Access denied for user 'admin'@'localhost' to database 'pxls'
41 at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139)
42 at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
43 at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:91)
44 at org.mariadb.jdbc.Driver.connect(Driver.java:109)
45 at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
46 at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
47 at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:356)
48 at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:199)
49 at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:444)
50 at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:515)
51 ... 4 more
52Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not connect: Access denied for user 'admin'@'localhost' to database 'pxls'
53 at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:571)
54 at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:503)
55 at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:382)
56 at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:839)
57 at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:479)
58 at org.mariadb.jdbc.Driver.connect(Driver.java:104)
59 ... 10 more
60Tests-MacBook:pxls me_irl$ java -jar target/pxls-1.0-SNAPSHOT.jar
61Warning: Cannot find board.dat in working directory, using blank board
62Warning: Cannot find heatmap.dat in working directory, using blank heatmap
63SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
64SLF4J: Defaulting to no-operation (NOP) logger implementation
65SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
66Creating new mariadb connection...
67space.pxls.data.Database$DatabaseHandle@44a7bfbc
68Exception in thread "main" org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: java.sql.SQLSyntaxErrorException: (conn:5) Invalid default value for 'time'
69Query is: CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent'; [statement:"CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';", located:"CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';", rewritten:"CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';", arguments:{ positional:{}, named:{}, finder:[]}]
70 at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1338)
71 at org.skife.jdbi.v2.Update.execute(Update.java:56)
72 at org.skife.jdbi.v2.sqlobject.UpdateHandler$2.value(UpdateHandler.java:67)
73 at org.skife.jdbi.v2.sqlobject.UpdateHandler.invoke(UpdateHandler.java:79)
74 at org.skife.jdbi.v2.sqlobject.SqlObject.invoke(SqlObject.java:224)
75 at org.skife.jdbi.v2.sqlobject.SqlObject$3.intercept(SqlObject.java:133)
76 at org.skife.jdbi.v2.sqlobject.CloseInternalDoNotUseThisClass$$EnhancerByCGLIB$$e05fe74.createPixelsTable(<generated>)
77 at space.pxls.data.Database.<init>(Database.java:45)
78 at space.pxls.App.main(App.java:73)
79Caused by: java.sql.SQLSyntaxErrorException: (conn:5) Invalid default value for 'time'
80Query is: CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';
81 at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139)
82 at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
83 at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)
84 at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:226)
85 at org.mariadb.jdbc.MariaDbClientPreparedStatement.executeInternal(MariaDbClientPreparedStatement.java:233)
86 at org.mariadb.jdbc.MariaDbClientPreparedStatement.execute(MariaDbClientPreparedStatement.java:163)
87 at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
88 at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
89 at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1327)
90 ... 8 more
91Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Invalid default value for 'time'
92Query is: CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';
93 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1144)
94 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1076)
95 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1031)
96 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:203)
97 at org.mariadb.jdbc.MariaDbClientPreparedStatement.executeInternal(MariaDbClientPreparedStatement.java:224)
98 ... 12 more
99Tests-MacBook:pxls me_irl$