Installing with MySQL

goatbeater

I've run into a problem right up front.
I've searched the forums but can't find help with anything this basic 😐

There is an existing mySQL service running on the system, but Aware won;t accept the root id and password.
I've checked the .props file and it has gone in there OK, but I can;t get past this first base

Help??

tford

I'm guessing you'll have to give quite a bit more detail to get help.

You've basically said AwareIM won't accept root id & password.

aware_support

Click on the View button next to the Aware IM Server entry on the Aware IM Control Panel. Post the diagnostics here. There can be many reasons why Aware IM won't start - wrong MySQL credentials, wrong host and /or port, blocked port etc etc etc. The diagnostics should reveal what the problem is.

goatbeater

aware_support wrote
Click on the View button next to the Aware IM Server entry on the Aware IM Control Panel. Post the diagnostics here. There can be many reasons why Aware IM won't start - wrong MySQL credentials, wrong host and /or port, blocked port etc etc etc. The diagnostics should reveal what the problem is.

This is what I got:

Hello world. About to start Aware IM Server
Aware IM Server startup error Unable to start Aware IM server because port 9000 is not available
or there is already another copy of Aware IM Server running.
Change the SystemPort property in the BASServer.props file to specify a different port number. exiting...
com.bas.basserver.bsmanager.StartupException: Unable to start Aware IM server because port 9000 is not available
or there is already another copy of Aware IM Server running.
Change the SystemPort property in the BASServer.props file to specify a different port number.

at com.bas.basserver.bsmanager.F.R(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.bsmanager.O.B(Unknown Source)
at com.bas.basserver.bsmanager.J$_C.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)

Process status: Aware IM Server: Unable to start Aware IM server because port 9000 is not available
or there is already another copy of Aware IM Server running.
Change the SystemPort property in the BASServer.props file to specify a different port number.
Overall status: Unable to start Aware IM server
Process status: Tomcat: Process finished
Overall status: Aware IM is shutting down...
Process status: JBoss: Shutting down
Process status: JBoss: Process finished
Overall status: Aware IM is not running
Process status: JBoss: Process finished

Contents of basserver.props:
#BAS Server Startup Properties
#Fri Jan 18 12:55:08 PST 2002
SystemPort=9000
ChannelTypeSK=com.bas.basserver.channels.SocketChannelType
ChannelTypeMail=com.bas.basserver.channels.EmailChannelType
ChannelTypeTimer=com.bas.basserver.channels.TimerChannelType
ChannelTypeURL=com.bas.basserver.channels.URLChannelType
ChannelTypeWebServices=com.bas.basserver.channels.WebServicesChannelType
ReplyTopic=topic/skoutputtopic
RequestQueue=queue/skinputqueue
LocalTopic=topic/defaultoutputtopic
LocalQueue=queue/defaultinputqueue
NotificationOutTopic=topic/notifouttopic
NotificationInQueue=queue/notifinqueue
DirectoryService=org.jnp.interfaces.NamingContextFactory
DirectoryServiceProvider=jnp://localhost:9650/
JMSFactory=ConnectionFactory
DriverClassName=com.mysql.jdbc.Driver
DriverURL=jdbc:mysql://localhost/BASDB?user=root
DriverTestURL=jdbc:mysql://localhost/BASDBTEST?user=root
BootstrapURL=jdbc:mysql://localhost/?user=root
DatabaseName=BASDB
DatabaseNameTest=BASDBTEST
DatabaseComponent=com.bas.basserver.persistence.dbplugins.MySQLInterface
StartRange=1
EndRange=100000
Hub=true
MaxNmbOfRepeats=1000
MaxNmbOfRepeatsWithoutChange=50
SessionTimeout=3600000
UIProcessTimeout=1800000
DocumentEngines=com.bas.basserver.documents.JasperReportsEngine,com.bas.basserver.documents.MSWordDocumentEngine,com.bas.basserver.documents.TextDocumentEngine,com.bas.basserver.documents.HtmlDocumentEngine,com.bas.basserver.documents.MSExcelDocumentEngine
AwaresoftHost=localhost
AwaresoftPort=8080

aware_support

This has nothing to do with MySQL. Aware IM doesn't start because port 9000 that it needs is either blocked by firewalls or used by other applications.

Try to reboot first. If this doesn't help go to the Settings dialog and change port 9000 to something else, for example 9050, then save settings and restart

goatbeater

OK - we realised what was going on (I think)

The root password for mysql had been setup with an ampersand ( & ) in the string. Nothing else had complained, but AwareIM doesn't seem to like this.

We saw that the password it was assuming was the string up to the ampersand, so & is being taken as an end of string or something.

We have ripped out the mysql installation and started again with no special characters. It worked!

So much for sysadmin's weird password settings!

Now we can start with AwareIM for real!