Problem during installation | GitHub Installation | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed sp_TopicIcon
Problem during installation
No permission to create posts
September 14, 2015
5:39 am
Avatar
melkikh
New Member
Members
Forum Posts: 3
Member Since:
September 14, 2015
sp_UserOfflineSmall 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
Avatar
hans

MathWorks
Members
Forum Posts: 4
Member Since:
January 19, 2011
sp_UserOfflineSmall 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
Avatar
melkikh
New Member
Members
Forum Posts: 3
Member Since:
September 14, 2015
sp_UserOfflineSmall 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:
28 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:

swatiiot, kalyanigaware16@gmail.com, Romi, Drakan01, majidkhan7, atharvganla

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457