search

thebestion / RPI.PIHome2.0-GUI-Frontend

PiHome 2.0 is a RaspberryPI home automation open source project
Other
36 stars 29 forks source link

Cannot Access Phpmyadmin #2

Open acestu opened 8 years ago

acestu commented 8 years ago

Hi Sebastian, I have followed the install procedure but when I get to the last bit installing database when I navigate to my pi's ip/phpmyadmin it comes up with the Apache NOT FOUND page, any help appreciated.

Thanks Stuart

thebestion commented 8 years ago

Hi Stuart,

My pi ip means the IP you got from your router if your raspberry is connected to your network.

For example Http://192.168.1.100/phpmyadmin

Best regards You are welcome Sebastian

Von meinem iBett gesendet

On 13 Nov 2015, at 6:27 PM, acestu notifications@github.com wrote:

Hi Sebastian, I have followed the install procedure but when I get to the last bit installing database when I navigate to my pi's ip/phpmyadmin it comes up with the Apache NOT FOUND page, any help appreciated.

Thanks Stuart

— Reply to this email directly or view it on GitHub.

acestu commented 8 years ago

Hi Sebastian, yes that is what I am doing ie

http://192.168.0.15/phpmyadmin

but it says:

The requested URL /phpmyadmin was not found on this server. Apache/2.2.22 (Debian) Server at 192.168.0.15 Port 80

Thanks Stuart

thebestion commented 8 years ago

Then please repeat The install. Special this Part with phpmyadmin. There is One part you Must select Apache Server

Von meinem iBett gesendet

On 13 Nov 2015, at 7:05 PM, acestu notifications@github.com wrote:

Hi Sebastian, yes that is what I am doing ie

http://192.168.0.15/phpmyadmin

but it says:

The requested URL /phpmyadmin was not found on this server. Apache/2.2.22 (Debian) Server at 192.168.0.15 Port 80

Thanks Stuart

— Reply to this email directly or view it on GitHub.

acestu commented 8 years ago

OK

I will start over tomorrow

What is the best OS to start with Sebastian ?

Many Thanks Stuart

thebestion commented 8 years ago

Ok :)

To Start what?

For work only Mac. And Server only debian linux :)

Cheers Sebastian

Von meinem iBett gesendet

On 13 Nov 2015, at 7:19 PM, acestu notifications@github.com wrote:

OK

I will start over tomorrow

What is the best OS to start with Sebastian ?

Many Thanks Stuart

— Reply to this email directly or view it on GitHub.

acestu commented 8 years ago

Hi,

Sorry

I meant I will Start installing from scratch tomorrow

and should I use

Raspian Jessie or Raspbian Wheezy ?

Thanks again Stuart

thebestion commented 8 years ago

I think wheezy

Von meinem iBett gesendet

On 13 Nov 2015, at 7:44 PM, acestu notifications@github.com wrote:

Hi,

Sorry

I meant I will Start installing from scratch tomorrow

and should I use

Raspian Jessie or Raspbian Wheezy ?

Thanks again Stuart

— Reply to this email directly or view it on GitHub.

acestu commented 8 years ago

Ok Thank you

acestu commented 8 years ago

Hi Sebastian,

I started installing again today and all goes well until I type the long apache2 install commands when it comes back with:

E: Unable to locate package apache2-npm-prefork

Any help greatly appreciated Thanks Stuart

acestu commented 8 years ago

Sorry ignore the last comment, I have installed everything again but when I try to connect to phpmyadmin it says:

Not Found

The requested URL /www/phpmyadmin/ was not found on this server.

Apache/2.2.22 (Debian) Server at 192.168.0.15 Port 80

Could this be a Path problem ?

Thanks Stuart

acestu commented 8 years ago

Also prviously I tried:

Not Found

The requested URL /phpmyadmin/ was not found on this server.

Apache/2.2.22 (Debian) Server at 192.168.0.15 Port 80

Thanks Stuart

acestu commented 8 years ago

Hi,

Ok solved that issue,

Typed: nano /etc/apache2/apache2.conf

and add this line, save and reboot

Include /etc/phpmyadmin/apache.conf

only now I can't log in to mysql lol

Thanks Stuart

acestu commented 8 years ago

Hi,

I think I am nearly there, I have installed the database, but what is the command on the pi for starting the pihome gui please ?

