Adminer - How to copy to and where in measureit

[ma...@rmtucker.f2s.com]

According to the wiki it should already be there but it seems it is missing from the prepared image?

[Steve]

I have phpMyAdmin on my RPi, but just tried Adminer.

I downloaded 4.0.1 from here https://sourceforge.net/projects/adminer/files/Adminer/

Then I just copied it to my public_html directory (when I set my RPi up is is /www for my machine), entered my local IP address for the MeasureIt RPi with the adminer file name added and it loaded up. (I use my RPi to host my weather station too, so it's not a standard measureit installation from the image).

For mine it's as simple as http://192.168.0.100/adminer-4.1.0.php

If you're using a measureit image, then on your installation you might (probably) have to copy it to public_html/measureit (/web/measureit/) then http://<your-measureit-ip>/adminer-4.1.0.php

Adminer website says you can export data as SQL or CSV, but I don't immediately see how it's done with Adminer.

Steve.

[Mark Tucker]

Steve
I get the following error:-

Command:    put "/home/rmtucker/Downloads/adminer-4.1.0.php" "adminer-4.1.0.php"
Error:    /web/measureit/adminer-4.1.0.php: open for write: permission denied
Error:    File transfer failed

Regards
Mark

[Thomas]

You are right. The image online is not the latest version. I add some update informations to the wiki.

Please tell me if this information is clear enough.

https://github.com/lalelunet/measureit/wiki/Help---FAQ#how-do-i-update-my-measureit-installation

[Steve]

Mark, it might be a user permission problem.

I take the easy (less secure) route when working with my Pi. I use WinSCP and Putty on my Windows machine, log in as root and can do whatever I like on the Pi. Copying adminer.php for me was just a matter of dragging and dropping.

Steve.

[Steve]

Hi Thomas,

My installation isn't from the image. Is it simple enough for me to change it be able to use git pull?

Steve.

[ma...@rmtucker.f2s.com]

Steve

What is the root password on the image version,Any idea?

Regards
Mark

[Steve]

Mark,

There might not be a root user in the image.

You can create one or try adding sudo in front of any command you issue.

If you don't want to have to add sudo in front of commands and want to log in a root try:

sudo passwd root

enter a password and log in as root.

(I think that's it)

Steve.

[ma...@rmtucker.f2s.com]

Thomas

Type su - web
Asks for a password which is not raspberry

Regards
Mark

[Thomas]

Hi Steve,

this is not a problem :)

I assume your measureit installation is in /web/measureit

So stop the grabber. Change to /web and move the old one: mv measureit measureit_old

Change to user web:  su - web

Create measureit directory: mkdir measureit

Then you can checkout measureit from git

git clone git://github.com/lalelunet/measureit.git

now you should have all measureit files in the directory.


Make sure the webserver points to the measureit_public_html directory as root directory. If not change it and restart the webserver

web-root /web/measureit/measureit_public_html

The grabber is now in the /web/measureit/measureit_system_files directory. So if your grabber starts with init.d or is controlled with supervise you had to change the path of the grabber.

If you change f.e. the config file you can create a git ignore file. There is currently no readme online. I had to test this out what happens and document this.

https://help.github.com/articles/ignoring-files/

[Thomas]

There is not root password. A sudo bash is enough. Then you can chage to user web

You do not had to do anything else as doing a git pull. See

https://github.com/lalelunet/measureit/wiki/Help---FAQ#how-do-i-update-my-measureit-installation

[Mark Tucker]

Thomas

I have managed to get Adminer running but now it wants
Username?
Password?
Database?

Regards
Mark

--
You received this message because you are subscribed to a topic in the Google Groups "measureit" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/measureit/XQUUe9G3Imk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to measureit+...@googlegroups.com.
To post to this group, send email to meas...@googlegroups.com.
Visit this group at http://groups.google.com/group/measureit.
To view this discussion on the web visit https://groups.google.com/d/msgid/measureit/89972b37-2d5c-4fd7-8a6a-8e2f634edd78%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Thomas]

The database is measure_it

Passwords should be default values. See
https://github.com/lalelunet/measureit/wiki/Raspberry-Pi

Am Sonntag, 11. Januar 2015 16:09:35 UTC+1 schrieb Mark Tucker:

Thomas

I have managed to get Adminer running but now it wants
Username?
Password?
Database?

Regards
Mark

On 11/01/15 14:59, Thomas wrote:

There is not root password. A sudo bash is enough. Then you can chage to user web

You do not had to do anything else as doing a git pull. See

https://github.com/lalelunet/measureit/wiki/Help---FAQ#how-do-i-update-my-measureit-installation

Am Sonntag, 11. Januar 2015 15:41:24 UTC+1 schrieb ma...@rmtucker.f2s.com:

Steve

What is the root password on the image version,Any idea?

Regards
Mark

--
You received this message because you are subscribed to a topic in the Google Groups "measureit" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/measureit/XQUUe9G3Imk/unsubscribe.

To unsubscribe from this group and all its topics, send an email to measureit+unsubscribe@googlegroups.com.

[Steve]

Mark, try:

username: measureit

password: measureit (supposed to change it after installation - especially if the site is visible on the www)

database: measure_it

Steve.

[Mark Tucker]

Steve

I tried
username measureit
password measureit
database measure_it

Also

username pi
password raspberry
database measure_it

At a loss now

Mark

[Thomas]

username root
password raspberry
database measure_it

[Mark Tucker]

Thomas

If i follow your wiki instructions to update

su - web

It asks for password?

Regards
Mark

On 11/01/15 14:59, Thomas wrote:

[Mark Tucker]

Thomas

My bad
I have too be logged in as root

Regards
Mark