Newbie problems

Openfire Openfire Support
1

Hello All,

Sorry in advance for these most probably newbie questions but I ran into some problems, I downloaded the latest version of wildfire and spark installed it on a suse 9.3 machine with mysql and installed spark on 2 windows 2000 machine, I also created a group called staff and added every user into that group and enabled sharing group in rosters.

Logging into the system works perhaps a bit slow, but then nothing else seems to work when I then log someone else in on another client then they can’'t see eachother changing status from offline to online if i try to send a message then it says something like it the user will recive the message when he/she goes oneline but no message gets shown to the user.

Does anybody have any idea where I am going rong here.

Regards

Per

2

try to get some log files, so we have more informations.

3

Ok here is the error log:

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.access$300(OutgoingSess ionPromise.java:37)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise$1$1.run(OutgoingSession Promise.java:91)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2006.01.31 16:50:02 org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(Out goingServerSession.java:258) Error trying to connect to remote server: za(DNS lookup: za:5269)

java.net.UnknownHostException: za

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(Ou tgoingServerSession.java:253)

at org.jivesoftware.wildfire.server.OutgoingServerSession.authenticateDomain(Outgo ingServerSession.java:182)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.createSessionAndSendPac ket(OutgoingSessionPromise.java:126)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.access$300(OutgoingSess ionPromise.java:37)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise$1$1.run(OutgoingSession Promise.java:91)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2006.01.31 16:50:57 org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(Out goingServerSession.java:258) Error trying to connect to remote server: berggasoline.co.za(DNS lookup: berggasoline.co.za:5269)

java.net.SocketTimeoutException: connect timed out

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.PlainSocketImpl.doConnect(Unknown Source)

at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(Ou tgoingServerSession.java:253)

at org.jivesoftware.wildfire.server.OutgoingServerSession.authenticateDomain(Outgo ingServerSession.java:139)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.createSessionAndSendPac ket(OutgoingSessionPromise.java:126)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.access$300(OutgoingSess ionPromise.java:37)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise$1$1.run(OutgoingSession Promise.java:91)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2006.01.31 16:50:58 org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(Out goingServerSession.java:258) Error trying to connect to remote server: co.za(DNS lookup: co.za:5269)

java.net.ConnectException: Connection refused

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.PlainSocketImpl.doConnect(Unknown Source)

at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(Ou tgoingServerSession.java:253)

at org.jivesoftware.wildfire.server.OutgoingServerSession.authenticateDomain(Outgo ingServerSession.java:182)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.createSessionAndSendPac ket(OutgoingSessionPromise.java:126)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.access$300(OutgoingSess ionPromise.java:37)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise$1$1.run(OutgoingSession Promise.java:91)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

And the warn log:

2006.01.31 13:03:11 Asterisk-IM table contains errors exited with error, database may not behave properly

2006.01.31 13:03:11 Asterisk-IM table creation --> Table ‘‘wildfire.phoneDevice’’ doesn’'t exist

java.sql.SQLException: Table ‘‘wildfire.phoneDevice’’ doesn’'t exist

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)

at com.mysql.jdbc.Statement.executeUpdate(Statement.java:935)

at com.mysql.jdbc.Statement.executeUpdate(Statement.java:873)

at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:145)

at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:99)

at org.jivesoftware.phone.database.HibernateUtil.initDB(HibernateUtil.java:150)

at org.jivesoftware.phone.asterisk.AsteriskPlugin.init(AsteriskPlugin.java:107)

at org.jivesoftware.phone.asterisk.AsteriskPlugin.initializePlugin(AsteriskPlugin. java:92)

at org.jivesoftware.wildfire.container.PluginManager.loadPlugin(PluginManager.java :281)

at org.jivesoftware.wildfire.container.PluginManager.access$200(PluginManager.java :48)

at org.jivesoftware.wildfire.container.PluginManager$PluginMonitor.run(PluginManag er.java:658)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)