Thanks Stuart

acestu commented 8 years ago

Hi,

If I type my pi's ip address into my pc browser it says:

SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

Thanks Stuart

acestu commented 8 years ago

Hi,

I think pihome can't connect to the database, which means when you are installing mysql and prompted for a password you must have to put in a certain password or if you put any password in it you would have to enter it in some sort of config file somewhere.... do you have any ideas please I have spent 2 days on this now.

Thanks in advance Stuart

acestu commented 8 years ago

Hi,

I changed the db password in dbconfig.inc.php and voila the Frontend opened in my browser,I entered admin,pihome and it let me in, however if I click on any of the menu items I get the Apache cant find on this server page which makes me think it is still a Path problem...

Thanks Stuart

thebestion commented 8 years ago

hi,

if you install mysql you must set a mysql user und password.

if is not root root you must change it in dbconfig.inc.php https://github.com/cerosx/RPI.PIHome2.0-GUI-Frontend/blob/master/pihome/config/dbconfig.inc.php https://github.com/cerosx/RPI.PIHome2.0-GUI-Frontend/blob/master/pihome/config/dbconfig.inc.php

cheers sebastian

On 14 Nov 2015, at 14:50, acestu notifications@github.com wrote:

Hi,

I changed the db password in dbconfig.inc.php and voila the Frontend opened in my browser,I entered admin,pihome and it let me in, however if I click on any of the menu items I get the Apache cant find on this server page which makes me think it is still a Path problem...

Thanks Stuart

— Reply to this email directly or view it on GitHub https://github.com/cerosx/RPI.PIHome2.0-GUI-Frontend/issues/2#issuecomment-156742149.

Mit freundlichen Grüßen / best regards

Sebastian Harke drawDESIGN

Contact: Telephone: (0049) 0241 450 18 63 Mobile: (0049) 01520 365 99 70 Email: info@draw-design.com Internet: page.draw-design.com

acestu commented 8 years ago

Hi Sebastian, I have reinstalled everything again using the root password installed the database but when the frontend comes up and I sign in, if I click on weather or settings in the menu I get an Apache error page saying that the URL can't be found, would you have any ideas on this please ?

Thanks Stuart

thebestion commented 8 years ago

ok thats easy

look at /home/www/

is there the .htaccess file?

i think no :)

cd /home/www/

nano .htaccess

paste - https://raw.githubusercontent.com/cerosx/RPI.PIHome2.0-GUI-Frontend/master/.htaccess https://raw.githubusercontent.com/cerosx/RPI.PIHome2.0-GUI-Frontend/master/.htaccess

ctrl + o ctrl + x

cheers :))

On 14 Nov 2015, at 16:35, acestu notifications@github.com wrote:

Hi Sebastian, I have reinstalled everything again using the root password installed the database but when the frontend comes up and I sign in, if I click on weather or settings in the menu I get an Apache error page saying that the URL can't be found, would you have any ideas on this please ?

Thanks Stuart

— Reply to this email directly or view it on GitHub https://github.com/cerosx/RPI.PIHome2.0-GUI-Frontend/issues/2#issuecomment-156747629.

Mit freundlichen Grüßen / best regards

Sebastian Harke drawDESIGN

Contact: Telephone: (0049) 0241 450 18 63 Mobile: (0049) 01520 365 99 70 Email: info@draw-design.com Internet: page.draw-design.com

acestu commented 8 years ago

Hi Sebasian,

I have done as you say but when I do an ls in the /home/www/ directory the only file that shows is index.php

however if I open the file in nano it is there, tried a reboot but nothing

Something must be wrong because the pihome menu still wont work.

Thanks again Stuart

P.S. I will write a tutorial when I get it going for others to follow.

acestu commented 8 years ago

Sorry I am a pi beginner,

ls -a and it shows the .htaccess file

Is there a directory tree anywhere so I can make sure I have all files and folders where they should be ?

Thanks Stuart

acestu commented 8 years ago

Hi Sebastian,

On the pihome website at Pihome installation the 8th line dow says:

git clone https://github.com/cerosx/RPI.PIHome2.0-GUI-Frontend/

should this be

git clone https://github.com/cerosx/RPI.PIHome2.0-GUI-Frontend/pihome

otherwise the next line tries to copy a non existent directory

