Official Community Forums
 
HomeHome  FAQFAQ  SearchSearch  MemberlistMemberlist  UsergroupsUsergroups  RegisterRegister  Log in  The Wiki  Website  github Project  

Share | 
 

 message from server: "Too many connections"

View previous topic View next topic Go down 
AuthorMessage
DaddyM0E
Experienced Newbie
Experienced Newbie


Posts : 13
Join date : 2011-09-25
Location : Crosby, Texas

PostSubject: message from server: "Too many connections"   Sat 22 Oct - 0:29

Win Vista Home premium SP2.
Trying to run sampleworld.

Modified the logfile to only report errors. This is what the "startup_error.out" has in it.


ERROR [2011-10-21 08:00:22,679] main Engine.main: error connecting to the database multiverse.server.util.MVRuntimeException: could not connect to database: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" multiverse.server.util.MVRuntimeException: could not connect to database: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections"
at multiverse.server.engine.Database.connect(Database.java:112)
at multiverse.server.engine.Engine.main(Engine.java:341)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at multiverse.server.marshalling.Trampoline.main(Trampoline.java:150)

I have followed the Wiki startup and configs as per the instructions with one exception, I am using "mysql-connector-java-5.0.8-bin.jar" and have specified as much in the multiverse.properties file. There *is* a warning posted in the Wiki setup regarding which Java version to use with Vista, but I do not know how old or accurate it is...

"If you are using Windows Vista, you must use MySQL version 5 and disable User Account Control (UAC). See http://port25.technet.com/videos/research/MySQL_Windows.pdf for more information."

Could this be the root of the problem? Do I need to post other logs? Just tell what we need to give you the information we need to get this fixed and I'll be happy to oblige.
Back to top Go down
Delurin
Head of Platform Development


Posts : 424
Join date : 2011-08-03

PostSubject: Re: message from server: "Too many connections"   Sat 22 Oct - 0:55

I tried switching over to the most recent mysql-connector (5.1.14) and had no trouble. And I checked the java version we are using 1.6.0_06. We are using vista 64bit home premium although I have not updated it to sp2. and we are using MySQL 5.0.51/Client5.1.11 but I did not disable UAC. Are you using the bat file or cygwin? Most developers in the past have used cygwin to get used to it and so that later on they can switch the server over to a linux machine. Have you verified that you database is setup correctly and that you put the correct database info into the multiverse.properties file?
Back to top Go down
DaddyM0E
Experienced Newbie
Experienced Newbie


Posts : 13
Join date : 2011-09-25
Location : Crosby, Texas

PostSubject: Re: message from server: "Too many connections"   Sat 22 Oct - 2:07

Have Java version 1.7.0 now that I've updated it.
Mysql connector updated to mysql-connector-java-5.1.18-bin and changed in multiverse.properties file.

Using .bat file, not cygwin.

mysql shows the tables as being created when queried.
Setting up the database should have taken care if itself if there were no errors reported upon creation and query reports the tables.
Now, as for the multiverse props file. There is a good posibility I have somthing wrong in there. I'll post what I have and lets hope it's just somthing silly.

First: my startup_error.out file has changed to:
ERROR [2011-10-21 09:42:24,264] main Engine.main: error connecting to the database multiverse.server.util.MVRuntimeException: could not find class: com.mysql.jdbc.Driver multiverse.server.util.MVRuntimeException: could not find class: com.mysql.jdbc.Driver
at multiverse.server.engine.Database.<init>(Database.java:61)
at multiverse.server.engine.Engine.main(Engine.java:337)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at multiverse.server.marshalling.Trampoline.main(Trampoline.java:150)

and Login_manager_error.out showing the same:
ERROR [2011-10-21 09:42:23,369] main Engine.main: error connecting to the database multiverse.server.util.MVRuntimeException: could not find class: com.mysql.jdbc.Driver multiverse.server.util.MVRuntimeException: could not find class: com.mysql.jdbc.Driver
at multiverse.server.engine.Database.<init>(Database.java:61)
at multiverse.server.engine.Engine.main(Engine.java:337)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at multiverse.server.marshalling.Trampoline.main(Trampoline.java:150)


MULTIVERSE.PROPERTIES FILE

### Server host names and ports
multiverse.msgsvr_hostname=localhost
multiverse.msgsvr_port=20374
multiverse.worldmgrport=5040
### Proxy server settings. To enable remote clients to connect, specify IP address or DNS hostname
multiverse.proxyserver=:same
multiverse.proxyport=5050

### Voice server host and port number
multiverse.voiceserver=:same
multiverse.voiceport=5051

### Options for VoiceServer testing

### Should the voice plugin automatically create a positional and/or
### non-positional voice group(s) with the specified numbers?
multiverse.precreated_positional_voice_group=1
#multiverse.precreated_nonpositional_voice_group=5

