MariaDB 5.5.x support? about schemaspy HOT 10 CLOSED

schemaspy.t=mariadb

# optional path to alternative jdbc drivers. 
schemaspy.dp=\drivers\mariadb-java-client-1.5.9.jar

# database properties: host, port number, name user, password
schemaspy.host=localhost
schemaspy.port=3306
schemaspy.db=database_name
schemaspy.u=root
schemaspy.p=password

# output dir to save generated files
schemaspy.o=\doc\schemaspy\output

# db scheme for which generate diagrams

schemaspy.charset=UTF-8

cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.1 (Maipo)

rpm -qa | egrep 'maria|galera'
mariadb-galera-server-5.5.41-2.el7ost.x86_64
galera-25.3.5-7.el7.x86_64
mariadb-5.5.41-2.el7_0.x86_64
mariadb-libs-5.5.41-2.el7_0.x86_64
mariadb-galera-common-5.5.41-2.el7ost.x86_64

mkdir tgdmead2_tmp
cd tgdmead2_tmp

$ vi mariadb.properties
description=MariaDB
driver=org.mariadb.jdbc.Driver
connectionSpec=jdbc:mysql://127.0.0.1:3306/sbmongodb
driverPath=/root/tgdmead2_tmp/mariadb-java-client-1.5.9.jar

wget -nd 'https://downloads.mariadb.com/Connectors/java/connector-java-1.5.9/mariadb-java-client-1.5.9.jar'
wget -nd 'https://github.com/schemaspy/schemaspy/releases/download/v6.0.0-rc1/schemaspy-6.0.0-rc1.jar'

yum -y install jre1.8.0_77.x86_64

yum -y install graphviz-java

/usr/java/jre1.8.0_77/bin/java -jar /root/tgdmead2_tmp/schemaspy-6.0.0-rc1.jar -t mariadb -dp /root/tgdmead2_tmp/mariadb-java-client-1.5.9.jar -db sbmongodb -host localhost -port 3306 -u root -p IamR00tDBA -o /root/tgdmead2_tmp/sbmongodb -charset=latin1
Apr 25, 2017 11:30:40 AM org.springframework.context.annotation.AnnotationConfigApplicationContext prepareRefresh
INFO: Refreshing org.springframework.context.annotation.AnnotationConfigApplicationContext@30dae81: startup date [Tue Apr 25 11:30:40 CEST 2017]; root of context hierarchy
Apr 25, 2017 11:30:40 AM org.schemaspy.Config loadProperties
INFO: Configuration file not found
Using database properties:
  /root/mariadb.properties

Failed to connect to database URL [jdbc:mysql://127.0.0.1:3306/sbmongodb]

java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'root'@'127.0.0.1' (using password: YES)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
        at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:135)
        at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
        at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:91)
        at org.mariadb.jdbc.Driver.connect(Driver.java:109)
        at org.schemaspy.DbDriverLoader.getConnection(DbDriverLoader.java:66)
        at org.schemaspy.service.SqlService.connect(SqlService.java:65)
        at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:197)
        at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:86)
        at org.schemaspy.Main.main(Main.java:52)
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not connect: Access denied for user 'root'@'127.0.0.1' (using password: YES)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:569)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:503)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:382)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:839)
        at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:479)
        at org.mariadb.jdbc.Driver.connect(Driver.java:104)
        ... 5 more
11:30:40.524 WARNING: Main.main - Connection Failure
org.schemaspy.model.ConnectionFailure: java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'root'@'127.0.0.1' (using password: YES)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
        at org.schemaspy.DbDriverLoader.getConnection(DbDriverLoader.java:92)
        at org.schemaspy.service.SqlService.connect(SqlService.java:65)
        at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:197)
        at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:86)
        at org.schemaspy.Main.main(Main.java:52)
Caused by: java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'root'@'127.0.0.1' (using password: YES)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
        at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:135)
        at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
        at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:91)
        at org.mariadb.jdbc.Driver.connect(Driver.java:109)
        at org.schemaspy.DbDriverLoader.getConnection(DbDriverLoader.java:66)
        ... 4 more
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not connect: Access denied for user 'root'@'127.0.0.1' (using password: YES)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:569)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:503)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:382)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:839)
        at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:479)
        at org.mariadb.jdbc.Driver.connect(Driver.java:104)
        ... 5 more

cat /etc/my.cnf.d/server.cnf
### MANAGED BY PUPPET ###

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[isamchk]
key_buffer_size = 16M

