Question

SQL database connection in Mendix Console

0

Hi all, I have built my application and now I want to host it on IIS8. I have followed all documentation and right now I am at the point of registering the app in the Mendix Service Console. All seems to go well, apart from the database connection. I have made the service without any problems. There is no documentation available on how to make the database connection. Can someone please help me? I am using SQL server 2012 I have used these settings: Type: Microsoft SQL Server Host: I don't know? localhost? Name: the name of the database I made in SQL management studio username: Administrator password: SQL (windows authentication) password. I'm getting the following error in the console: Opening JDBC connection to localhost:0 failed with SQLState: 08S01 Error code: 0 Message: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". Retrying...(1/4) Can someone please help me with this? I would be so happy if I got my application running on IIS.... Greetings, Jaco

asked 2014-08-18

Jaco van Gelder

8 answers

Timothy Perrotti · Answer 1 · 2014-08-18

Verify that the TCP/IP protocol has been enabled for your SQL Server. I believe this is disabled by default.

Open SQL Server Configuration Manager
Expand the SQL Server Network Configuration node
Select the Protocols for MSSQLSERVER (or your named instance)
Verify TCP/IP is Enabled in the pane on the right

Jaco van Gelder · Answer 2 · 2014-08-18

Perhaps someone can help me via Teamviewer and I can paypal some lunchmoney... :-)

Jaco van Gelder · Answer 3 · 2014-08-18

Brilliant! it worked! However, when solving this, the next error already occures... http://puu.sh/aY7Nm/23606cb722.png it has something to do with the virtual folder "mxclientsystem" that I can't get into my IIS... the CMD link in the IIS tutorial doesn't seem to work for me. Any tips? –

Jasper van der Hoek · Answer 4 · 2014-08-19

The mxclientsystem folder link is automatically generated when updating the new version of the client system.

If you have issues met an application on windows with IIS you first want to establish what is causing your issue IIS or Mendix. You can easily determine this by opening your browser on the server and opening localhost:8080 (or the port you are using). Make sure you open the browser on the server, the Mendix application should not listen to other sources.
If the app works with localhost:8080 but not from your laptop via IIS, it is an IIS problem. Based on your description my guess would by the localhost:8080 doesn't work either.

If the application doesn't work without IIS you should validate if the server installation went well. So you should lookup the 'server' folder and validate that all the folders (at least the ones from the message) are present. If not you should re-install the server distribution.

Jaco van Gelder · Answer 5 · 2014-08-19

You are right, localhost:8080 is not working either. When I put that into my browser, the error in the console I posted earlier appears.

I have completely reconfigured the service conson, but now I'm getting a new error.....

Uncaught fatal error from thread [MxRuntimeSystem-akka.actor.action-dispatcher-10] shutting down ActorSystem [MxRuntimeSystem]

java.lang.ExceptionInInitializerError: null at appcloudservices.OpenIDHandler.<clinit>(OpenIDHandler.java:97) at appcloudservices.actions.StartSignOnServlet.executeAction(StartSignOnServlet.java:31) at appcloudservices.actions.StartSignOnServlet.executeAction(StartSignOnServlet.java:20) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:205) at com.mendix.core.component.InternalCore.execute(SourceFile:259) at com.mendix.hs.execute(SourceFile:42) at com.mendix.ib.a(SourceFile:47) at com.mendix.ia.a(SourceFile:193) at com.mendix.ia.executeAction(SourceFile:148) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(SourceFile:17) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:148) at scala.util.Try$.apply(Try.scala:161) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:146) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:498) at akka.actor.ActorCell.invoke(ActorCell.scala:456) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:237) at akka.dispatch.Mailbox.run(Mailbox.scala:219) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)

Caused by: java.lang.NullPointerException: null at appcloudservices.OpenIDUtils.<clinit>(OpenIDUtils.java:15) at appcloudservices.OpenIDHandler.<clinit>(OpenIDHandler.java:97) at appcloudservices.actions.StartSignOnServlet.executeAction(StartSignOnServlet.java:31) at appcloudservices.actions.StartSignOnServlet.executeAction(StartSignOnServlet.java:20) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:205) at com.mendix.core.component.InternalCore.execute(SourceFile:259) at com.mendix.hs.execute(SourceFile:42) at com.mendix.ib.a(SourceFile:47) at com.mendix.ia.a(SourceFile:193) at com.mendix.ia.executeAction(SourceFile:148) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(SourceFile:17) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:148) at scala.util.Try$.apply(Try.scala:161) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:146) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:498) at akka.actor.ActorCell.invoke(ActorCell.scala:456) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:237) at akka.dispatch.Mailbox.run(Mailbox.scala:219) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)

If anyone could assist... then please :)

Jaco van Gelder · Answer 6 · 2014-08-19

I have solved my problem. And great news! Mendix seems to be working now.

I have a few questions I hope can be answered till I stop my complaining (haha)

Why can I not log into my app? Is the database emptied? Mxadmin account doesn't work either.
Why does my login screen look different? I had styled my login screen to match my company (by adding the logo ec). Now it looks like the Appcloud login screen. I don't want that.
- My console states this "The runtime has been started using a trial license, the framework will be terminated when the maximum time is exceeded!". I have found my server ID in the console. I want to register so my mendix app doesn't close after a few hours. Where do I get a license key? I can't find the partner portal anywhere like described in the documentation (Its outdated clearly).

Hope someone can assist!

Thanks

Jaco van Gelder · Answer 7 · 2014-08-19

The error the console gives me when trying to login:

com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"type":"LoginAction","user":"administrator"}', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:216)

Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"type":"LoginAction","user":"administrator"}', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.processErrorState(SourceFile:343)

Caused by: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"amount":-1,"sort":{},"offset":-1,"type":"RetrieveXPathAction","depth":0,"xpath":"//System.User[Name='administrator']"}', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:216)

Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"amount":-1,"sort":{},"offset":-1,"type":"RetrieveXPathAction","depth":0,"xpath":"//System.User[Name='administrator']"}', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.processErrorState(SourceFile:343)

Caused by: java.lang.IllegalArgumentException: Entity id should be not zero at com.mendix.core.objectmanagement.SchemeManagerImpl.getObjectType(SourceFile:1510) at com.mendix.core.objectmanagement.MendixIdentifier.getObjectType(SourceFile:142) at com.mendix.core.objectmanagement.MendixObjectImpl.setId(SourceFile:356) at com.mendix.core.objectmanagement.SchemeManagerImpl.getInstance(SourceFile:969) at com.mendix.core.action.user.RetrieveXPathAction.executeAction(SourceFile:58) at com.mendix.core.action.user.RetrieveXPathAction.executeAction(SourceFile:17) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53) at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276) at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(SourceFile:17) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:148) at scala.util.Try$.apply(Try.scala:161) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:146) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:498) at akka.actor.ActorCell.invoke(ActorCell.scala:456) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:237) at akka.dispatch.Mailbox.run(Mailbox.scala:219) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)

This is after I manually added a user to the SQL management studio.

Jaco van Gelder · Answer 8 · 2014-08-19

The last question I have is about the licensing. My app stops working every 2 hours now, I have to restart the service manually in order for it to work again.

Isn't Mendix supposed to be free of use on your own IIS server? Or have I misunderstood? I'm starting to think I haven't configured my Mendix server the right way, because it somehow runs on the console and not on IIS. I can take down my IIS site and still connect to my server. This doesn't seem right.

Can someone please shed some light on this?