About Create database

DeepChao · 2017-05-07 07:21:39 UTC

Hello,Daniele
this is Create database,can you help me to see it,
here “URL: password=root” isn’t my password,

    root@debian:~/my/kontalk/tigase-server$ java -cp "jars/*" tigase.util.DBSchemaLoader -dbHostname 127.0.0.1 -dbType mysql -schemaVersion 7-1 -dbName tigase -dbUser root -dbPass toor  -logLevel ALL -useSSL false
    LogLevel: ALL
    tigase.util.DBSchemaLoader     	 <init>          	 CONFIG     Properties: [{dbHostname=127.0.0.1, logLevel=ALL, dbType=mysql, rootUser=root, dbPass=toor, dbName=tigase, schemaVersion=7-1, rootPass=root, dbUser=root}]
    tigase.util.DBSchemaLoader     	 validateDBConnection 	 INFO       Validating DBConnection, URI: jdbc:mysql://127.0.0.1/?user=root&password=root
    tigase.util.DBSchemaLoader     	 validateDBConnection 	 WARNING    Access denied for user 'root'@'localhost' (using password: YES)
    tigase.util.DBSchemaLoader     	 validateDBExists 	 WARNING    Connection not validated
    tigase.util.DBSchemaLoader     	 validateDBSchema 	 WARNING    Connection not validated
    tigase.util.DBSchemaLoader     	 addXmppAdminAccount 	 WARNING    Connection not validated
    tigase.util.DBSchemaLoader     	 postInstallation 	 WARNING    Connection not validated
    tigase.util.DBSchemaLoader     	 printInfo       	 WARNING    Connection not validated

thinks ,
DeepChao

DeepChao · 2017-05-07 07:31:42 UTC

Do I need modified the two configuration files tigase-server etc/tigase.conf、etc/init.properties。

use ./scripts/db-create-mysql.sh root toor tigase root toor 127.0.0.1

to create database

DeepChao · 2017-05-07 13:28:54 UTC

Dear @daniele_athome,

I would like to thank you everyone for maintaining this lovely and wonderful project.
think you everyone help for me .i’m very happy that i maybe to complete.

android logcat:

05-07 21:11:16.506 22966-22966/org.kontalk.debug W/IInputConnectionWrapper: finishComposingText on inactive InputConnection
05-07 21:11:31.859 22966-13370/org.kontalk.debug E/NumberValidation: validation error.
                                                                     org.jivesoftware.smack.SmackException$NoResponseException: No response received within reply timeout. Timeout was 15000ms (~15s). Used filter: No filter used or filter was 'null'.
                                                                         at org.jivesoftware.smack.SynchronizationPoint.checkForResponse(SynchronizationPoint.java:253)
                                                                         at org.jivesoftware.smack.SynchronizationPoint.checkIfSuccessOrWait(SynchronizationPoint.java:146)
                                                                         at org.jivesoftware.smack.SynchronizationPoint.checkIfSuccessOrWaitOrThrow(SynchronizationPoint.java:125)
                                                                         at org.kontalk.client.XMPPTCPConnection.connectInternal(XMPPTCPConnection.java:857)
                                                                         at org.jivesoftware.smack.AbstractXMPPConnection.connect(AbstractXMPPConnection.java:364)
                                                                         at org.kontalk.service.XMPPConnectionHelper.connectOnce(XMPPConnectionHelper.java:196)
                                                                         at org.kontalk.service.XMPPConnectionHelper.connectOnce(XMPPConnectionHelper.java:145)
                                                                         at org.kontalk.client.NumberValidator.initConnection(NumberValidator.java:553)
                                                                         at org.kontalk.client.NumberValidator.run(NumberValidator.java:256)
                                                                         at java.lang.Thread.run(Thread.java:776)
05-07 21:11:31.864 22966-13378/org.kontalk.debug W/AbstractXMPPConnection: Connection closed with error
                                                                           org.jivesoftware.smack.XMPPException$StreamErrorException: host-unknown You can read more about the meaning of this stream error at http://xmpp.org/rfcs/rfc6120.html#streams-error-conditions
                                                                           <stream:error><host-unknown xmlns='urn:ietf:params:xml:ns:xmpp-streams'/></stream:error>
                                                                               at org.kontalk.client.XMPPTCPConnection$PacketReader.parsePackets(XMPPTCPConnection.java:1015)
                                                                               at org.kontalk.client.XMPPTCPConnection$PacketReader.access$300(XMPPTCPConnection.java:956)
                                                                               at org.kontalk.client.XMPPTCPConnection$PacketReader$1.run(XMPPTCPConnection.java:971)
                                                                               at java.lang.Thread.run(Thread.java:776)
