Support: Installation Issues with MapKnitter

[SidharthBansal]

Facing trouble installing Mapknitter? We are here to help you.

[Dhiraj240]

@SidharthBansal After tackling to much issues and setting up ubuntu on vmware, today i was able to manage things.
But a small error is coming as when i use curl -L https://get.rvm.io | bash -s stable it asks for a key and there i am getting timeout error which is annoying me.
Need Help !

[SidharthBansal]

Same behaviour here. Trying to debug.

…

On Sat, Feb 2, 2019, 8:23 PM Dhiraj Sharma ***@***.*** wrote: @SidharthBansal <https://github.com/SidharthBansal> After tackling to much issues and setting up ubuntu on vmware, today i was able to manage things. But a small error is coming as when i use curl -L https://get.rvm.io | bash -s stable it asks for a key and there i am getting timeout error which is annoying me. Need Help ! — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#307 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AUACQ0DvKRWDEHxVbtqOYbv0oWmt7VFwks5vJaZbgaJpZM4aUmi0> .

[Dhiraj240]

Alright, these errors are really annoying.

[Dhiraj240]

@SidharthBansal Have you found the solution @jywarren can you provide us help with this?

[jywarren]

I think checking rvm.io will show how to install rvm the most standard way.

Working on getting it running in ruby 2.4.4 here, too! #320

[jywarren]

Yes https://rvm.io shows how to get the keys!

[kaustubh-nair]

Does the docker container work properly?
I'm getting an error while building it.

ERROR: Service 'web' failed to build: The command '/bin/sh -c apt-get update -qq && apt-get install -y bundler libmysqlclient-dev ruby-rmagick libfreeimage3 libfreeimage-dev ruby-dev gdal-bin python-gdal curl libcurl4-openssl-dev libssl-dev zip nodejs-legacy npm ##ALSO TRIED: ruby-pg' returned a non-zero code: 100

[jywarren]

oh, hmm, maybe this is a question for @icarito - but the docker container should be used in Travis, and that is building currently. Can you add more information from the error you saw, maybe a fuller log shared in gist.github.com? Thanks!

…

On Wed, Feb 6, 2019 at 9:43 AM Kaustubh Nair ***@***.***> wrote: Does the docker container work properly? I'm getting an error while building it. ERROR: Service 'web' failed to build: The command '/bin/sh -c apt-get update -qqe-dev ruby-dev gdal-bin python-gdal curl libcurl4-openssl-dev libssl-dev zip nod — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#307 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABfJ6cMS6lyDncSHxzzXHqXvLQPWCK7ks5vKun-gaJpZM4aUmi0> .

[Dhiraj240]

Thanks it worked @jywarren but now when i ran bundle exec rake db:setup it asked me a root password which didn't work for mysql and it is throwing an error.
I looked stack overflow and other sites but they to haven't solved the issue.
May i know as how can i see or check the root password in ubuntu ?
Although i will check this again in morning.

[kaustubh-nair]

Here is a larger error log
I was trying to build the container using docker compose

[grvsachdeva]

Hi @Dhiraj240, you can reset the password using - https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

And, if you still get error - ERROR 1698 (28000): Access denied for user 'root'@'localhost'" error then, checkout this thread - https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost.

I also faced some of these issues but finally able to resolve them.Thanks!

[icarito]

@kaunair please check that you have a recent version of Docker. I found a related issue to your log at Shippable/support#4398 and it was an old Docker version! Try it and let us know, also tell us what command did you run exactly, thanks!

[icarito]

@Dhiraj240 about the MySQL root password if you mean from the container it can be seen in the mysql logs: docker-compose logs db on first run (scroll all the way back).

[niravasher]

after bundle install
sudo service mysql start
bundle exec rake db:setup gives Access denied for user 'mapknitter'@'localhost' (using password: YES).
Please provide the root password for your mysql installation

'some random password'
rake aborted!
Mysql2::Error: Access denied for user 'root'@'localhost' (using password: YES)

