Using nightly Builds grafana_4.3.0-7785pre1_amd64.deb MYSQL error

alphatech · May 10, 2017, 2:46pm

Hi,
I really love this application and I would like to try the new mysql datasource. I configured the datasource as servername:port with the database and everything required to connect. The save and test does not give an error but when I try to create a dashboard and select the datasource, it gives me this error dial tcp: address 192.168.0.14: missing port in address, what am I doing wrong. Any suggestion would be greatly appreciated.

daniellee · May 10, 2017, 3:28pm

Check my answer here. Does that help? It should look like a normal connection string.

alphatech · May 10, 2017, 3:34pm

Hi,
I appreciated your fast reply, sorry I did not include the picture before. this is what it looks like right now.

daniellee · May 10, 2017, 3:51pm

My example had port 3307 but usually MySQL is on port 3306. Is that the case for you?

alphatech · May 10, 2017, 4:03pm

Hi, you are correct, I had it to 3306 but I changed it to 3307 after seeing your example. Both ports showed the same results. I can connect to the server 192.168.0.14 and the database just fine from Mysql workbench using the user name as of the picture.

Thanks again

daniellee · May 10, 2017, 5:29pm

And what port do you have in Workbench?

alphatech · May 10, 2017, 6:00pm

In Workbench I can access the server with port 3306 from another pc without issues.

alphatech · May 10, 2017, 8:08pm

Please let me know if you or your team need more help to debug this.

daniellee · May 11, 2017, 7:09am

There are a few things you can try.

Restart your Grafana Server - the MySQL data source is still in a beta and we have bug where it caches details sometimes.
Check that you access to the MySQL server from the server where Grafana is installed. You say you have access from your computer via MySQL Workbench but does your Grafana Server have access?

alphatech · May 11, 2017, 2:15pm

Thank you very much, that did it. I’m so close now to the end result and to be honest, I can not wait for it, I would appreciate few extra minutes of your time.

This is my table, when I run this query in Grafana, it give me an error, I’m doing something wrong with the query?

daniellee · May 11, 2017, 2:19pm

In this case, you are doing nothing wrong. That is unwritten code. We do not support all the types yet. This should be fixed in the next day or two and be included in the 4.3 release. Sorry about that - this is still in the beta phase.

alphatech · May 11, 2017, 2:22pm

I understand it is in beta and I can work with it with no issues. Do you know what types it supports, I can change it in the database to support your data type. Based on my screens, how would you construct the query?

P.S. I know how much work you guys put into this program, thank you all for the hard work.

alphatech · May 12, 2017, 4:56pm

I upgraded to the latest release as you suggested, unfortunately I’m still getting an error
I will be happy to be as of assistance to debug it.

alphatech · May 12, 2017, 5:29pm

this is another example

meyerder · May 12, 2017, 8:09pm

I have noticed with the MySQL plugin you need to delete the datasource and make it a new name if you screw up the first time. I have had it happen multiple times to me as I also forget to add it initially

Thanks

alphatech · May 12, 2017, 8:15pm

thanks. I did that and I got Database type LONG not supported. I’m trying to figure out what that means. Thanks for your input.

daniellee · May 15, 2017, 8:16am

There are loads of MySQL data types and we only support some of them at the moment. LONGTEXT is a blob type and we have not added mappings for the blob types (and I’m not sure how we would show them in Grafana).

What types do you have for your columns?
Found row with no time value -> do you have a row in your result with a null instead of a datetime value?

alphatech · May 15, 2017, 12:56pm

Hi, thanks for your reply, you seem to know your stuff. I will be happy to work with you with your data type, you let me know what type you accept and I will make it happen by changing my data type in the table. I have attached the schema and what I’m trying to accomplish below. In short, I have a table with a value field, right now it is “Int”, a date field as datetime and type as metric as varchar (100). I really would like to make it to work, this apps is really nice once it works with my data.

Thanks

daniellee · May 16, 2017, 10:06am

What version of Grafana are you using now? We added some mappings for the 4.3.0-beta1 release. One of the mappings that was added was for int (LONG and not LONGTEXT).

alphatech · May 16, 2017, 1:05pm

Hi daniellee, I updated to the latest nightly builds 4.3.0-7817 beta1, still having issues. As you have noticed none of my fields are as you describe, my data fields are value as “Int” (11), a date field as datetime and metric as varchar (100). Could you please provide me of an example of your query that works with your data types and table, I could adjust my table based of your table.

Thanks