Thanks Stuart

acestu commented 8 years ago

pihome_dir

Hi Sebastian, these are the files I have but still if I click on any menu item I get an apache can't find page, any help would be appreciated...

Thanks Stuart

acestu commented 8 years ago

Hi Sebastian,

I have it working now, can you tell me what brand of 433mhz sockets you have used please as mine do not have the dip switches to set the code .

Thanks Stuart

thebestion commented 8 years ago

Hi Stuart,

i have this one http://www.amazon.de/gp/product/B001AX8QUM?keywords=brennenstuhl&qid=1447871689&ref_=sr_1_1&sr=8-1 http://www.amazon.de/gp/product/B001AX8QUM?keywords=brennenstuhl&qid=1447871689&ref_=sr_1_1&sr=8-1

importent is you can set a code. the new remote sockets don’t have this!

where are you from?

cheers Sebastian

On 18 Nov 2015, at 13:23, acestu notifications@github.com wrote:

Hi Sebastian,

I have it working now, can you tell me what brand of 433mhz sockets you have used please as mine do not have the dip switches to set the code .

Thanks Stuart

— Reply to this email directly or view it on GitHub https://github.com/cerosx/RPI.PIHome2.0-GUI-Frontend/issues/2#issuecomment-157810318.

Mit freundlichen Grüßen / best regards

Sebastian Harke drawDESIGN

Contact: Telephone: (0049) 0241 450 18 63 Mobile: (0049) 01520 365 99 70 Email: info@draw-design.com Internet: page.draw-design.com

tklucis commented 8 years ago

Those units without dip switches uses "new" Nexa/Homeasy protocol. Later this evening I will publish on git C++ sources for capturing and sending codes.

Regards Gatis

acestu commented 8 years ago

Hi Sebastian,

I am from United Kingdom and those sockets that you have are no good for me, I have trawled the internet and there are no sockets with the code setting, last night in my workshop I started to record the 433mhz signals from the socket remote that I have, what I intend to do is build a pi board that lets you control the sockets via a pulse to a certain gpio pin or I may build an I2c device to do the same.

thanks Stuart

acestu commented 8 years ago

P.S sorry tklucis, I didn't see your post, the sockets i have are Energenie and they have built a pi board for them here: http://www.maplin.co.uk/p/pi-mote-control-433-mhz-rf-controller-board-for-raspberry-pi-a85rl

Would this be easy to put into your pi-home 2.0 Sebastian ?

Thanks Stuart

tklucis commented 8 years ago

No need for special board. But if you want you can go with it. Am using cheap 433 rx/tx module ... around 7 EUR. As I already told ... later I will share source code.

acestu commented 8 years ago

Hi Tk , Thanks I await your code

Stuart

Sent from my iPhone

On 19 Nov 2015, at 13:44, tklucis notifications@github.com wrote:

No need for special board. But if you want you can go with it. Am using cheap 433 rx/tx module ... around 7 EUR. As I already told ... later I will share source code.

— Reply to this email directly or view it on GitHub.

tklucis commented 8 years ago

Sorry, had to leave urgently for business trip.

tklucis commented 8 years ago

Prerequisites:

  1. You will need 433MHz ASK (amplitude shift key) OOK (on off keying) RX/TX module ... separate or in one unit. I'm using separate TX and RX
  2. WiringPi

Hope You have one. Typical mistake for users using such modules is that You HAVE TO CONNECT ALL +/- pins of module to make it work. They have separate power +/- pins for analog and RF part of module.

Then get tools folder from git. Get WiringPi. It's good idea to make special folder for compiling those tools. Compile WiringPi. In tools folder there are send/receive folders. Each have ./Build file. Also I included binaries compiled for Raspberry B+.

Command line for capturing code: ./scan_433RF 0 where 0 is GPIO pin based on WiringPi pins. 0 = pin 11 on header.

Bring you remote very very very close to receiver (will not explain why). You should get output like Signal detected... sender 8688550 no group on recipient 1

So ... 8688550 is your remote group code ... recepient is 1 ... on means power on. Group code is common for remote. Recepients typically starts from 0 and end with number of outlets purchased with remote.

Send folder. Also ./Build. Command line is ./send_433RF GPIOPIN 8688550 recepient on/off