05-07 21:11:31.912 22966-22966/org.kontalk.debug W/NumberValidator: shutting down
05-07 21:11:31.912 22966-22966/org.kontalk.debug W/NumberValidator: exiting
05-07 21:11:31.933 22966-22966/org.kontalk.debug I/HwPointEventFilter: support AFT
05-07 21:12:05.534 22966-22966/org.kontalk.debug W/IInputConnectionWrapper: finishComposingText on inactive InputConnection

thinks ,
DeepChao

webratte · 2017-05-07 16:58:59 UTC

Donations are always welcome

daniele_athome · 2017-05-08 09:17:09 UTC

I guess you succeeded to create the database.

The error above is caused by the XMPP service name (in the Android app, “Manual server address” preference) not matching the one you’ve configured in the server (etc/init.properties). Please note that the format of “Manual server address” preference in the Android app:

service_name|hostname:port

DeepChao · 2017-05-08 10:08:45 UTC

deer,daniele_athome

i’m sorry ,i set my Android app "Manual server address "----192.168.1.106|127.0.0.1:3306

but it not success.

05-08 18:03:37.691 9064-9064/org.kontalk.debug I/HwPointEventFilter: support AFT
05-08 18:03:37.700 9064-22930/org.kontalk.debug E/NumberValidation: validation error.
                                                                    org.jivesoftware.smack.SmackException$ConnectionException: The following addresses failed: '127.0.0.1:3306' failed because java.net.ConnectException: Connection refused
                                                                        at org.kontalk.client.XMPPTCPConnection.connectUsingConfiguration(XMPPTCPConnection.java:612)
                                                                        at org.kontalk.client.XMPPTCPConnection.connectInternal(XMPPTCPConnection.java:850)
                                                                        at org.jivesoftware.smack.AbstractXMPPConnection.connect(AbstractXMPPConnection.java:364)
                                                                        at org.kontalk.service.XMPPConnectionHelper.connectOnce(XMPPConnectionHelper.java:196)
                                                                        at org.kontalk.service.XMPPConnectionHelper.connectOnce(XMPPConnectionHelper.java:145)
                                                                        at org.kontalk.client.NumberValidator.initConnection(NumberValidator.java:553)
                                                                        at org.kontalk.client.NumberValidator.run(NumberValidator.java:256)
                                                                        at java.lang.Thread.run(Thread.java:776)
05-08 18:03:37.752 9064-9064/org.kontalk.debug W/NumberValidator: shutting down
05-08 18:03:37.752 9064-9064/org.kontalk.debug W/NumberValidator: exiting

my log : Address is already in use

2017-05-08 16:54:38.207 [ConnectionOpenThread]  ConnectionOpenThread.addAllWaiting()  WARNING: Error: creating connection for: {port-no=5270, local-host=media.prime.kontalk.net, remote-host=null, type=accept, socket=plain, ifc=[Ljava.lang.String;@403364e9, max-reconnects=7200000, repo-item=media.prime.kontalk.net:secret:accept:5270:null:null:tigase.server.ext.lb.ReceiverBareJidLB}
java.net.BindException: 地址已在使用
	at sun.nio.ch.Net.bind0(Native Method)
	at sun.nio.ch.Net.bind(Net.java:433)
	at sun.nio.ch.Net.bind(Net.java:425)
	at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223)
	at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
	at tigase.net.ConnectionOpenThread.addISA(ConnectionOpenThread.java:336)
	at tigase.net.ConnectionOpenThread.addPort(ConnectionOpenThread.java:371)
	at tigase.net.ConnectionOpenThread.addAllWaiting(ConnectionOpenThread.java:308)
	at tigase.net.ConnectionOpenThread.run(ConnectionOpenThread.java:237)
	at java.lang.Thread.run(Thread.java:748)