at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101 (Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodi c(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

And the info log:

2006.01.30 19:59:37 Wildfire 2.4.4

2006.01.30 19:59:42 Admin console listening at:

http://127.0.0.1:9090

https://127.0.0.1:9091

2006.01.30 19:59:45 Wildfire 2.4.4

2006.01.31 12:17:35 Started server (unencrypted) socket on port: 5269

2006.01.31 12:17:35 Started plain (unencrypted) socket on port: 5222

2006.01.31 12:17:36 Started SSL (encrypted) socket on port: 5223

2006.01.31 12:17:36 Multi User Chat domain: conference.gateway

2006.01.31 13:03:08 Initializing Asterisk-IM Plugin

2006.01.31 13:03:08 Initializing Hibernate for Asterisk-IM

2006.01.31 13:03:10 Checking to see if Asterisk-IM database schema is present

2006.01.31 13:03:10 Installing Asterisk-IM database schema

2006.01.31 13:03:10 Installing phone plugin database

2006.01.31 13:03:11 Initializing Asterisk-IM thread Pool

2006.01.31 13:04:04 unloading asterisk-im plugin resources

2006.01.31 13:04:04 Unregistering asterisk-im plugin as a component

2006.01.31 13:04:04 Closing Asterisk Manager Connection

2006.01.31 13:04:04 Shutting down Asterisk-IM Thread Pool

2006.01.31 13:04:04 Shutting down Hibernate for Asterisk-IM

2006.01.31 13:04:04 Wildfire stopped

2006.01.31 13:04:04 Server halted

2006.01.31 13:04:12 Started server (unencrypted) socket on port: 5269

2006.01.31 13:04:12 Started plain (unencrypted) socket on port: 5222

2006.01.31 13:04:13 Started SSL (encrypted) socket on port: 5223

2006.01.31 13:04:13 Multi User Chat domain: conference.gateway

2006.01.31 13:04:14 Wildfire 2.4.4

2006.01.31 13:04:18 Admin console listening at:

http://gateway:9090

https://gateway:9091

2006.01.31 13:04:18 Initializing Asterisk-IM Plugin

2006.01.31 13:04:18 Initializing Hibernate for Asterisk-IM

2006.01.31 13:04:21 Checking to see if Asterisk-IM database schema is present

2006.01.31 13:04:21 Ensuring Asterisk-IM schema is up to date

2006.01.31 13:04:21 Updating phone plugin database

I hope that you can find the anserw here some where.

Regards

4

here is also the debug log:

line

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

2006.01.31 20:27:16 OS - Trying to connect to co.za:5269

2006.01.31 20:27:33 OS - Trying to connect to za:5269

2006.01.31 20:27:46 Error sending packet to remote server:

java.lang.Exception: Failed to create connection to remote server

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.createSessionAndSendPac ket(OutgoingSessionPromise.java:139)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.access$300(OutgoingSess ionPromise.java:37)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise$1$1.run(OutgoingSession Promise.java:91)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

5

Hi qvindesland

I don’'t know how good you are with linux enviroment and mysql. My advice would be that if you are just testing the server for the time being, try to work in the comfortable enviroment first. I have found some warning regarding Mysql and Asterisk IM plugins. Try to use the embeded Database first. if you need “Asterik IM Plugins” , I would suggest to start using it when your basic server is up and running well. I would not suggest to try out plugins when you have a hard time running your basic server.

Regards,

wmhtet

6

why is one of your users conecting on berggasoline.co.za server?

I have noticed your server name is gateway.

can you tell more about that?

I would also try to tune the server without the asterisk plugin. Then you can implement the plugins.

7

LukeM and wmhtet both of your suggestions where spot on, I was not sure how to get the plugins sorted to I removed the program, rebooted the server and installed the rpm file again which took care of the whole problem, since I am using the mysql database and I decided to try to just connect to the mysql db again without dropping the database (which saved me a lot of time) so now it works without any plugins at all.

Thanks a lot guys for all your help.

Regards

Per

8

qvindesland

Now you can try plugin if you like but I would suggest to start with “content filter” since it is simple. But for Asterik IM, it can be another project because you need to work with your underlying telephone infrastructure.

regards,

wmhtet