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
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
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
1 Like
Donations are always welcome ![:stuck_out_tongue_winking_eye: :stuck_out_tongue_winking_eye:](//forum.kontalk.org/images/emoji/twitter/stuck_out_tongue_winking_eye.png?v=5)
1 Like
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
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)
So that’s wrong ![:slight_smile: :slight_smile:](//forum.kontalk.org/images/emoji/twitter/slight_smile.png?v=5)
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.