Trying to start MySQL server failed on Suse linux 10.1

Trying to start MySQL server failed on Suse linux 10.1

Hi,

On my linux Suse 10.1 System, the server has trouble starting up, below are the log files and screen output. What's going wrong?

thanks,
Arno

Run-script returns:

barnies:/usr/server/Zoho/VirtualOffice/bin # sh run.sh
================================================================================

JBoss Bootstrap Environment

JBOSS_HOME: /usr/server/Zoho/VirtualOffice

JAVA: ./../jre/bin/java

JAVA_OPTS: -server -Xms256m -Xmx512m -Dfile.encoding=utf8 -Dprogram.name=run.sh -Djboss.server.type=com.adventnet.j2ee.deployment.system.AdventNetServerImpl -Djboss.deploy.localcopy=true -Djboss.boot.library.list=log4j-boot.jar,jboss-common.jar,jboss-system.jar,AdventNetDeploymentSystem.jar,commons-logging.jar -Ddb.home=./../mysql -Dorg.jboss.logging.Log4jService.catchSystemOut=false -Dorg.jboss.logging.Log4jService.catchSystemErr=false -Djava.util.logging.manager=com.adventnet.logging.LogManager -Djava.util.logging.config.file=/usr/server/Zoho/VirtualOffice/server/default/conf/logging.xml -Djava.util.logging.config.class=com.adventnet.logging.LoggingScanner -Dlog.dir=/usr/server/Zoho/VirtualOffice/server/default -Duser.home=/usr/server/Zoho/VirtualOffice/server/default -Duser.language=en -Duser.region=US -Dtier-type=BE -Dtier-id=BE1 -Djava.library.path=/usr/server/Zoho/VirtualOffice/lib/native:

CLASSPATH: /usr/server/Zoho/VirtualOffice/bin/run.jar:./../jre/lib/tools.jar:/usr/server/Zoho/VirtualOffice/lib/AdventNetLogging.jar:/usr/server/Zoho/VirtualOffice/lib/AdventNetNPrevalent.jar:/usr/server/Zoho/VirtualOffice/lib/

================================================================================

Trying to start MySQL server failed
barnies:/usr/server/Zoho/VirtualOffice/bin #


But it seams that mysql is actually started:


barnies:/usr/server/Zoho/VirtualOffice/bin # ps aux|grep mysql
root 4574 0.0 0.0 2792 1252 pts/3 S 19:01 0:00 /bin/sh /usr/server/Zoho/VirtualOffice/bin/startDB.sh 33309 /usr/server/Zoho/VirtualOffice/mysql/tmp
root 4579 0.1 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8
root 4580 0.0 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8
root 4581 0.0 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8
root 4582 0.0 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8
root 4583 0.0 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8
root 4584 0.0 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8
root 4585 0.0 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8
root 4586 0.0 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8
root 4587 0.0 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8
root 4588 0.0 0.6 31700 12468 pts/3 S 19:01 0:00 /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld --no-defaults -u root --basedir=/usr/server/Zoho/VirtualOffice/bin/../mysql --port=33309 --socket=/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock --default-character-set=utf8


Manually connecting to it doesn't work: (empty password)


barnies:/usr/server/Zoho/VirtualOffice/mysql/bin # ./mysql -u root -P 33309 -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
b



Here is the log serverout0.txt

