Problem during installation | GitHub Installation

The ThingSpeak community site has been upgraded to a new site. This site is currently in read-only mode. You can ask questions or post and read discussions on the new site.

Problem during installation

September 14, 2015
5:39 am

melkikh

New Member

Members

Forum Posts: 3

Member Since:
September 14, 2015

Offline

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!

September 14, 2015
8:56 am

hans

MathWorks

Members

Forum Posts: 4

Member Since:
January 19, 2011

Offline

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.

October 16, 2015
7:52 am

melkikh

New Member

Members

Forum Posts: 3

Member Since:
September 14, 2015

Offline

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!

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
24 Guest(s)

Currently Browsing this Page:
1 Guest(s)