[mysqld]
basedir = /usr
bind-address = 0.0.0.0
datadir = /var/lib/mysql/data
default-storage-engine = InnoDB
expire_logs_days = 10
interactive_timeout = 2147483
key_buffer_size = 16M
log-error = /var/log/mariadb/mariadb.log
max_allowed_packet = 500M
max_binlog_size = 100M
max_connections = 15360
open_files_limit = 16384
pid-file = /var/run/mariadb/mariadb.pid
port = 3306
query_cache_limit = 1M
query_cache_size = 16M
skip-external-locking
socket = /var/lib/mysql/mysql.sock
ssl = false
ssl-ca = /etc/pki/galera/mysql.ca.crt
ssl-cert = /etc/pki/galera/mysql.crt
ssl-key = /etc/pki/galera/mysql.key
thread_cache_size = 8
thread_stack = 256K
tmpdir = /var/lib/mysql/tmp
user = mysql
wait_timeout = 2147483

[mysqld-5.0]
myisam-recover = BACKUP

[mysqld-5.1]
myisam-recover = BACKUP

[mysqld-5.5]
myisam-recover = BACKUP

[mysqld-5.6]
myisam-recover-options = BACKUP

[mysqld-5.7]
myisam-recover-options = BACKUP

[mysqld_safe]
log-error = /var/log/mariadb/mariadb.log
nice = 0
socket = /var/lib/mysql/mysql.sock

[mysqldump]
max_allowed_packet = 500M
quick
quote-names

cat /etc/my.cnf.d/galera.cnf | grep -v '^#'
[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
query_cache_type=1
bind-address=0.0.0.0
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_provider_options="socket.ssl=false"
wsrep_cluster_name="galera_cluster"
wsrep_cluster_address="gcomm://x,y,z
wsrep_slave_threads=1
wsrep_certify_nonPK=1
wsrep_max_ws_rows=131072
wsrep_max_ws_size=1073741824
wsrep_debug=0
wsrep_convert_LOCK_to_trx=0
wsrep_retry_autocommit=1
wsrep_auto_increment_control=1
wsrep_drupal_282555_workaround=0
wsrep_causal_reads=0
wsrep_notify_cmd=
wsrep_sst_method=rsync
wsrep_sst_auth=sst_user:gvzuvuuhuizhi
skip-name-resolve=1

# mysql --proto=tcp
ERROR 1045 (28000): Access denied for user 'root'@'127.0.0.1' (using password: YES)
# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 22329897
Server version: 5.5.41-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

junixsocket-common-2.0.4.jar
junixsocket-mysql-2.0.4.jar
junixsocket-native-2.0.4-x86_64-MacOSX-gpp-jni.nar <- Im on OSX
junixsocket-native-2.0.4.nar
mysql-connector-java-5.1.32.jar
native-lib-loader-2.1.5.jar
slf4j-api-1.7.25.jar
slf4j-simple-1.7.25.jar

extends=mysql

connectionSpec=jdbc:mysql://<host>/<db>?socketFactory=<socketFactory>&socket=<socket>
socketFactory=ClassName of socket factory which must be in your classpath
socket=Path To Socket

| schemaspy-6.0.0-rc1.jar
| mysql_socket.properties
+--\lib
+---| junixsocket-common-2.0.4.jar
+---| junixsocket-mysql-2.0.4.jar
+---| junixsocket-native-2.0.4-x86_64-MacOSX-gpp-jni.nar
+---| junixsocket-native-2.0.4.nar
+---| mysql-connector-java-5.1.32.jar
+---| native-lib-loader-2.1.5.jar
+---| slf4j-api-1.7.25.jar
+---| slf4j-simple-1.7.25.jar

java -jar schemaspy-6.0.0-rc1.jar \
 -t mysql_socket \
 -dp lib/mysql-connector-java-5.1.32.jar:lib/junixsocket-common-2.0.4.jar:lib/junixsocket-native-2.0.4-x86_64-MacOSX-gpp-jni.nar:lib/mysql-connector-java-5.1.32.jar:lib/junixsocket-mysql-2.0.4.jar:lib/junixsocket-native-2.0.4.nar:lib/native-lib-loader-2.1.5.jar:lib/slf4j-api-1.7.25.jar:lib/slf4j-simple-1.7.25.jar \
 -db [DBname] \
 -host localhost \
 -port 3306 \
 -u [User] \
 -socketFactory org.newsclub.net.mysql.AFUNIXDatabaseSocketFactory \
 -socket [path to socket] \
 -o [output dir]