[19:01:21:188]|[10-16-2006]|[com.adventnet.j2ee.deployment.system.AdventNetServerImpl]|[INFO]|[10]|: AdventNet Server Implementation.|
[19:01:21:631]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,542 INFO [Server] Starting JBoss (MX MicroKernel)...
|
[19:01:21:632]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,543 INFO [Server] Release ID: JBoss [WonderLand] 3.2.6 (build: CVSTag=JBoss_3_2_6 date=200410140106)
|
[19:01:21:634]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,543 INFO [Server] Home Dir: /usr/server/Zoho/VirtualOffice
|
[19:01:21:635]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,543 INFO [Server] Home URL: file:/usr/server/Zoho/VirtualOffice/
|
[19:01:21:636]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,544 INFO [Server] Library URL: file:/usr/server/Zoho/VirtualOffice/lib/
|
[19:01:21:638]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,545 INFO [Server] Patch URL: null
|
[19:01:21:639]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,546 INFO [Server] Server Name: default
|
[19:01:21:640]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,546 INFO [Server] Server Home Dir: /usr/server/Zoho/VirtualOffice/server/default
|
[19:01:21:641]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,546 INFO [Server] Server Home URL: file:/usr/server/Zoho/VirtualOffice/server/default/
|
[19:01:21:643]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,547 INFO [Server] Server Data Dir: /usr/server/Zoho/VirtualOffice/server/default/data
|
[19:01:21:644]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,547 INFO [Server] Server Temp Dir: /usr/server/Zoho/VirtualOffice/server/default/tmp
|
[19:01:21:646]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,547 INFO [Server] Server Config URL: file:/usr/server/Zoho/VirtualOffice/server/default/conf/
|
[19:01:21:655]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,548 INFO [Server] Server Library URL: file:/usr/server/Zoho/VirtualOffice/server/default/lib/
|
[19:01:21:657]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:21,548 INFO [Server] Root Deployment Filename: jboss-service.xml
|
[19:01:22:082]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:22,063 INFO [Server] Starting General Purpose Architecture (GPA)...
|
[19:01:22:406]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:22,359 INFO [ServerInfo] Java version: 1.5.0,Sun Microsystems Inc.
|
[19:01:22:407]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:22,359 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.5.0-b64,Sun Microsystems Inc.
|
[19:01:22:408]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:22,360 INFO [ServerInfo] OS-System: Linux 2.6.16.13-4-default,i386
|
[19:01:22:930]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:22,926 INFO [Server] Core system initialized
|
[19:01:25:367]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:25,302 INFO [ServiceBindingManager] Initializing store
|
[19:01:25:367]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:25,302 INFO [ServiceBindingManager] Using StoreURL: file:/usr/server/Zoho/VirtualOffice/server/default/conf/sample-bindings.xml
|
[19:01:27:519]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: 19:01:27,484 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
|
[19:01:28:620]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] NamingService: Started jndi bootstrap jnpPort=57668, rmiPort=0, backlog=50, bindAddress=/0.0.0.0, Client SocketFactory=null, Server SocketFactory=org.jboss.net.sockets.DefaultSocketFactory@ad093076|
[19:01:33:487]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] Embedded: Catalina naming disabled|
[19:01:36:415]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] Http11Protocol: Initializing Coyote HTTP/1.1 on http-0.0.0.0-9090|
[19:01:36:416]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] Catalina: Initialization processed in 2911 ms|
[19:01:36:417]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] StandardService: Starting service jboss.web|
[19:01:36:519]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] StandardEngine: Starting Servlet Engine: Apache Tomcat/5.0.28|
[19:01:37:295]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] StandardHost: XML validation disabled|
[19:01:37:615]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] WebappLoader: Dual registration of jndi stream handler: factory already defined|
[19:01:40:420]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] ContextConfig: Missing application web.xml, using defaults only StandardEngine[jboss.web].StandardHost[localhost].StandardContext[/help]|
[19:01:41:056]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] Catalina: Server startup in 4591 ms|
[19:01:42:424]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] UILServerILService: JBossMQ UIL service available at : /0.0.0.0:57413|
[19:01:42:640]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] JmsXA: Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=TxCM,name=JmsXA to JNDI name 'java:/JmsXA'|
[19:01:42:640]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] MySqlDS: Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=LocalTxCM,name=MySqlDS to JNDI name 'java:/MySqlDS'|
[19:01:43:168]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] TomcatDeployer: deploy, ctxPath=/AdventNetWebClientResources, warUrl=file:/usr/server/Zoho/VirtualOffice/server/default/tmp/deploy/tmp39995AdventNetWebClientResources.war/|
[19:01:43:700]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] ContextConfig: Missing application web.xml, using defaults only StandardEngine[jboss.web].StandardHost[localhost].StandardContext[/AdventNetWebClientResources]|
[19:01:44:024]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] TomcatDeployer: deploy, ctxPath=/common-libraries, warUrl=file:/usr/server/Zoho/VirtualOffice/server/default/deploy/common-libraries.war/|
[19:01:44:548]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] ContextConfig: Missing application web.xml, using defaults only StandardEngine[jboss.web].StandardHost[localhost].StandardContext[/common-libraries]|
[19:01:44:549]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] URLDeploymentScanner: Incomplete Deployment listing:
MBeans waiting for other MBeans:
ObjectName: adventnet.deployment:type=ServicesDeployer
state: CREATED
I Depend On: jboss.system:service=MainDeployer

Depends On Me:

MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: adventnet.deployment:type=ServicesDeployer
state: CREATED
I Depend On: jboss.system:service=MainDeployer

