![]() ![]() Are all the networks between the Looker server and the database hosts configured to allow the network traffic? Check firewalls and network Access Control Lists (ACLs).Are the database and Looker server configured to allow the network traffic between them? Check any installed firewall software on both hosts.If the Telnet check is not successful, consider the following: Telnet: could not resolve mydb/telnet: Name or service not known Telnet: Unable to connect to remote host: Connection refused Telnet: Unable to connect to remote host: Connection timed out If the connection is NOT working, you will see something like one of these: Trying 10.10.10.10. ![]() ![]() If the connection is working, you will see something similar to this: Trying 10.10.10.10. For example, if you are running MySQL on the default port and your database name is mydb, the command would be telnet mydb 3306. Open my.ini file in MySQL server installation directory You will see the default port number port3306 Change it to desired port number. To test the connection to your database, run the telnet hostname port on your Looker server. Lists the default ports for a number of platforms, although your database may beĬonfigured to run on a different port. You will need to know on which port your database is running. If you get a "command not found" error, you will need to install Telnet. You should see something like this: usage: telnet host-name To test this, run this command on your Looker server: telnet ? Some hosts may come with Telnet pre-installed. Once you know that the database is accessible, you can move on to testing via applications such as your database's native client, or Looker. Telnet either makes the connection or it does not. There are no configuration files to modify and no authentication is required. The advantage of using Telnet is that is extremely simple. To test the connectivity between your Looker server and your database, you can use Telnet on your Looker server to create a simple TCP connection. ![]() When troubleshooting a new environment, it is often helpful to isolate the various components in play and test them in isolation as simply as possible. Save money with our transparent approach to pricing Rapid Assessment & Migration Program (RAMP) Migrate from PaaS: Cloud Foundry, OpenshiftĬOVID-19 Solutions for the Healthcare Industry Tcp 0 0 190.87.34.89:3306 0.0.0.0:* LISTEN mysql 3.Observe and troubleshoot a Looker (Google Cloud core) instance Mysql 1894 0.8 9.8 1865804 1192032 ? Sl Jul01 300:53 /usr/sbin/mysqld -basedir=/usr -datadir=/var/lib/mysql -plugin-dir=/usr/lib64/mysql/plugin -user=mysql -log-error=/var/lib/mysql/DBNAME.err -pid-file=/var/lib/mysql/DBNAME.pidĪlternatively, the ports can also be mapped with the valid IP address depending on the bind-address configuration defined in the MySQL configuration file: Tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN mysqlĪlso, we can use the ps command to track the service PID and then the netstat command to get port-level insights: server# ps aux | grep mysql Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name Further, it will also help to investigate the network sockets and test the Linux network ports: server# sudo netstat -tulpnĪctive Internet connections (only servers) Netstat is a command-line utility of the Linux system that showcases the outbound network statistics for several network protocols and interfaces. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |