error received status code 401 from server influxdb error received status code 401 from server influxdb

In the spirit of mutual collaboration between the client and the API, the response must include a hint on how to obtain such authorization. ts=2021-03-04T06:43:29.682034Z lvl=info msg="Starting precreation service" log_id=0SfU4dG000 service=shard-precreation check_interval=10m advance_period=30m If you preorder a special airline meal (e.g. Set u as the username and p as the password. If you're sure the page you're trying to reach shouldn't need authorization, the 401 Unauthorized error message may be a mistake. SEO (ON-SITE OPTIMIZATION): Step #1. fjllstugan jnkping cafe; how to open binance corporate account; boka grupprum timeedit Im not aware of any workaround or implementation supporting V2 at the moment nor if this is on the current roadmap, but I just wanted to jump in to say that this is likely the reason for the error you are experiencing. He's been writing about tech for more than two decades and serves as the SVP and General Manager of Lifewire. 1. https://www.open-plant.com/knowledge-base/how-to-install-influxdb-docker-for-windows-10/. Note: If you enable authentication and have no users, InfluxDB will not enforce authentication and will only accept the query that creates a new admin user. Find centralized, trusted content and collaborate around the technologies you use most. This is a list of Hypertext Transfer Protocol (HTTP) response status codes. Common Causes allowed_roles=vault-admin. Plugins do not currently have the ability to authenticate requests and service Its a shame, I really see the advantage of using influxDB to make the data we generate usable. +1 (416) 849-8900. @RichardRublev I think the issue has to do with InfluxDB auth itself, rather than the fact that is set-up using docker. Use middleware to apply Open Policy Agent (OPA) policies on incoming requests. I wish to explore using InluxDB to collect application telemetry - however, my first attempt has left me feeling like a worthless idiot! by setting the auth-enabled option to true in the [http] section: If pprof-enabled is set to true, set pprof-auth-enabled and ping-auth-enabled ts=2021-03-04T06:43:29.682034Z lvl=info msg="Registered diagnostics client" log_id=0SfU4dG000 service=monitor name=system -e DOCKER_INFLUXDB_INIT_BUCKET=my-bucket Grafana as well as Influx are running in a docker container. By rejecting non-essential cookies, Reddit may still use certain cookies to ensure the proper functionality of our platform. I'm not sure where the issue comes from. ts=2021-03-04T06:43:29.573806Z lvl=info msg="Go runtime" log_id=0SfU4dG000 version=go1.13.8 maxprocs=8 Have a question about this project? This was caused by two things. Or, the HTTP 401.1 error message may be displayed in the browser window. Thank you for being part of our community! Done Building dependency tree Reading state information. The built-in plugin only supports InfluxDB v1.x. Making statements based on opinion; back them up with references or personal experience. I see there are some recent commits on this So I follow the download nightly instructions for 2.x: Hi , i have found the solution work for me , you need to create auth v1 api , its additionnal auth whenever you have already the user dclared in influx: if you use influx v1 auth list you can verify this list is null To fix this start by nuking the old version. enabled = true genarally config file can be found at: /etc/influxdb/influxdb.conf Share Follow answered Jun 9, 2022 at 12:45 KIRAN KUMAR B 314 2 8 Add a comment Your Answer But we have no way of telling why that is. are backed by the new InfluxDB IOx storage engine. 1solution Please Sign up or sign into vote. Well occasionally send you account related emails. Sitemap check Step #9. validation Step #10. The first digit of the status code specifies one of five standard classes of . Are there tables of wastage rates for different fruit and veg? Powered by Discourse, best viewed with JavaScript enabled, http://127.0.0.1:8200/v1/database/config/my-influxdb-database, error creating database object: error verifying connection: error getting if provided username is admin: received status code 401 from server. 3.1.7(0.340/5/3) x86_64; InfluxDB version: Run influxd version and copy the output here InfluxDB v1.8.4 (git: 1.8 bc8ec43) Start the influx shell and run the auth command. influx setup --username administrator --password administrator --token MyTokenMyToken== --org MyOrgName --bucket sandbox --retention 0. b) I dont seem to have any way of specifying the bucket ID so I need to find out what it is. I tried running auth but after filling the username and password, it still returns the same error. to your account. I tried following the instructions for setting up the inital admin but got the same error. I installed the docker version of InfluxDB. Performance: Non-admin users can SHOW the databases on which they have READ and/or WRITE permissions. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. Search Toggle. AI Voice Cloning Is Coming to Your PhoneHere's Why You Need to Be Careful, Bandcamp Doesnt Need to Replace Streaming to Win Big, Garmin Expands Its Running Watches Lineup With Two New AMOLED Models, UPDATED: Microsoft's Bing Chatbot Has Three New Personality Types, Xioami's New AR Glasses Highlight the Design Challenges Apple Faces, Why All These New AI Chatbots Are Fighting So Hard For Your Attention, Conversational AI Like ChatGPT May Soon Have a Face That Looks Human, TikTok Launches Robust New Parental Controls to Limit Screen Time for Kids, Senior Vice President & Group General Manager, Tech & Sustainability. For more information, please see our To learn more, see our tips on writing great answers. The nature of simulating nature: A Q&A with IBM Quantum researcher Dr. Jamie We've added a "Necessary cookies only" option to the cookie consent popup. The 401 Unauthorized error is anHTTP status codethat means the page you were trying to access cannot be loaded until you first log in with a valid user ID and password. Otherwise, find a Contact page for specific contact instructions. Linear regulator thermal information missing in datasheet. A number of server-side HTTP status codes also exist, like the often-seen 500 Internal Server Error. Check for errors in the URL. Restart the server. The nature of simulating nature: A Q&A with IBM Quantum researcher Dr. Jamie We've added a "Necessary cookies only" option to the cookie consent popup. additionally, I also tried changing the port number for http to 8087, but when I ran 'influxd' the port number that came up in the log was still 8086. This blog is about hooking stuff up to the internet. When you visit the site, Dotdash Meredith and its partners may store or retrieve information on your browser, mostly in the form of cookies. Add a custom shared secret in your InfluxDB configuration file. Using Kolmogorov complexity to measure difficulty of problems? Don't tell someone to read the manual. Can someone help ? InfluxDB 2.x includes compatibility APIs to handle those requests, but they require some extra up-front setup. Is there a proper earth ground point in this switch box? Provide an answer or move on to the next question. Vettester November 8, 2021, 2:18am #2 From the error message it looks like it may be a user permission issue. It includes codes from IETF Request for Comments (RFCs), other specifications, and some additional codes used in some common applications of the HTTP. I believe only influx setup writes to /root/.influxdbv2/configs, everything else is stored by the influxd process. Is there a single-word adjective for "having exceptionally strong moral principles"? Apply Open Policy Agent (OPA) policies. Expected server to run and be able to run commands in influx shell, Actual behavior: to the influx CLI. Result: Digest: sha256:5d61520c6b3b8d77240398b32aeed34b3246fcc46e435bcd87bc09351bb6c295 I was able to login to the influxDB web browser using http://localhost:8086 with the same credentials provided in the code. vault secrets enable database, docker run -d -p 8086:8086 Use the Bearer authorization scheme: Only unexpired tokens will successfully authenticate. rev2023.3.3.43278. There might be invalid login information stored locally in your browser that's disrupting the login process and throwing the 401 error. As I worked my way through using the Influx Database I tried using the InfluxDB CLI. The content must be between 30 and 50000 characters. By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. This From this command, I find from here: c) Next provide authorization for v1.x -> I tried this: (If specifying --password gives Error: unknown flag error, remove it and set manually) Status: Downloaded newer image for quay.io/influxdb/influxdb:v2.0.2 Authentication only occurs at the HTTP request scope. In Dungeon World, is the Bard's Arcane Art subject to the same failure outcomes as other spells? submit a documentation issue. FWIW: I'm running other datasource against InfluxDB without any authentication issues. Keep in mind that InfluxDB 2.0 or greater does not have the out-of-the-box CLI that lets you enter the DB cli. Alright, after checking the versions (first thing I should have done!) Find centralized, trusted content and collaborate around the technologies you use most. If using Linux, you may need to update your package configuration to continue All InfluxDB Cloud organizations created on or after January 31, 2023 Or should I remove those? The 400 (Bad Request) status code indicates that the server cannot or will not process the request due to something that is perceived to be a client error. Step #4. Replacing broken pins/legs on a DIP IC package, Follow Up: struct sockaddr storage initialization by network format-string. Clearing the cache will remove any problems in those files and give the page an opportunity to download fresh files directly from the server. ts=2021-03-04T06:43:29.681036Z lvl=info msg="Starting monitor service" log_id=0SfU4dG000 service=monitor host=127.0.0.1 and edit the username and password settings. Selenium docker video doesn't work by network_mode as host in docker-compose. Also I am also at a loss as to where docker stores InfluxDB files. are not authenticated. We recommend avoiding the single quote (') and backslash (\) characters in passwords Do you usually struggle to remember your passwords? Not the answer you're looking for? C:/ProgramData/InfluxDB For more information, see the to download and verify InfluxData software packages. Relation between transaction data and transaction id. Adrin Santarelli. Solution: Go to your instance and login as administrator, then navigate to Configuration (engineering wheel) > Data Sources and re-type all passwords of your each of the datasources (specially those using the InfluxDB datasource). {"results":[.]}, I tried setting up a default user (this time from the Docker CLI), but this didnt seem to do anything. Can I tell police to wait and call a lawyer when served with a search warrant? ts=2021-03-04T06:43:29.682034Z lvl=info msg="Storing statistics" log_id=0SfU4dG000 service=monitor db_instance=_internal db_rp=monitor interval=10s Create at least one admin user. The container logs of Grafana while pressing the button are: I've already dropped the bucket, re-created the user, restarted the Influx container and much more, to no avail either. Weak/thin content page audit Step #7. Set up Authentication. Done influxdb-client is already the newest version (1.6.4-1+deb10u. How do you get the influx command to do anything? If any values change the database will return a duplicate user error. ads sensitivity apex. Can someone help ? authentication credentials to the influx CLI. To find support, use the following resources: InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support. linux$ linux$ influx By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. I can view the data in Influx data explorer in Firefox. Back to the 2.0.2 release instead. The message means that you have not been authorized to access some data controlled by the server. Still unauthorized. However, no matter what I seemed to do I got this error, which was super annoying. You can do this with either a JWT library in your own authentication server or by hand at https://jwt.io/. quay.io/influxdb/influxdb:v2.0.2, C:\Users\jnewcomb>docker run --name influxdb -p 8086:8086 quay.io/influxdb/influxdb:v2.0.2 ts=2020-11-30T11:30:17.619674Z lvl=info msg="Welcome to InfluxDB" log_id=0QnEXF_l000 version=2.0.2 commit=84496e507a build_date=2020-11-19T03:59:35Z By default, shared-secret is set to an empty string, in which case no JWT authentication takes place. Cambiar modo de navegacin. Can I tell police to wait and call a lawyer when served with a search warrant? This document covers setting up and managing authentication and authorization in InfluxDB. Have a question about this project? "http://localhost:8086/query?u=todd&p=influxdb4ever", Connected to http://localhost:8086 version 1.8.10, influx -username todd -password influxdb4ever, "Authorization: Bearer

..", ###############################################################################, # OUTPUT PLUGINS #, Add a shared secret in your InfluxDB configuration file, Linux Package Signing Key Rotation blog post. Crawl error audit Step #8. Im surprised the nightly is running such an old version, Ill open an issue about it. WARN: Connected to http://localhost:8086, but found no server version. plugin_name=influxdb-database-plugin Check the right column of your InfluxDB Cloud organization homepage I have the wrong version of the CLI. InfluxDB v2.0 running in docker - ERR: received status code 401 from server, How Intuit democratizes AI development across teams through reusability. ts=2021-03-04T06:43:29.682034Z lvl=info msg="Starting continuous query service" log_id=0SfU4dG000 service=continuous_querier And navigate to: HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> Control -> Lsa Look for key "DisableLoopbackCheck" and check the value in this key. I see a 4GB DockerDesktop.vhdx file, but nothing else there Check the right column of your InfluxDB Cloud organization homepage How Do You Fix It? By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. You can do this using the. How can I access environment variables in Python? Continuous queries. By clicking Sign up for GitHub, you agree to our terms of service and InfluxDB v2.6 is the latest stable version. Hi @jnewcomb, it looks like the C# libraries are still targeting the V1 APIs. Now I wanted to create a datasource in Grafana 9.1.0 with following options: After clicking on the button "Save & test" I just get the error back. It often occurs when you are browsing through the internet. Is it possible to create a concave light? Oh well, back to work! I tried running auth but after filling the username and password, it still returns the same error. Forbidden: Too many requests from the same client IP; Access Denied: the IP address is included in the Deny list of IP Restriction, Access Denied: the host name is included in the Deny list of IP Restriction. and our Error code 401 (unauthorized) can be avoided in dev env by enabling http access in influx config file: Thanks for contributing an answer to Stack Overflow! ts=2021-03-04T06:43:29.681036Z lvl=info msg="Opened service" log_id=0SfU4dG000 service=subscriber If powered by TSM, see the TSM-based InfluxDB Cloud documentation. Did you change the user permissions in Influx? Cause This behavior is by design. Status Code: 401 The container logs of Grafana while pressing the button are: Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide. But suprisingly, checking the version gives me this: I guess using the nightly build system is just not for me! Create resource and Retrieve resource operations are showing this error message: { "statusCode": 401, "message": "Access denied due to invalid subscription key. ERR: received status code 401 from server. For a more secure alternative to using passwords, include JWT tokens with requests to the InfluxDB API. ts=2021-03-04T06:43:29.680034Z lvl=info msg="Compaction settings" log_id=0SfU4dG000 service=store max_concurrent_compactions=4 throughput_bytes_per_second=50331648 throughput_bytes_per_second_burst=50331648 All InfluxDB Cloud organizations created on or after January 31, 2023 Also, for you / anyone else watching: --password on v1 auth create and --retention 0 on setup will both work in the upcoming 2.0.3 release. Use the INFLUX_USERNAME and INFLUX_PASSWORD environment variables to provide Environment info: System info: Run uname -srm and copy the output here CYGWIN_NT-10. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. I feel Im so close, For the record If there is specific information youre looking for, please Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2, Rabbitmq connection refused from Docker container to local host, Connect distant database running with docker with no port published, from local machine via SSH key. I believe the reason its not working is when I send the following query: Id still expect that data to end up in /root/.influxdbv2, so you see any other files in that directory, i.e. The 401.1 response will occur if the web browser's first request that's sent to the IIS application contains one of the following headers: a Windows Challenge/Response (NTLM) header In both cases, the appropriate status code to reply with is 401 Unauthorized. If powered by TSM, this is the correct documentation. Status codes are issued by a server in response to a client's request made to the server. A solution to the Influx DB CLI error Failed to check token: received status code 401 from server including instructions to install the InfluxDB V2 CLI. Hello, I have the same problem currently for `CREATE DATABASE`, have you found the solution since? endpoints (for example, Graphite, collectd, etc.) Requests by unauthorized users yield the HTTP 403 Forbidden response. Connect and share knowledge within a single location that is structured and easy to search. influx config create -n default -u http://localhost:8086 -o -t -a, Any tips or hint much appreciated I also tried following this, but fell when it mentioned paths that dont exist in my setup. (\') when creating the password and when submitting authentication requests. Get the Latest Tech News Delivered Every Day. If you authenticate with both Basic Authentication and the URL query parameters, the user credentials specified in the query parameters take precedence. However, I did find one comment that if you were using Docker you could run the CLI by running in the shell. This is the error code response for missing or invalid authentication token. If that doesn't work, log out and log back in again, and if you're still having problems try turning off any themes or plugins that may be active. Sign in See the equivalent InfluxDB v2.6 documentation: Manage API tokens. Include your generated token as part of the Authorization header in HTTP requests. vegan) just to try it, does this inconvenience the caterers and staff? I have the same problem while my influxd was compiled from source code. This is currently only possible through the InfluxDB HTTP API. influx v1 dbrp create --bucket-id 9b9841b1ecb10e16 --db sandboxDB --rp 0. v2.0.2: Pulling from influxdb/influxdb I've added a new user with command line in Influx docker shell: influx user create -n viessmann -o ourhome -p 7BBPthqVYm. When running docker inspect influxdb-telegraf-net: Note that I changed my MacAddress to a dummy add just in case. If so, have you set up users and configured your CLI to use them (docs here)? If you don't have credentials or have forgotten yours, follow the instructions provided on the website for setting up an account or resetting your password. InfluxDB will enforce authentication once there is an admin user. ts=2021-03-04T06:43:29.680034Z lvl=info msg="Using data dir" log_id=0SfU4dG000 service=store path="C:\Users\Elliot\Desktop\IIT\2021\Spring\CS 550\term project\InfluxDB\data" InfluxDB shell version: 1.8.4, show databases Story As I worked my way through using the Influx Database I tried using the InfluxDB CLI. Sign up for a free GitHub account to open an issue and contact its maintainers and the community. Pull influxdb2 to the local filesystem and create a new docker container from it (Run from cmd.exe), Then in the docker container CLI: If you come across the HTTP 401 Unauthorized error when logging in, it means that the credentials you entered were invalid for some reason. The following messages are also client-side errors and so are related to the 401 Unauthorized error:400 Bad Request,403 Forbidden,404 Not Found, and408 Request Timeout. Create at least one admin user. Back to the Vibrant C# client - When doing a simple database list command I see the newly linked sandboxDB - success! To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Is it possible to create a concave light? julien brown tiktok height. There are three options for authenticating with the CLI. Not the answer you're looking for? A 401 Unauthorized code indicates some sort of issue tied to login credentials for a given web page, while 403 Forbidden errors mean the page has been blocked. Use the -username and -password flags to provide authentication credentials Later, I simply bind the 8086 of the container to the localhost's, attach a volume for the data files, and that's pretty much all: Then, I run the following command to set up InfluxDB inside of the container: And I fill the username, password, organization and so on. The web site owner of some websites can be reached via email at webmaster@website.com, replacing website.com with the actual website name. C:\Users\jnewcomb>docker pull quay.io/influxdb/influxdb:v2.0.2 This document covers setting up and managing authentication and authorization in InfluxDB. However - any operation on sandboxDB returns a server error. Here I realise I have spent a day faffing doing no work and more pressing things get pushed my way spelling and grammar. See the authorization section for how to create an admin user. quay.io/influxdb/influxdb IN USE nightly b8c6c4f59e84 19 minutes ago 275.55 MB, I add the image to the container using this: Use different Python version with virtualenv, Random string generation with upper case letters and digits, How to upgrade all Python packages with pip. Internal linking audit Step #5. Bible Of Neonatology error received status code 401 from server influxdb influx v1 auth create --read-bucket 9b9841b1ecb10e16 --write-bucket 9b9841b1ecb10e16 --username administrator --password administrator, d) Map the v1 database to the v2 bucket InfluxDB uses the shared secret to encode the JWT signature. 502 Bad Gateway Error: What It Is and How to Fix It, HTTP Error Codes List (and How to Fix Them), How to Fix a 'Google Keeps Stopping' Error on Android. URL: PUT http://127.0.0.1:8200/v1/database/config/my-influxdb-database Once restarted, InfluxDB checks user credentials on every request and only Consider keeping them in a password manager so that you only have to remember one password. Authorization failed by ISAPI/CGI application. An access token is expired, revoked, malformed, or invalid for other reasons. The text was updated successfully, but these errors were encountered: @ElliotTanIIT is auth enabled in your influxdb.conf? How to match a specific column position till the end of line? To learn more, see our tips on writing great answers. Are all the lines in the config file supposed to begin with '#'? authentication enabled requires some additional steps. If you're sure the URL is valid, visit the website's main page and look for a link that says Login or Secure Access. Error: ts=2021-03-04T06:43:29.572810Z lvl=info msg="InfluxDB starting" log_id=0SfU4dG000 version=1.8.4 branch=1.8 commit=bc8ec4384eed25436d31045f974bf39f3310fa3c ts=2021-03-04T06:43:29.681036Z lvl=info msg="Open store (end)" log_id=0SfU4dG000 service=store trace_id=0SfU54G000 op_name=tsdb_open op_event=end op_elapsed=0.000ms Chances are they have and don't get it. Authentication and authorization should not be relied upon to prevent access and protect data from malicious actors. Hey, I think this error message happens when you try to use Vault with an InfluxDB v2.x instance. Thanks maxcoulombe September 27, 2022, 8:18pm #3 ts=2021-03-04T06:43:29.682034Z lvl=info msg="Starting HTTP service" log_id=0SfU4dG000 service=httpd authentication=false error 401 when trying to run influxdb commands in shell, start commandline terminal in folder with influxdb executables, Other relevant environment details: Container runtime, disk info, etc. i am getting the below error. Many thanks for the useful pointer I found out: So yeah, that's basically the issue. If a question is poorly phrased then either ask for clarification, ignore it, or. Richard MacCutchan22-Feb-22 6:47am The message means that you have not been authorized to access some data controlled by the server. 1dcc0eaaa3b9: Pull complete But facing with the unauthorized message when using python code. jacquin's coffee brandy; struggle jennings god we need you now lyrics; still dre piano chords letters. Is it suspicious or odd to stand by the gate of a GA airport watching the planes? Code: 400. Web servers running Microsoft IIS might give more information about the 401 Unauthorized error, such as the following: You can learn more about IIS-specific codes on Microsoft'sthe HTTP status code in IIS 7 and later versionspage. Delete your browser's cache. (See influx setup -h), Then we need to add the token to /root/.influxdbv2/config file - otherwise we need to provide it for every request (See influx config create -h), But still no luck, still getting 401 error. What's the difference between 401 Unauthorized and 403 Forbidden? Admin users have READ and WRITE access to all databases and full access to the following administrative queries: For more information about these commands, see Database management and mini31 # apt-get install influxdb2 influxdb-client Reading package lists. Error 524: A Timeout Occurred (What It Is & How to Fix It). Audit your meta descriptions. I tried googling around to try to figure out what was happening but really didnt see anything that would explain that behavior. Error code 401 (unauthorized) can be avoided in dev env by enabling http access in influx config file: [http] # Determines whether HTTP endpoint is enabled. ea3ed117f8b6: Pull complete This can be used to apply reusable authorization policies to app endpoints. The new documentation for InfluxDB Cloud backed by InfluxDB IOx is a work sims 4 basemental drugs german; zojirushi rice cooker germany But we have no way of telling why that is. -e DOCKER_INFLUXDB_INIT_PASSWORD=adminpass A solution to the Influx DB CLI error "Failed to check token: received status code 401 from server" including instructions to install the InfluxDB V2 CLI. Reddit and its partners use cookies and similar technologies to provide you with a better experience. It's possible that the 401 Unauthorized error appeared because the URL was typed incorrectly or the link that was selected points to the wrong URLone that is for authorized users only. Why do academics stay as adjuncts for years rather than move around? This is how Ive setup InfluxDB from the command line Why are Suriname, Belize, and Guinea-Bissau classified as "Small Island Developing States"? Requests with no authentication credentials or incorrect credentials yield the HTTP 401 Unauthorized response. Understand that English isn't everyone's first language so be lenient of bad You need to compile it by yourself as per issue #19986. Step #3. influxdb:2.0, vault write database/config/my-influxdb-database Use an authentication service to generate a secure token using your InfluxDB username, an expiration time, and your shared secret. run: open server: open service: listen tcp :8086: bind: Only one usage of each socket address (protocol/network address/port) is normally permitted. Not able to access container by user-defined network name from another container. privacy statement. Reload the page. I've created a bucket "viessmann" and filled some metrics into the measurements "circuit" and "device". So I tried that: When I originally installed the client (on Ubuntu) I did this: Now we know the problem. shannon sharpe salary undisputed; what was mined on the island of patmos Response from InfluxDB: Status: 401, Headers: [X-Influxdb-Build:OSS, X-Platform-Error-Code:unauthorized, X-Influxdb-Version:2.1. Authenticating Telegraf requests to an InfluxDB instance with To subscribe to this RSS feed, copy and paste this URL into your RSS reader. I just want to SHOW DATABASES to prove that the thing is running and can be conencted to.