search

mlpack / benchmarks

Machine Learning Benchmark Scripts
101 stars 49 forks source link

_mysql_exceptions.OperationalError: (1045, "Access denied for user #23

Closed ThyrixYang closed 7 years ago

ThyrixYang commented 7 years ago

When I try to save log by LOG=True, this error occurred. How to deal with it? Is it needed to create a database by hand?

zoq commented 7 years ago

Hello, yes you have to create the database and give the user write/read permissions, you can specify the database user and password with:

make USER=USERNAME PASSWORD=PASSWORD run

and you can also specify the database in the .yaml file. Let us know if that solves your problem.

ThyrixYang commented 7 years ago

Hi, @zoq , worked well! But when I try to make a report by "make reports", it shows "can't open file 'benchmark/make_reports.py'". I did not see this file anywhere, what's wrong? Thank you!

zoq commented 7 years ago

The make reports command was removed as we switch from the static html reports to the javascript reports. It looks like I've forgotten to remove the command from the CMake file. I'll do that later today.

So, depending on the database you use to store the results you have to setup your system accordingly. If you use sqlite wich is the default database for the reports the setup is minimal, just go into the reports folder and run: python -m SimpleHTTPServer and open a browser with 127.0.0.1:8000

If you use mysql as a database backend, make sure you can handle php files, e.g. by creating a simple phpinfo file. That is necessary since we need a simple php script to communicate with the database. Besides that open benchmarks/reports/js/benchmarks.js and uncomment // dbType = "mysql" I haven't found and easy solution to set the value from the command line also make sure to set the correct credentials in benchmarks/reports/php/config.ini.

Btw. If you like to switch the backend from mysql to sqlite set sqlite as a driver in the .yaml config file. I hope this is helpful.

ThyrixYang commented 7 years ago

@zoq , I just want to produce some images and tables. Is there any method to do this more conveniently without produce a web page? (if it's the only one way, I'll try then) :)

zoq commented 7 years ago

Right now that are basically the only options you have (here is the interactive interface we use to show some results: http://www.mlpack.org/benchmark.html); However, since all results are stored in the database you can create your own visualization really quick. Another solution is to use the 'LOG=False' option to print a simple table to the console, maybe that's sufficient enough for your case?

ThyrixYang commented 7 years ago

@zoq Thank you. I think some images are better, but not necessary for me now. I may try to solve this problem latter.

zoq commented 7 years ago

I think this question is answered, so I'm going to go ahead and close this issue. If there is something I can clarify or something I left answered, feel free to reopen it.