A few days ago\u00a0 a colleague asked me if I could install a Newsletter System for him on one of our servers. He decided to use OpenEMM 6.1.<\/a><\/p>\n OpenEMM is a feature-rich enterprise software for e-mail marketing, newsletters and service mails (transaction mails and event or time triggered mails). OpenEMM offers sophisticated bounce management, link tracking, lots of realtime statistics, a CMS module and a scripting feature to implement individual tasks…….\u00a0 cool \ud83d\ude42<\/p>\n Installation goes by hand, cause sadly there are no deps.<\/p>\n However –\u00a0after a bit of googling\u00a0I found a wiki <\/a>which descriptives the installation process for the common linux distros.<\/p>\n As a brave installation instruction follower\u00a0I went through the installation step by step.<\/p>\n In the end there was only one task left to start the application server resin <\/a>and login in for the first time.<\/p>\n And the fun starts \ud83d\ude42<\/p>\n Instead of a shiny login screen\u00a0I got….<\/p>\n hmmm, so what is jdbc trying us to say?<\/p>\n So\u00a0I checked the stack trace:<\/p>\n “Connection refused” what the hell…. ok, database credentials are ok, openemm and openemm_cms schema are created. The MySQL error log says nothing? I’m able to connect to the schemas via mysql client ……. oh mannn, it turned out that I’m not the only one with this problem, lol, but all forum posts\u00a0I could find so far offered no solution for my problem.<\/p>\n Then after half a day more or less searching for a solution\u00a0I found a post where someone is talking about to check the MySQL “bind-address<\/strong>” parameter.\u00a0 Checking my.cnf\u00a0 turns out that the address binding was set to the external address of the server, lol what…, who changed that???<\/p>\n Quickly changed the address-binding back to “localh0st” restarted OpenEMM and requested the logging screen. Unsurprisingly the HTML error stays the same but,…. the stack trace changed…yeahhhh.<\/p>\n Now the trace shows:<\/p>\n Humpf,…… firing on google. I interpreted this message that jdbc could successfully establish a connection to the database and than for some reason the connection was closed from the db side.<\/p>\n A few hours later checking a lot posts concerning this problem\u00a0I found a small side node in a post that it make sense to check the host.allow entrys.<\/p>\n Added ….<\/p>\n mysqld : localhost : allow<\/strong><\/p>\n and ….. it works yeahhhhhh \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":" A few days ago\u00a0 a colleague asked me if I could install a Newsletter System for him on one of our servers. He decided to use OpenEMM 6.1. OpenEMM is a feature-rich enterprise software for e-mail marketing, newsletters and service mails (transaction mails and event or time triggered mails). OpenEMM offers sophisticated bounce management, link … Continue reading Fun with OpenEMM installation<\/span> An error occurred<\/h3>\n
javax.servlet.ServletException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot create PoolableConnectionFactory (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)<\/pre>\n
Caused by: java.net.ConnectException: Connection refused\r\n at java.net.PlainSocketImpl.socketConnect(Native Method)\r\n at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)\r\n at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)\r\n at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)\r\n at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)\r\n at java.net.Socket.connect(Socket.java:529)\r\n at java.net.Socket.connect(Socket.java:478)\r\n at java.net.Socket.(Socket.java:375)\r\n at java.net.Socket.(Socket.java:218)\r\n at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)\r\n at com.mysql.jdbc.MysqlIO.(MysqlIO.java:293)\r\n ... 57 more<\/pre>\n
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.\r\n at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2497)\r\n at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:599)\r\n ... 72 more\r\n<\/pre>\n