### Should it auto-create a nonpositional voice group because a client
### connects with the number of a group and the group doesn't exist?
#multiverse.autocreate_referenced_voice_groups=true

###
### Should the voice server record voices?
###
#multiverse.record_voices=true

### Database settings
### Use multiverse.db_url property to use a specific JDBC URL. If not specified, then
### the server constructs it in standard format from the other property values,
### as follows jdbc://db_type/db_hostname/db_name
multiverse.db_type=mysql
multiverse.db_driver=com.mysql.jdbc.Driver
multiverse.db_name=multiverse
multiverse.db_user=root
multiverse.db_password=test
multiverse.db_hostname=localhost
### multiverse.db_url=jdbc:dbtype://hostName/databaseName

# specifies how long to wait for all plugin dependencies to be
# resolved. after waiting this period of time (in seconds),
# if all dependencies have not been met, then we report an error message.
multiverse.startup_timeout=120

#Path to JDBC driver JAR file
# multiverse.jdbcJarPath=../other/mysql-jdbc/mysql-connector-java-3.0.14-production-bin.jar
multiverse.jdbcJarPath=c:\\mysql-connector-java-5.1.18-bin\\mysql-connector-java-5.1.18-bin.jar


###
### If multiverse.mvwfile property is not specified, it defaults to MV_HOME/config/worldname/worldname.mvw
### Example below is Windows path; On Linux/Unix, use forward slashes instead of double backslashes.
multiverse.worldname=sampleworld
###multiverse.mvwfile=c:\\multiverse\\config\\sampleworld\\sampleworld.mvw

###
### The default log level of the server.
###
### MV-Level log4j Level
### 0 TRACE
### 1 DEBUG
### 2 INFO
### 3 WARN
### 4 ERROR
###
multiverse.log_level=1
multiverse.rotate_logs_on_startup=true

###
### Should old logs be deleted on startup?
###
#multiverse.delete_logs_on_startup=true

###
### log4j configuration. The multiverse.log_level over-rides the
### log4j log level.
###
log4j.appender.FILE = org.apache.log4j.RollingFileAppender
log4j.appender.FILE.File = ${multiverse.logs}/${multiverse.loggername}.out
log4j.appender.FILE.MaxFileSize = 50MB
log4j.appender.FILE.MaxBackupIndex=3
log4j.appender.FILE.layout=org.apache.log4j.PatternLayout
log4j.appender.FILE.layout.ConversionPattern=%-5p [%d{ISO8601}] %-20t %m%n

#log4j.rootLogger=DEBUG, FILE

#log4j.appender.ErrorLog = org.apache.log4j.RollingFileAppender
#log4j.appender.ErrorLog.Threshold = ERROR
#log4j.appender.ErrorLog.File = ${multiverse.logs}/errors.out
#log4j.appender.ErrorLog.MaxFileSize = 50MB
#log4j.appender.ErrorLog.MaxBackupIndex=3
#log4j.appender.ErrorLog.layout=org.apache.log4j.PatternLayout
#log4j.appender.ErrorLog.layout.ConversionPattern=%-5p [%d{ISO8601}] %-20t %m%n


###
### Special Error check file
###
log4j.appender.ERRFILE = org.apache.log4j.RollingFileAppender
log4j.appender.ERRFILE.File = ${multiverse.logs}/${multiverse.loggername}_error.out
log4j.appender.ERRFILE.MaxFileSize = 50MB
log4j.appender.ERRFILE.MaxBackupIndex=1
log4j.appender.ERRFILE.Threshold=ERROR
log4j.appender.ERRFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.ERRFILE.layout.ConversionPattern=%-5p [%d{ISO8601}] %-20t %m%n

log4j.rootLogger=DEBUG, FILE, ERRFILE


###
### Should we use class files from the /build hierarchy
### instead of the jar files from the /dist hierarchy?
###
#multiverse.use_class_files=true

###
### Should we log histograms of time-in-queue and processing time
### for proxy messages? If so, what should the reporting interval
### be? (Defaults to 5000ms).
###
multiverse.log_proxy_histograms=true
#multiverse.log_proxy_histograms_interval=5000

###
### The default when enabled is to log CPU times an interval of
### 5000 ms, at log_level 2, which is INFO
###
#multiverse.cputime_logging_interval=5000,2

###
### This number is the number of maximum milliseconds that the
### packet aggregator will delay sending a packet in hopes that
### more packets can be added to it. By default, it is 25ms.
### You can change the delay time, or disable packet aggregation
### by setting the aggregation interval is zero
###
#multiverse.packet_aggregation_interval=0