2017-05-08 16:54:38.221 [ConnectionOpenThread]  ConnectionOpenThread.addAllWaiting()  WARNING: Error: creating connection for: {type=accept, socket=plain, ifc=[Ljava.lang.String;@58a7dc4, remote-host=localhost, required=false, port-no=5999}
java.net.BindException: 地址已在使用
	at sun.nio.ch.Net.bind0(Native Method)
	at sun.nio.ch.Net.bind(Net.java:433)
	at sun.nio.ch.Net.bind(Net.java:425)
	at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223)
	at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
	at tigase.net.ConnectionOpenThread.addISA(ConnectionOpenThread.java:336)
	at tigase.net.ConnectionOpenThread.addPort(ConnectionOpenThread.java:371)
	at tigase.net.ConnectionOpenThread.addAllWaiting(ConnectionOpenThread.java:308)
	at tigase.net.ConnectionOpenThread.run(ConnectionOpenThread.java:237)
	at java.lang.Thread.run(Thread.java:748)
2017-05-08 16:54:38.222 [ConnectionOpenThread]  ConnectionOpenThread.addAllWaiting()  WARNING: Error: creating connection for: {type=accept, socket=plain, ifc=[Ljava.lang.String;@58a7dc4, remote-host=localhost, required=false, port-no=5222}
java.net.BindException: 地址已在使用
	at sun.nio.ch.Net.bind0(Native Method)
	at sun.nio.ch.Net.bind(Net.java:433)
	at sun.nio.ch.Net.bind(Net.java:425)
	at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223)
	at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
	at tigase.net.ConnectionOpenThread.addISA(ConnectionOpenThread.java:336)
	at tigase.net.ConnectionOpenThread.addPort(ConnectionOpenThread.java:371)
	at tigase.net.ConnectionOpenThread.addAllWaiting(ConnectionOpenThread.java:308)
	at tigase.net.ConnectionOpenThread.run(ConnectionOpenThread.java:237)
	at java.lang.Thread.run(Thread.java:748)
2017-05-08 16:54:38.223 [ConnectionOpenThread]  ConnectionOpenThread.addAllWaiting()  WARNING: Error: creating connection for: {socket=ssl, type=accept, ifc=[Ljava.lang.String;@58a7dc4, remote-host=localhost, required=false, port-no=5223}
java.net.BindException: 地址已在使用
	at sun.nio.ch.Net.bind0(Native Method)
	at sun.nio.ch.Net.bind(Net.java:433)
	at sun.nio.ch.Net.bind(Net.java:425)
	at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223)
	at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
	at tigase.net.ConnectionOpenThread.addISA(ConnectionOpenThread.java:336)
	at tigase.net.ConnectionOpenThread.addPort(ConnectionOpenThread.java:371)
	at tigase.net.ConnectionOpenThread.addAllWaiting(ConnectionOpenThread.java:308)
	at tigase.net.ConnectionOpenThread.run(ConnectionOpenThread.java:237)
	at java.lang.Thread.run(Thread.java:748)
2017-05-08 16:54:38.224 [ConnectionOpenThread]  ConnectionOpenThread.addAllWaiting()  WARNING: Error: creating connection for: {socket=ssl, type=accept, ifc=[Ljava.lang.String;@58a7dc4, remote-host=localhost, required=false, port-no=8443}
java.net.BindException: 地址已在使用
	at sun.nio.ch.Net.bind0(Native Method)
	at sun.nio.ch.Net.bind(Net.java:433)
	at sun.nio.ch.Net.bind(Net.java:425)
	at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223)
	at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
	at tigase.net.ConnectionOpenThread.addISA(ConnectionOpenThread.java:336)
	at tigase.net.ConnectionOpenThread.addPort(ConnectionOpenThread.java:371)
	at tigase.net.ConnectionOpenThread.addAllWaiting(ConnectionOpenThread.java:308)
	at tigase.net.ConnectionOpenThread.run(ConnectionOpenThread.java:237)
	at java.lang.Thread.run(Thread.java:748)

daniele_athome · 2017-05-11 08:34:32 UTC

So that’s wrong
You’ll have to use the domain name you set in init.properties (in --virt-hosts) then pipe (|) then hostname:port of the actual host you’ll be connecting to.

The second error is due to two instances of the server running or a listen port conflict with some other services.

I’d like to remind you that running a Kontalk server requires a minimal set of Linux administration skills, which I’m afraid (and forgive me for being blunt) you’re not showing… besides, the Kontalk server hasn’t a 100% automatic installation because we want users to be aware of what they are doing.