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>\nhmmm, so what is jdbc trying us to say?<\/p>\n
So\u00a0I checked the stack trace:<\/p>\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“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>\nQuickly 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
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>\nHumpf,…… 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>\nand ….. 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> →<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"ngg_post_thumbnail":0,"footnotes":""},"categories":[9],"tags":[],"class_list":["post-471","post","type-post","status-publish","format-standard","hentry","category-linux-stuff"],"yoast_head":"\nFun with OpenEMM installation - Mario's TinyLab<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun with OpenEMM installation - Mario's TinyLab\" \/>\n<meta property=\"og:description\" content=\"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 →\" \/>\n<meta property=\"og:url\" content=\"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"Mario's TinyLab\" \/>\n<meta property=\"article:published_time\" content=\"2010-06-21T06:54:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2010-06-23T06:47:15+00:00\" \/>\n<meta name=\"author\" content=\"Mario Wehr\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mario Wehr\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2010\\\/06\\\/21\\\/fun-with-openemm-installation\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2010\\\/06\\\/21\\\/fun-with-openemm-installation\\\/\"},\"author\":{\"name\":\"Mario Wehr\",\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#\\\/schema\\\/person\\\/8761b4d788b13b547de9ccd6504ce62d\"},\"headline\":\"Fun with OpenEMM installation\",\"datePublished\":\"2010-06-21T06:54:44+00:00\",\"dateModified\":\"2010-06-23T06:47:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2010\\\/06\\\/21\\\/fun-with-openemm-installation\\\/\"},\"wordCount\":391,\"commentCount\":4,\"articleSection\":[\"Linux Stuff\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2010\\\/06\\\/21\\\/fun-with-openemm-installation\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2010\\\/06\\\/21\\\/fun-with-openemm-installation\\\/\",\"url\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2010\\\/06\\\/21\\\/fun-with-openemm-installation\\\/\",\"name\":\"Fun with OpenEMM installation - Mario's TinyLab\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#website\"},\"datePublished\":\"2010-06-21T06:54:44+00:00\",\"dateModified\":\"2010-06-23T06:47:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#\\\/schema\\\/person\\\/8761b4d788b13b547de9ccd6504ce62d\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2010\\\/06\\\/21\\\/fun-with-openemm-installation\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2010\\\/06\\\/21\\\/fun-with-openemm-installation\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2010\\\/06\\\/21\\\/fun-with-openemm-installation\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fun with OpenEMM installation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#website\",\"url\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/\",\"name\":\"Mario's TinyLab\",\"description\":\"About cool\\\/interesting Projects and Technologies\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#\\\/schema\\\/person\\\/8761b4d788b13b547de9ccd6504ce62d\",\"name\":\"Mario Wehr\",\"url\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/author\\\/wehr\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun with OpenEMM installation - Mario's TinyLab","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/","og_locale":"en_US","og_type":"article","og_title":"Fun with OpenEMM installation - Mario's TinyLab","og_description":"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 →","og_url":"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/","og_site_name":"Mario's TinyLab","article_published_time":"2010-06-21T06:54:44+00:00","article_modified_time":"2010-06-23T06:47:15+00:00","author":"Mario Wehr","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mario Wehr","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/#article","isPartOf":{"@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/"},"author":{"name":"Mario Wehr","@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#\/schema\/person\/8761b4d788b13b547de9ccd6504ce62d"},"headline":"Fun with OpenEMM installation","datePublished":"2010-06-21T06:54:44+00:00","dateModified":"2010-06-23T06:47:15+00:00","mainEntityOfPage":{"@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/"},"wordCount":391,"commentCount":4,"articleSection":["Linux Stuff"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/","url":"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/","name":"Fun with OpenEMM installation - Mario's TinyLab","isPartOf":{"@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#website"},"datePublished":"2010-06-21T06:54:44+00:00","dateModified":"2010-06-23T06:47:15+00:00","author":{"@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#\/schema\/person\/8761b4d788b13b547de9ccd6504ce62d"},"breadcrumb":{"@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2010\/06\/21\/fun-with-openemm-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.fh-kaernten.at\/wehr\/"},{"@type":"ListItem","position":2,"name":"Fun with OpenEMM installation"}]},{"@type":"WebSite","@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#website","url":"https:\/\/blog.fh-kaernten.at\/wehr\/","name":"Mario's TinyLab","description":"About cool\/interesting Projects and Technologies","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.fh-kaernten.at\/wehr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#\/schema\/person\/8761b4d788b13b547de9ccd6504ce62d","name":"Mario Wehr","url":"https:\/\/blog.fh-kaernten.at\/wehr\/author\/wehr\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/posts\/471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/comments?post=471"}],"version-history":[{"count":0,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/posts\/471\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/media?parent=471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/categories?post=471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/tags?post=471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}