Mysql problem

Openfire Openfire Support
1

I installed wildfire 3.1.1 with mysql ,and create database using

CREATE DATABASE wildfire DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

so I finished wildfire installing ,and he works well,

but when I restart computer,then start wildfire mannully.he can’'t work.

accounts can’'t login in,and I can use admin consoles

wishes know my bad english

2

Hi,

you should see errors in the log files of Wildfire, look at them and post them here.

LG

3

thanks for LG

logs as follow:

at org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.j ava:44)

at org.jivesoftware.wildfire.net.SocketAcceptThread.run(SocketAcceptThread.java:11 5)

2006.12.05 04:47:17 org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.ja va:57) ???

java.net.SocketException: Too many open files

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

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

at java.net.ServerSocket.implAccept(Unknown Source)

at java.net.ServerSocket.accept(Unknown Source)

at org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.j ava:44)

at org.jivesoftware.wildfire.net.SocketAcceptThread.run(SocketAcceptThread.java:11 5)

2006.12.05 04:47:17 org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.ja va:57) ???

java.net.SocketException: Too many open files

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

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

at java.net.ServerSocket.implAccept(Unknown Source)

at java.net.ServerSocket.accept(Unknown Source)

at org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.j ava:44)

at org.jivesoftware.wildfire.net.SocketAcceptThread.run(SocketAcceptThread.java:11 5)

2006.12.05 04:47:17 org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.ja va:57) ???

java.net.SocketException: Too many open files

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

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

at java.net.ServerSocket.implAccept(Unknown Source)

at java.net.ServerSocket.accept(Unknown Source)

at org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.j ava:44)

at org.jivesoftware.wildfire.net.SocketAcceptThread.run(SocketAcceptThread.java:11 5)

2006.12.05 04:47:17 org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.ja va:57) ???

java.net.SocketException: Too many open files

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

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

at java.net.ServerSocket.implAccept(Unknown Source)

at java.net.ServerSocket.accept(Unknown Source)

at org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.j ava:44)

at org.jivesoftware.wildfire.net.SocketAcceptThread.run(SocketAcceptThread.java:11 5)

2006.12.05 04:47:17 org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.ja va:57) ???

java.net.SocketException: Too many open files

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

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

at java.net.ServerSocket.implAccept(Unknown Source)

at java.net.ServerSocket.accept(Unknown Source)

at org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.j ava:44)

at org.jivesoftware.wildfire.net.SocketAcceptThread.run(SocketAcceptThread.java:11 5)

2006.12.05 04:47:17 org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.ja va:57) ???

java.net.SocketException: Too many open files

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

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

at java.net.ServerSocket.implAccept(Unknown Source)

at java.net.ServerSocket.accept(Unknown Source)

at org.jivesoftware.wildfire.net.BlockingAcceptingMode.run(BlockingAcceptingMode.j ava:44)

at org.jivesoftware.wildfire.net.SocketAcceptThread

4

Hi,

please post the first exception, it seems that the “Too many open files” errors are just follow-up errors. You could increase the ulimits to get rid of them but this would not solve the main problem.

LG

5

Hi LG

I see the error log and there are all the error like

java.net.SocketException: Too many open files

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

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

at java.net.ServerSocket.implAccept(Unknown Source)

at java.net.ServerSocket.accept(Unknown Source)

I use tsung to start a stress test on wildfire.

the mysql problem has solved but in mysql console It aslo can’'t show

chinese correctly.and users can login throught pandion and other clients

The problem now is that my server only can establish 1000± users

,is that the os’'s limits?

I use ubuntu server 6.10,and mysql 5.0,install wildfire from .tar.gz

jre1.5

thanks

6

Hi,

run “ulimit -a” as the user which runs Wildfire - you should see a line like “open files 1024”. You could increase it to 2000 to get rid of this error.

As long as you have enough memory available and enough TCP ports available you’'ll not hit a limit.

LG

7

Hi

thanks for your reply LG

I will have a try

BTW

my server is running on DELL PE 1850 ,2 xeon 3.0 cups,3.5G RAM,2 1G eths.

is there a hardware limits on my server?

thanks

Message was edited by: dweng

8

Hi dweng,

as I don’‘t use tsung to do stress tests I’'m not sure if you hit a hardware limit with your server. It also depends on the type of your test, just login/logout, p2p-chats, MUC, rosters, pubsub, …

But 3,5 GB memory should last for a while. There are some more posts about tsung in the Widlfire dev forum.

LG

9

Hi LG

here is my tsung config file:

I just do stress test in these steps.

and i modify the server’'s limits,now one process can open 65535 files.but the problem still alive,

any suggestion?

Thanks