5:39 am
September 14, 2015

Hi!
I want to install a thingspeak on a Web-server (Ubuntu server 12.04 x64) on a virtual machine (virtualbox). Linux is almost clean (i installed only openssh and SAMBA) . I used this script ( https://gist.github.com/abythell/8225124#file-thingspeak-install-sh ), but also installed manually.
In step command "bundle exec rake db:create" i get the following message:
Access denied for user 'thing'@'localhost' (using password: YES)Please provide the root password for your mysql installation
>
Then I get an error:
Access denied for user 'root'@'localhost' (using password: NO)
/usr/local/lib/ruby/gems/2.1.0/gems/mysql2-0.3.16/lib/mysql2/client.rb:70:in `connect'
/usr/local/lib/ruby/gems/2.1.0/gems/mysql2-0.3.16/lib/mysql2/client.rb:70:in `initialize'
...
Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "reconnect"=>false, "database"=>"thingspeak_test", "pool"=>5, "username"=>"thing", "password"=>"speak", "socket"=>"/var/run/mysqld/mysqld.sock"}
I try the following:
1. configure /config/database.yml
2. bundle install mysql2
etc
Nothing helps.
How do I fix this?
Sorry for my English
Thank u!
8:56 am

MathWorks
January 19, 2011

melkikh,
If you are installing ThingSpeak from the Github repo, you may need to change the username/password in the database.yml file.
Line 24 of the linked script renames the database.yml.example file to database.yml. When the rails server starts, it reads the database.yml file to understand what it should connect to. In this case, the example file:
https://github.com/other/thingspeak/blob/master/config/database.yml.example#L23
shows the username is 'thing' and the password is 'speak'. From the output above, it's trying to connect to the database with username 'root' and no password.
If the MySQL database is setup correctly, you can simply change the username/password in the database.yml. or you will need to create a new user in database.
7:52 am
September 14, 2015

jklol said
melkikh,
If you are installing ThingSpeak from the Github repo, you may need to change the username/password in the database.yml file.
Line 24 of the linked script renames the database.yml.example file to database.yml. When the rails server starts, it reads the database.yml file to understand what it should connect to. In this case, the example file:
https://github.com/other/thingspeak/blob/master/config/database.yml.example#L23
shows the username is 'thing' and the password is 'speak'. From the output above, it's trying to connect to the database with username 'root' and no password.
If the MySQL database is setup correctly, you can simply change the username/password in the database.yml. or you will need to create a new user in database.
Thanks!
Most Users Ever Online: 166
Currently Online:
24 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
rw950431: 272
Vinod: 240
piajola: 95
turgo: 70
vespapierre: 63
Adarsh_Murthy: 62
Member Stats:
Guest Posters: 1
Members: 8665
Moderators: 1
Admins: 2
Forum Stats:
Groups: 3
Forums: 14
Topics: 1600
Posts: 5760
Newest Members:
bogart, estebanmateo93, mikewrite, onlinebusiness, winzy99, Zark_zeuganModerators: cstapels: 460
Administrators: Hans: 405, lee: 457