(I already have set root password for mysql while installing sudo apt-get mysql-server. I also tried the stack overflow solution given by @gauravano but it didn't work for me)

[jywarren]

Hi, have you configured the passwords and usernames in /config/database.yml?

…

On Wed, Feb 13, 2019 at 11:33 AM Nirav Asher ***@***.***> wrote: On entering "bundle exec rake db:setup" Getting the error "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) rake aborted! Mysql2::Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#307 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABfJ_m5zF-3x8_qCu622YJUzbKeIfI2ks5vND5GgaJpZM4aUmi0> .

[niravasher]

Yes, I confirmed they are same. I atried to uninstall and reinstall mysql-server, everything went fine just the last step bundle exec passenger start gave me this
"Message from application: Address already in use - listen(2) (Errno::EADDRINUSE)"
I tried looking over stack overflow, but I didn't find anything in my local running on port 3000

[jywarren]

Hm, it may be that you are already running the server in another terminal window... but that doesn't address the mysql issue. Are you able to log in manually to mysql using `mysql -u root -p PASSWORD` without trouble? And can you share your database.yml (but please strip out the PASSWORD field itself!)?

…

On Wed, Feb 13, 2019 at 2:52 PM Nirav Asher ***@***.***> wrote: Yes, I confirmed they are same. I atried to uninstall and reinstall mysql-server, everything went fine just the last step bundle exec passenger start gave me this "Message from application: Address already in use - listen(2) (Errno::EADDRINUSE)" I tried looking over stack overflow, but I didn't find anything in my local running on port 3000 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#307 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABfJz9WefOay2ok2YArE-v5YsqjDFk7ks5vNGz3gaJpZM4aUmi0> .

[niravasher]

@jywarren

[grvsachdeva]

I gave different names to database in development and in testing:

[grvsachdeva]

I faced somewhat similar errors initially, I tried resetting password too but at last I changed the mysql plugin to mysql_native_password instead of auth_socket using - https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost

You can do this on non-root user but changing plugin for root user is really upto you.

[niravasher]

Now running "bundle exec passenger start" gives this error
Message from application: Address already in use - listen(2) (Errno::EADDRINUSE).
So by typing sudo lsof -i tcp:3000 i confirmed that there is nothing else going on port 3000 but still doesn't work

[grvsachdeva]

you can run the rails server on a different port with rails s -p [port-number] . Also, it's fine to start with default server WebRick for development(when you run server with rails s, webrick is used by default) and you can go with passenger after some time.

Thanks!

[jywarren]

Hi, all, thanks to @gauravano and @sashadev-sky we are now on Ruby 2.4.4: #320

[Dhiraj240]

@jywarren @gauravano Now, i am getting the following error

bundle exec rake db:setup
rake aborted!
NoMethodError: undefined method `active_record' for #<Rails::Application::Configuration:0x0000556569694a78>
/home/dhiraj/.rvm/gems/ruby-2.4.4/gems/railties-3.2.22.5/lib/rails/railtie/configuration.rb:85:in `method_missing'
/home/dhiraj/mapknitter/config/application.rb:55:in `<class:Application>'
/home/dhiraj/mapknitter/config/application.rb:13:in `<module:Mapknitter>'
/home/dhiraj/mapknitter/config/application.rb:12:in `<top (required)>'
/home/dhiraj/mapknitter/Rakefile:5:in `require'
/home/dhiraj/mapknitter/Rakefile:5:in `<top (required)>'
/home/dhiraj/.rvm/gems/ruby-2.4.4/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/home/dhiraj/.rvm/gems/ruby-2.4.4/bin/ruby_executable_hooks:24:in `eval'
/home/dhiraj/.rvm/gems/ruby-2.4.4/bin/ruby_executable_hooks:24:in `<main>'
(See full trace by running task with --trace)

I tried the database configuration given in the above screenshots.

[cesswairimu]

Aha... Please make sure you have copied database.ymland config.yml are copied correctly see @nstjean comment above of the solution.. Was facing the same issue you are pretty close 🤞

[stefanosu]

@nstjean Hey it seems that I'm having the same error you are but I'm having trouble implementing the steps you've done to arrive at fixing the issue. Did you make sure that the config files were properly copied the same as they were from the repo?

[jywarren]

Hi all, i had some trouble booting this and traced it to the bootsnap gem, which does caching to speed up application boot. I was able to bypass it by commenting out line 4 of config/boot.rb:

require 'bootsnap/setup' # Speed up boot time by caching expensive operations.

[chepyego]

am having trouble setting up my database though am able to acces mysql with mysql -u root -p but when i ran 'bundle exec rails db:setup am getting this error 'MySQL Error: Access denied for user root@localhost i have tried the proposed solutions above but still getting same error

[PeculiarE]

Hello @chepyego. Most times, that error is thrown if you haven't configured your database correctly in the database.yml file. Could you please confirm that the username and password for your development database is correctly inputted?

[chepyego]

Hello @PeculiarE i managed to fix it by changing the test_database password and username to be the same as the development database. But am having another problem I can attach a screenshot below

[PeculiarE]

Nicey. Well done 😄 😄 @chepyego. Please check out this stackoverflow thread to fix the incompatible module issue: https://stackoverflow.com/questions/56617209/the-engine-node-is-incompatible-with-this-module.

[chepyego]

Nicey. Well done smile smile @chepyego. Please check out this stackoverflow thread to fix the incompatible module issue: https://stackoverflow.com/questions/56617209/the-engine-node-is-incompatible-with-this-module.

am getting twosolution one is to run yarn install --ignore-engines and another one is to delete(delete node_modules/, package-lock.json & yarn.lock) and run yarn install .Am not sure which should I go with, @PeculiarE what is your take here?

[cesswairimu]

Hi @chepyego , you could give this solution a try

sudo apt-get purge --auto-remove nodejs
curl -fsSL https://deb.nodesource.com/setup_14.x | sudo -E bash -
sudo apt-get install -y nodejs

[chepyego]

Hi @chepyego, you could give this solution a try

sudo apt-get purge --auto-remove nodejs
curl -fsSL https://deb.nodesource.com/setup_14.x | sudo -E bash -
sudo apt-get install -y nodejs

hey @cesswairimu i think I have managed to solve the issue I installed node v16 and set nvm to use this version then I yarn install and I didn't receive any errors

[chepyego]

it is up and running

[chepyego]

Thank you @PeculiarE and @cesswairimu for your help

[chepyego]

just a quick question @cesswairimu how do we login in using data in seed.rb I haven't understood from the installation guide

[cesswairimu]

@chepyego if you have already ran rake db:seed (run it if not) you can navigate to this url locally and you should be logged in http://localhost:3000/local/harry

[PeculiarE]

You're welcome @chepyego 😄 ...I'm glad it's working now for you

[PeculiarE]

@cesswairimu .....please, I have a question. If we want to run the app on gitpod, do we need either mysql2 or sqlite3 already installed on our PCs?

Update: i found out the answer to this. Everything on GitPod is using the remote server in the GitPod service, so it doesn't matter if your local has mysql or sqlite installed. The remote will have mysql automatically set up 😄

[chepyego]

@chepyego if you have already ran rake db:seed (run it if not) you can navigate to this url locally and you should be logged in http://localhost:3000/local/harry

just ran rake db:seed and I get this huge error which I can't seem to get solution since yesterday (Mysql2::Error: Duplicate entry '82' for key 'warpables.PRIMARY)

[PeculiarE]

just ran rake db:seed and I get this huge error which I can't seem to get solution since yesterday (Mysql2::Error: Duplicate entry '82' for key 'warpables.PRIMARY)

Hi @chepyego...I replied your inquiry on this same issue in the gitter chatroom, but I dunno if you saw it. So I'm just going to repost it here incase you didn't and also to help anyone else who might have this issue in the future.

Here's my best guess: You probably already ran rake db:setup when setting up the project on your PC. I'm not so familiar with Rake, so had to go do my research. Found out that calling the command rake db:setup actually tells your PC to run three commands in succession: db:create, db:schema:load, and db:seed.

As you can see, you've already seeded your db when you ran the db:setup command. So running the db:seed command after already running rake db:setup throws the duplicate error you received.

Hope this makes sense/helps!

[chepyego]

just ran rake db:seed and I get this huge error which I can't seem to get solution since yesterday (Mysql2::Error: Duplicate entry '82' for key 'warpables.PRIMARY)

Hi @chepyego...I replied your inquiry on this same issue in the gitter chatroom, but I dunno if you saw it. So I'm just going to repost it here incase you didn't and also to help anyone else who might have this issue in the future.

Here's my best guess: You probably already ran rake db:setup when setting up the project on your PC. I'm not so familiar with Rake, so had to go do my research. Found out that calling the command rake db:setup actually tells your PC to run three commands in succession: db:create, db:schema:load, and db:seed.

As you can see, you've already seeded your db when you ran the db:setup command. So running the db:seed command after already running rake db:setup throws the duplicate error you received.

Hope this makes sense/helps!

hey, I guess i didn't see your comment, your point makes sense and is very helpful . i can now make my first PR

[chepyego]

but still i can't login in the browser with those credentials in in seed.rb

[PeculiarE]

What's the error you get?

[chepyego]

What's the error you get?

it is not an error but am trying to login in URL using this http://localhost:3000/local/harry where harry is the username and it is in our seed.rb but nothings happens . i don't know if this is how it is suppose to be

[chepyego]

hey I just ran this I copied from the documentation http://localhost:3000/local/harry and it has worked although I don't see any difference with the one above. Am now good to go thanks a lot again you have really helped me

[PeculiarE]

You're welcome 😃 ❤️ ....glad you're up and running now 🚀

[chepyego]

You're welcome smiley heart ....glad you're up and running now rocket

yes am happy too I hope am that late to start making my contributions

[PeculiarE]

No, it's not too late. Have you requested for a FTO issue at https://github.com/publiclab/plots2/10153?

[chepyego]

No, it's not too late. Have you requested for a FTO issue at https://github.com/publiclab/plots2/10153?

Not yet , What is FTO?

[PeculiarE]

It basically stands for first-timer-only and is a label given to issues. An FTO issue is specially curated for first-timers, that is, newbies to the project/codebase.

In an FTO issue, the problem and solution are given to you. All you have to do is implement it by following the instructions given. Solving an FTO issue gets you familiar with the project's version control, starts helping you get familiar with the codebase, and of course, gives you a sense of confidence. Once you're done with solving an FTO, you can progress into looking for a bit more complex issues (e.g. issues with labels such as help-wanted, bug etc.). These issues don't yet have solutions; you have to provide it. You can even start creating FTOs for others.

[chepyego]

It basically stands for first-timer-only and is a label given to issues. An FTO issue is specially curated for first-timers, that is, newbies to the project/codebase.

In an FTO issue, the problem and solution are given to you. All you have to do is implement it by following the instructions given. Solving an FTO issue gets you familiar with the project's version control, starts helping you get familiar with the codebase, and of course, gives you a sense of confidence. Once you're done with solving an FTO, you can progress into looking for a bit more complex issues (e.g. issues with labels such as help-wanted, bug etc.). These issues don't yet have solutions; you have to provide it. You can even start creating FTOs for others.

okay got it, am an outreachy applicant and plot2 is not part of the outreachy project and I would like to work on this mapknitter project ,I guess I can find some FTO tickets in mapknitter too, or is it a must to work on FTO in publiclab/plot2 project?

[cesswairimu]

hi all, you are right @chepyego, you do not work on plots2 project , you could just work on mapknitter only. I really love the great collaboration here. Many thanks everyone for helping each other and helping out ❤️ ❤️