Hi Paul, Usually I stop the service that is being installed or has issues to remove it form the equation and test the network connectivity first.
stop mysql install netcat if needed run netcat listening on port 3306 sudo nc -l 3306 check that it is indeed being listened on in another terminal: netstat -nat |grep LISTEN|grep 3306 or ss -nat |grep LISTEN|grep 3306 test connectivity locally first !! telnet ... blah test connectivity remotely telnet ... blah If you can connect locally but not remotely then there is some firewall/other network issue. If you can connect remotely then your issue is in the service you originally wanted to test/ install Googling though for "maria db 3306 connection refused" suggests another check: have you enabled remote access? eg. https://mariadb.com/kb/en/library/configuring-mariadb-for-remote-client-access/ In your original email we don't see bind-address in your config or other remote access config. thanks, Alex On Thu, Nov 16, 2017 at 2:27 PM, Paul Van den Bergh <[email protected]> wrote: > My prevous post was shortened while posting.... > > 4. I see no firewall roules: > > root@beaglebone:~# iptables -L -n -v > > Chain INPUT (policy ACCEPT 2959 packets, 304K bytes) > > pkts bytes target prot opt in out source > destination > > > Chain FORWARD (policy ACCEPT 0 packets, 0 bytes) > > pkts bytes target prot opt in out source > destination > > > Chain OUTPUT (policy ACCEPT 478 packets, 42627 bytes) > > pkts bytes target prot opt in out source > destination > > I'll examine the logs in the hope to find the problem. Thanks for your > valuable input ! > > Regards, > Paul > > > Op donderdag 16 november 2017 15:22:57 UTC+1 schreef Paul Van den Bergh: >> >> Hi Tarmo, >> >> 1. since I can ssh into the BBB, it's the exact IP address: >> >> paul@debian-9-2-1-64:~$ ssh [email protected] >> Last login: Tue Oct 10 14:07:21 2017 from 192.168.1.13 >> root@beaglebone:~# ifconfig >> eth0: flags=-28605<UP,BROADCAST,RUNNING,MULTICAST,DYNAMIC> mtu 1500 >> inet *192.168.1.52* netmask 255.255.255.0 broadcast 192.168. >> 1.255 >> inet6 fe80::d239:72ff:fe17:eaae prefixlen 64 scopeid 0x20<link> >> ether d0:39:72:17:ea:ae txqueuelen 1000 (Ethernet) >> RX packets 7335 bytes 663521 (647.9 KiB) >> RX errors 0 dropped 1751 overruns 0 frame 0 >> TX packets 582 bytes 54176 (52.9 KiB) >> TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 >> device interrupt 174 >> >> >> lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536 >> >> inet 127.0.0.1 netmask 255.0.0.0 >> >> inet6 ::1 prefixlen 128 scopeid 0x10<host> >> >> loop txqueuelen 1 (Local Loopback) >> >> RX packets 160 bytes 12960 (12.6 KiB) >> >> RX errors 0 dropped 0 overruns 0 frame 0 >> >> TX packets 160 bytes 12960 (12.6 KiB) >> >> TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 >> >> >> >> usb0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500 >> >> inet 192.168.7.2 netmask 255.255.255.252 broadcast 192.168.7.3 >> >> ether d0:39:72:17:ea:b0 txqueuelen 1000 (Ethernet) >> >> RX packets 0 bytes 0 (0.0 B) >> >> RX errors 0 dropped 0 overruns 0 frame 0 >> >> TX packets 0 bytes 0 (0.0 B) >> >> TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 >> >> >> >> usb1: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500 >> >> inet 192.168.6.2 netmask 255.255.255.252 broadcast 192.168.6.3 >> >> ether d0:39:72:17:ea:b3 txqueuelen 1000 (Ethernet) >> >> RX packets 0 bytes 0 (0.0 B) >> >> RX errors 0 dropped 0 overruns 0 frame 0 >> >> TX packets 0 bytes 0 (0.0 B) >> >> TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 >> >> >> >> >> 2. mysql is running: (another problem is setting up the time server on >> the BBB ;) ) >> >> root@beaglebone:~# systemctl status mysql >> >> ● mariadb.service - MariaDB database server >> >> Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor >> preset: enabled) >> Active: active (running) since Tue 2017-10-10 14:07:21 CEST; 4h 52min >> ago >> Process: 909 ExecStartPost=/bin/sh -c systemctl unset-environment >> _WSREP_START_POSITIO >> Process: 900 ExecStartPost=/etc/mysql/debian-start (code=exited, status >> =0/SUCCESS) >> Process: 598 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] >> && VAR= || VA >> Process: 573 ExecStartPre=/bin/sh -c systemctl unset-environment >> _WSREP_START_POSITION >> Process: 540 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d / >> var/run/mysqld >> Main PID: 812 (mysqld) >> >> Status: "Taking your SQL requests now..." >> >> Tasks: 26<span style="color: #000;" class= >> > > -- > For more options, visit http://beagleboard.org/discuss > --- > You received this message because you are subscribed to the Google Groups > "BeagleBoard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/beagleboard/2460b837-a0af-49c3-be6e-87e827d0e58f%40googlegroups.com > <https://groups.google.com/d/msgid/beagleboard/2460b837-a0af-49c3-be6e-87e827d0e58f%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- For more options, visit http://beagleboard.org/discuss --- You received this message because you are subscribed to the Google Groups "BeagleBoard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beagleboard/CAHeneC-Vqe48MWJNvqNTg_uxsvGdntHhu0UTLpue1WCWR6%3DnJA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