Sorry for being so erratical. Just arrived home. Let me know if You have problems. Hope to make more detailed manual soon.

acestu commented 8 years ago

Hi TK,

There is no link for the tools....

Thanks Stuart

acestu commented 8 years ago

Hi Tk, There is no link in your mail for downloading the tools.. cheersStuart

Date: Sun, 22 Nov 2015 06:56:23 -0800 From: notifications@github.com To: RPI.PIHome2.0-GUI-Frontend@noreply.github.com CC: acestu@hotmail.com Subject: Re: [RPI.PIHome2.0-GUI-Frontend] Cannot Access Phpmyadmin (#2)

Prerequisites:

You will need 433MHz ASK (amplitude shift key) OOK (on off keying) RX/TX module ... separate or in one unit. I'm using separate TX and RX

WiringPi

Hope You have one. Typical mistake for users using such modules is that You HAVE TO CONNECT ALL +/- pins of module to make it work. They have separate power +/- pins for analog and RF part of module.

Then get tools folder from git. Get WiringPi. It's good idea to make special folder for compiling those tools. Compile WiringPi. In tools folder there are send/receive folders. Each have ./Build file. Also I included binaries compiled for Raspberry B+.

Command line for capturing code: ./scan_433RF 0 where 0 is GPIO pin based on WiringPi pins. 0 = pin 11 on header.

Bring you remote very very very close to receiver (will not explain why). You should get output like

Signal detected...

sender 8688550

no group

on

recipient 1

So ... 8688550 is your remote group code ... recepient is 1 ... on means power on. Group code is common for remote. Recepients typically starts from 0 and end with number of outlets purchased with remote.

Send folder. Also ./Build. Command line is ./send_433RF GPIOPIN 8688550 recepient on/off

Sorry for being so erratical. Just arrived home.

Let me know if You have problems. Hope to make more detailed manual soon.

— Reply to this email directly or view it on GitHub.

    This email has been sent from a virus-free computer protected by Avast. www.avast.com
tklucis commented 8 years ago

C'mon man ... GITHUB

acestu commented 8 years ago

Hi Tk, I have ordered some of these should be here Wednesday hope they are ok theyare ook ask: http://www.ebay.co.uk/itm/181863740559?_trksid=p2057872.m2749.l2649&ssPageName=STRK%3AMEBIDX%3AIT cheersStuart

Date: Sun, 22 Nov 2015 06:56:23 -0800 From: notifications@github.com To: RPI.PIHome2.0-GUI-Frontend@noreply.github.com CC: acestu@hotmail.com Subject: Re: [RPI.PIHome2.0-GUI-Frontend] Cannot Access Phpmyadmin (#2)

Prerequisites:

You will need 433MHz ASK (amplitude shift key) OOK (on off keying) RX/TX module ... separate or in one unit. I'm using separate TX and RX

WiringPi

Hope You have one. Typical mistake for users using such modules is that You HAVE TO CONNECT ALL +/- pins of module to make it work. They have separate power +/- pins for analog and RF part of module.

Then get tools folder from git. Get WiringPi. It's good idea to make special folder for compiling those tools. Compile WiringPi. In tools folder there are send/receive folders. Each have ./Build file. Also I included binaries compiled for Raspberry B+.

Command line for capturing code: ./scan_433RF 0 where 0 is GPIO pin based on WiringPi pins. 0 = pin 11 on header.

Bring you remote very very very close to receiver (will not explain why). You should get output like

Signal detected...

sender 8688550

no group

on

recipient 1

So ... 8688550 is your remote group code ... recepient is 1 ... on means power on. Group code is common for remote. Recepients typically starts from 0 and end with number of outlets purchased with remote.

Send folder. Also ./Build. Command line is ./send_433RF GPIOPIN 8688550 recepient on/off

Sorry for being so erratical. Just arrived home.

Let me know if You have problems. Hope to make more detailed manual soon.

— Reply to this email directly or view it on GitHub.

acestu commented 8 years ago

Hi Tk, I am pretty new to raspberry pi and Github, I thought you had come up with something completely different, from what I can work out, am I right in saying that you have added your files to the Pihome2 server app because it is open source ? ThanksStuart

Date: Sun, 22 Nov 2015 22:50:21 -0800 From: notifications@github.com To: RPI.PIHome2.0-GUI-Frontend@noreply.github.com CC: acestu@hotmail.com Subject: Re: [RPI.PIHome2.0-GUI-Frontend] Cannot Access Phpmyadmin (#2)

C'mon man ... GITHUB

— Reply to this email directly or view it on GitHub.

tklucis commented 8 years ago

Those modules will fit ur needs. Regarding github ... I'm contributor. If you are interested I also connected EQ3 MAX! heating system to my Pi.

acestu commented 8 years ago

Hi Tk, Yes definitely interested in the heating stuff, i was going to put my heating on one of the 433 sockets and try and make a server connected stat with a ds18b20. cheersStuart

Date: Mon, 23 Nov 2015 22:48:07 -0800 From: notifications@github.com To: RPI.PIHome2.0-GUI-Frontend@noreply.github.com CC: acestu@hotmail.com Subject: Re: [RPI.PIHome2.0-GUI-Frontend] Cannot Access Phpmyadmin (#2)

Those modules will fit ur needs. Regarding github ... I'm contributor.

If you are interested I also connected EQ3 MAX! heating system to my Pi.

— Reply to this email directly or view it on GitHub.

thebestion commented 8 years ago

Hey guys. I follow your Mails Great work man. Cheers Sebastian At dec. 9 i am back and I hope we can skype one time.

Von meinem iBett gesendet

On 24 Nov 2015, at 12:53 PM, acestu notifications@github.com wrote:

Hi Tk, Yes definitely interested in the heating stuff, i was going to put my heating on one of the 433 sockets and try and make a server connected stat with a ds18b20. cheersStuart

Date: Mon, 23 Nov 2015 22:48:07 -0800 From: notifications@github.com To: RPI.PIHome2.0-GUI-Frontend@noreply.github.com CC: acestu@hotmail.com Subject: Re: [RPI.PIHome2.0-GUI-Frontend] Cannot Access Phpmyadmin (#2)

Those modules will fit ur needs. Regarding github ... I'm contributor.

If you are interested I also connected EQ3 MAX! heating system to my Pi.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub.

acestu commented 8 years ago

Hi Tk, Don't know what I am doing wrong here I can't cd into

/home/www/tools/Proove-Anslut-Nexa-HomeEasy new protocol

When I am in

/home/www/tools and I ls I can see the folder ?

Am I doing something silly here only I am used to using dos

cheers Stuart

tklucis commented 8 years ago

You have to download that folder from github ... i just added it 2 days ago

acestu commented 8 years ago

I reinstalled everything which included your tools but when i try to cd into it it says no such file or directory Cheers Stuart

Sent from my iPhone

On 25 Nov 2015, at 06:38, tklucis notifications@github.com wrote:

You have to download that folder from github ... i just added it 2 days ago

— Reply to this email directly or view it on GitHub.

tklucis commented 8 years ago

If You installed PiHome in /home/www do: ls -la What does it shows ?

acestu commented 8 years ago

Hi Tk, Here is a screen grab:

cheersStuart Date: Wed, 25 Nov 2015 03:44:17 -0800 From: notifications@github.com To: RPI.PIHome2.0-GUI-Frontend@noreply.github.com CC: acestu@hotmail.com Subject: Re: [RPI.PIHome2.0-GUI-Frontend] Cannot Access Phpmyadmin (#2)

If You installed PiHome in /home/www do: ls -la

What does it shows ?

— Reply to this email directly or view it on GitHub.

tklucis commented 8 years ago

Where =)

acestu commented 8 years ago

omg, sorry about this, i inserted it inline in the email, I will add it as an attachment instead then..... cheersStuart

Date: Wed, 25 Nov 2015 10:16:43 -0800 From: notifications@github.com To: RPI.PIHome2.0-GUI-Frontend@noreply.github.com CC: acestu@hotmail.com Subject: Re: [RPI.PIHome2.0-GUI-Frontend] Cannot Access Phpmyadmin (#2)

Where =)

— Reply to this email directly or view it on GitHub.

tklucis commented 8 years ago

I don't see anything ...

acestu commented 8 years ago

Hi Tk,

Right, if I respond to your mails directly from my email client ie outlook it strips images out, I am now going to add a picture while replying to you from Github:

home_www

Lets see if that worked

cheers Stuart

tklucis commented 8 years ago

cd tools

Dont get where is problem ?!