###
### Maximum objects per quad tree node before dividing.
###
#multiverse.quad_tree_node_max_objects=30

###
### Maximum depth of the quad tree. Should be less than 32.
###
#multiverse.quad_tree_max_depth=20

### Plugin type startup dependencies
### Dependencies are expressed in terms of plugin types, not plugin names.
### The dependency is satisfied when the expected number of plugins have
### started. The number of expected plugins is controlled by flags to
### the DomainServer (see PLUGIN_TYPES in multiverse.sh)
###
### Every plugin type should have a "plugin_dep" property, even if it
### has no dependencies.
multiverse.plugin_dep.Login=ObjectManager,Instance
multiverse.plugin_dep.Instance=ObjectManager,Quest,MobManager,Inventory,WorldManager
multiverse.plugin_dep.Proxy=Instance,Voice
multiverse.plugin_dep.Voice=Instance
multiverse.plugin_dep.MobManager=ObjectManager,WorldManager,Inventory,Quest
multiverse.plugin_dep.sampleworld.MobManager=ObjectManager,WorldManager,Inventory,Quest,Combat
multiverse.plugin_dep.ObjectManager=
multiverse.plugin_dep.WorldManager=
multiverse.plugin_dep.Inventory=
multiverse.plugin_dep.Quest=
multiverse.plugin_dep.Trainer=
multiverse.plugin_dep.ClassAbility=
multiverse.plugin_dep.Combat=
multiverse.plugin_dep.Startup=Instance,Proxy,Voice

multiverse.buildNumber=1063
multiverse.buildString=GA
multiverse.buildDate=20080623.171257


Note: the first two lines of the install.sql file have been changed, nothing else:
-- create a database called multiverse
create database sampleworld;

-- switch to the multiverse database
use sampleworld;
Back to top Go down
Delurin
Head of Platform Development


Posts : 424
Join date : 2011-08-03

PostSubject: Re: message from server: "Too many connections"   Sat 22 Oct - 2:17

hmm what does it display when you type in java -showversion into your command prompt?
Back to top Go down
DaddyM0E
Experienced Newbie
Experienced Newbie


Posts : 13
Join date : 2011-09-25
Location : Crosby, Texas

PostSubject: Re: message from server: "Too many connections"   Sat 22 Oct - 2:25

java version "1.7.0"
Java(TM) SE Runtime Environment (build 1.7.0-b147)
Java HotSpot(TM) Client VM (build 21.0-b17, mixed mode, sharing)

Edit: Had copied and pasted new Java path in and it had the "-bin" at end of directoty path. fixed that and am now back to...


ERROR [2011-10-21 10:48:41,932] main encacheNamespaceMapping com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'multiverse.namespaces' doesn't exist com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'multiverse.namespaces' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
at multiverse.server.engine.Database.encacheNamespaceMapping(Database.java:217)
at multiverse.server.engine.Namespace.encacheNamespaceMapping(Namespace.java:161)
at multiverse.server.engine.Engine.main(Engine.java:360)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at multiverse.server.marshalling.Trampoline.main(Trampoline.java:150)

re queried sampleworld database, shows 5 rows, no errors. the "Namespaces" table *is* in the list. Also, Mysql is runing as a service so I dont have to call it every time.
Back to top Go down
DaddyM0E
Experienced Newbie
Experienced Newbie


Posts : 13
Join date : 2011-09-25
Location : Crosby, Texas

PostSubject: Got it!    Sat 22 Oct - 3:10

The problem was in the multiverse.properties file.

### Database settings
### Use multiverse.db_url property to use a specific JDBC URL. If not specified, then
### the server constructs it in standard format from the other property values,
### as follows jdbc://db_type/db_hostname/db_name
multiverse.db_type=mysql
multiverse.db_driver=com.mysql.jdbc.Driver
multiverse.db_name=sampleworld <-- this was wrong, was still set to multiverse...silly me.
multiverse.db_user=root
multiverse.db_password=test
multiverse.db_hostname=localhost

Time to login and see if my client works. (Please work!! Please for the sake of my sanity...work!")
Back to top Go down
Delurin
Head of Platform Development


Posts : 424
Join date : 2011-08-03

PostSubject: Re: message from server: "Too many connections"   Sat 22 Oct - 3:16

I left the name of the db as multiverse so I would not have picked up on that
Back to top Go down
Sponsored content




PostSubject: Re: message from server: "Too many connections"   

Back to top Go down
 
message from server: "Too many connections"
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» Server connection errors
» -ses.[D]onDorty+
» .^f2F-.Swemmei Recruting in server 1
» Lag playing in Taiwan server from Shanghai
» Imperial Guard Message Board

Permissions in this forum:You cannot reply to topics in this forum
 :: Development :: Getting Started-
Jump to: