Skip to main content

unable to establish remote connection to mariadb (mysql) on centos7 on gcloud from mac or gscipt

newbie here
- Issue: unable to establish remote
connection to mariadb (mysql) on centos7 from a mac or a gscript
- setup: I
got 2 lamp machines: one test (107) and another one production (35)
107 -
centos6.5 with mysql (vps in digitial ocean)
35 - centos7 with
mariadb-server-5.5.52-1.el7.x86_64 (compute engine on
gcloud)

db,dbuser,dbpass and port (3306) same on both
machines




  • problem
    details:
    I can establish a remote and a jdbc connection to mysql on 107 (test
    server) from a mac using nc, mysqlworkbench and a gscript app; but when I try to get a
    connection going with 35 (prod server) with the same user/pass/db parameters I get this
    response:
    workbench: Can't connect to MySQL server on '35.190.134.164'
    (60)
    gscript (jdbc connection exception thrown): Failed to establish a
    database connection. Check connection string, username and password.
    nc on
    mac: ... (literally nothing after issuing the command nc <35's ip address>
    3306




-What I
tried:
1. href="https://mariadb.com/kb/en/library/configuring-mariadb-for-remote-client-access/"
rel="nofollow
noreferrer">https://mariadb.com/kb/en/library/configuring-mariadb-for-remote-client-access/

my.cnf in 35 looks like
this:



[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

#
Disabling symbolic-links is recommended to prevent assorted security
risks
symbolic-links=0

# Settings user and group are
ignored when systemd is used.
# If you need to run mysqld under a different
user or group,
# customize your systemd unit file for mariadb according to
the
# instructions in
http://fedoraproject.org/wiki/Systemd



#skip-networking
bind-address
=
0.0.0.0


[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
#
include all files from the config directory
#
!includedir
/etc/my.cnf.d



start="2">
  • firewall-cmd looks like this (for active and
    public):



  • trusted
    (active)
    target: ACCEPT
    icmp-block-inversion:
    no
    interfaces: eth0
    sources:
    services: http
    https

    ports: 3306/tcp
    protocols:
    masquerade:
    no
    forward-ports:
    sourceports:
    icmp-blocks:

    rich rules:
    public
    target:
    default
    icmp-block-inversion: no

    interfaces:

    sources:
    services: dhcpv6-client http https ssh
    ports:
    3306/tcp
    protocols:
    masquerade: no
    forward-ports:

    sourceports:
    icmp-blocks:
    rich
    rules:




    start="3">
  • the dbuser its password is not the issue as I created
    the same user and password for the same database on both 107 and 35. the user has only
    usage privileges (select, update, delete, insert) and is set as % on both
    machines.



  • I've been on
    this for 3 days now and I'm not close to figure this out. any help is appreciated. what
    am I missing?



    Thank you.

    Comments

    Popular posts from this blog

    linux - iDRAC6 Virtual Media native library cannot be loaded

    When attempting to mount Virtual Media on a iDRAC6 IP KVM session I get the following error: I'm using Ubuntu 9.04 and: $ javaws -version Java(TM) Web Start 1.6.0_16 $ uname -a Linux aud22419-linux 2.6.28-15-generic #51-Ubuntu SMP Mon Aug 31 13:39:06 UTC 2009 x86_64 GNU/Linux $ firefox -version Mozilla Firefox 3.0.14, Copyright (c) 1998 - 2009 mozilla.org On Windows + IE it (unsurprisingly) works. I've just gotten off the phone with the Dell tech support and I was told it is known to work on Linux + Firefox, albeit Ubuntu is not supported (by Dell, that is). Has anyone out there managed to mount virtual media in the same scenario?

    ubuntu - Monitoring CPU, Mem, disk, on a single server

    I've been looking for a simple starter solution for monitoring my [currently] single server hosted solution. Other than Nagios and similar, are there other good (simple) solutions people are using? Answer Everything depends on what you want. For example Munin is very simple, you can install and configure it in less then 10 minutes (on one server), it can sends alarms, make graphs from monitoring cpu, mem. apache connections, eaccellerator, disk io and many many more (it has many plugins). But if you are planning in future get some more machines, munin may not be enough. For example in munin you cant monitor state of individual processes, can't monitor changes in files (for security purpose). So if you wanna only see what is the utilization of basics parameters on your server and don't plan to buy some more servers Munin is what you are looking for, but if you wanna be alarmed when some of your service is down, take more control on what is happeninig on...

    hp proliant - Smart Array P822 with HBA Mode?

    We get an HP DL360 G8 with an Smart Array P822 controller. On that controller will come a HP StorageWorks D2700 . Does anybody know, that it is possible to run the Smart Array P822 in HBA mode? I found only information about the P410i, who can run HBA. If this is not supported, what you think about the LSI 9207-8e controller? Will this fit good in that setup? The Hardware we get is used but all original from HP. The StorageWorks has 25 x 900 GB SAS 10K disks. Because the disks are not new I would like to use only 22 for raid6, and the rest for spare (I need to see if the disk count is optimal or not for zfs). It would be nice if I'm not stick to SAS in future. As OS I would like to install debian stretch with zfs 0.71 as file system and software raid. I have see that hp has an page for debian to. I would like to use hba mode because it is recommend, that zfs know at most as possible about the disk, and I'm independent from the raid controller. For us zfs have many benefits, ...