Depends On Me:
|
[19:01:44:656]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] DeploymentTopic: Bound to JNDI name: topic/DeploymentTopic|
[19:01:44:657]|[10-16-2006]|[com.adventnet.notification.service.Topic]|[INFO]|[10]|: TopicConfiguration NOT BOUND IN JNDI|
[19:01:45:288]|[10-16-2006]|[com.adventnet.notification.ConnectionFactory]|[INFO]|[10]|: NotificationConnectionFactory Successfully Bound in JNDI|
[19:01:46:032]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] DataModelTopic: Bound to JNDI name: topic/DataModelTopic|
[19:01:46:033]|[10-16-2006]|[SYSOUT]|[INFO]|[10]|: [JBOSS] PersistenceTopic: Bound to JNDI name: topic/PersistenceTopic|
[19:01:46:448]|[10-16-2006]|[com.adventnet.persistence.service.PersistenceService]|[INFO]|[10]|: The Persistence Service is bound with the JNDI Name : persistence|
[19:01:46:976]|[10-16-2006]|[com.adventnet.persistence.service.DatabaseFactory]|[INFO]|[10]|: Persistence data-dictionary loaded successfully|
[19:01:46:977]|[10-16-2006]|[com.adventnet.persistence.service.DatabaseFactory]|[INFO]|[10]|: InitializeDSConfig called |
[19:01:46:977]|[10-16-2006]|[com.adventnet.persistence.service.DatabaseFactory]|[INFO]|[10]|: DataSourceConfiguration file URL is file:/usr/server/Zoho/VirtualOffice/server/default/conf/datasource-configuration.xml|
[19:01:47:080]|[10-16-2006]|[com.adventnet.persistence.service.DatabaseFactory]|[INFO]|[10]|: Database name is mysql datasourcename is java:/MySqlDS|
[19:01:47:081]|[10-16-2006]|[com.adventnet.db.adapter.DBInitializer]|[INFO]|[10]|: Command to start DB server [sh, /usr/server/Zoho/VirtualOffice/bin/startDB.sh, 33309, /usr/server/Zoho/VirtualOffice/mysql/tmp] |
[19:01:47:184]|[10-16-2006]|[SYSOUT]|[INFO]|[11]|: DB_HOME /usr/server/Zoho/VirtualOffice/bin/../mysql DB_PORT 33309 TMP_HOME /usr/server/Zoho/VirtualOffice/mysql/tmp|
[19:01:47:185]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: 061016 19:01:47 [Warning] Asked for 196608 thread stack, but got 126976|
[19:01:47:185]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: The first specified data file ./ibdata1 did not exist:|
[19:01:47:186]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: a new database to be created!|
[19:01:47:186]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: 061016 19:01:47 InnoDB: Setting file ./ibdata1 size to 10 MB|
[19:01:47:187]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: Database physically writes the file full: wait...|
[19:01:47:704]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: 061016 19:01:47 InnoDB: Log file ./ib_logfile0 did not exist: new to be created|
[19:01:47:705]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: Setting log file ./ib_logfile0 size to 5 MB|
[19:01:47:705]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: Database physically writes the file full: wait...|
[19:01:48:016]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: 061016 19:01:47 InnoDB: Log file ./ib_logfile1 did not exist: new to be created|
[19:01:48:017]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: Setting log file ./ib_logfile1 size to 5 MB|
[19:01:48:017]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: Database physically writes the file full: wait...|
[19:01:48:328]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: Doublewrite buffer not found: creating new|
[19:01:48:536]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: Doublewrite buffer created|
[19:01:48:537]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: Creating foreign key constraint system tables|
[19:01:48:537]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: InnoDB: Foreign key constraint system tables created|
[19:01:48:537]|[10-16-2006]|[SYSOUT]|[INFO]|[12]|: 061016 19:01:48 InnoDB: Started; log sequence number 0 0|
[19:01:48:538]|[10-16-2006]|[SYSOUT]|[INFO]|[11]|: /usr/server/Zoho/VirtualOffice/bin/../mysql/bin/mysqld: ready for connections.|
[19:01:48:538]|[10-16-2006]|[SYSOUT]|[INFO]|[11]|: Version: '4.1.7-pro' socket: '/usr/server/Zoho/VirtualOffice/mysql/tmp/mysql.sock' port: 33309 Official MySQL-pro binary|


The logfile localhost_access_log.2006-10-16.log is empty.