Cannot Access Phpmyadmin

[acestu]

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]

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 [email protected] 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]

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]

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 [email protected] 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]

OK

I will start over tomorrow

What is the best OS to start with Sebastian ?

Many Thanks
Stuart

[thebestion]

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 [email protected] 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]

Hi,

Sorry

I meant I will Start installing from scratch tomorrow

and should I use

Raspian Jessie or Raspbian Wheezy ?

Thanks again
Stuart

[thebestion]

I think wheezy

Von meinem iBett gesendet

On 13 Nov 2015, at 7:44 PM, acestu [email protected] 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]

Ok
Thank you

[acestu]

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]

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]

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]

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]

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]

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]

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]

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]

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 [email protected] 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 #2 (comment).

Mit freundlichen Grüßen /
best regards

Sebastian Harke
drawDESIGN

Contact:
Telephone: (0049) 0241 450 18 63
Mobile: (0049) 01520 365 99 70
Email: [email protected]
Internet: page.draw-design.com

[acestu]

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]

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 [email protected] 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 #2 (comment).

Mit freundlichen Grüßen /
best regards

Sebastian Harke
drawDESIGN

Contact:
Telephone: (0049) 0241 450 18 63
Mobile: (0049) 01520 365 99 70
Email: [email protected]
Internet: page.draw-design.com

[acestu]

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]

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]

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]

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]

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]

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 [email protected] 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 #2 (comment).

Mit freundlichen Grüßen /
best regards

Sebastian Harke
drawDESIGN

Contact:
Telephone: (0049) 0241 450 18 63
Mobile: (0049) 01520 365 99 70
Email: [email protected]
Internet: page.draw-design.com

[tklucis]

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]

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]

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]

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]

Hi Tk , Thanks I await your code

Stuart

Sent from my iPhone

On 19 Nov 2015, at 13:44, tklucis [email protected] 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]

cd Pr and press TAB for autocomplete then ENTER

[acestu]

I will try it now thanks

[acestu]

Great cheers, so I take it I need to go into the send and receive folders and type ./build to build the application ?

Thanks
Stuart

[tklucis]

yes ... it will build binaries

[acestu]

Thanks Tk, really appreciate the help, I will have a play with this now and follow your previous instructions for learning the codes etc.

cheers
Stuart

[acestu]

Hi Tk,

If I type ./build in the send or receive folder, I get permission denied when operating directly or ssh'in

cheers
Stuart

[tklucis]

chmod +x ./build

[acestu]

Hi,

Done that,

can I use, ./scan_433RF 17 and use the onboard 433 Mhz receiver on gpio17 or do I have to connect another receiver to an unused gpio pin ?

Thanks
Stuart

[tklucis]

yep

[acestu]

Hi Tk,

I have wired one of the ook ask receivers to +5v Gnd and the data pin to pin 37 which is gpio 26

When I run ./scan_433RF 26 it says

Wiring Pi found
GPIO pin configured
Listening ...
0

then I press my remote transmitter button right next to the receiver but nothing happens, I know the remote works because it is switching the socket on,

after about 5 mins I have to press control c to stop

changed receiver data pin to gpio4 and ran ,/scan_433RF 4 but the same

Thanks
Stuart

[acestu]

Hi Tk,

Right I worked out that header pins don't correspond,

So now I get:

It keeps going

But I don't get signal detected

I tried to detect the remote control code with an arduino program off the internet the other night and it seemed to be a different code every time I tried it

Cheers
Stuart

[tklucis]

Take it very very close to receiver module ...
Show me ur remote model name. Will check on net.

[acestu]

Hi Tk,

I was holding the front of the remote right on the coil of the receiver, here is a pic of them:

cheers
Stuart

[tklucis]

Energenie proto

each command consists of 32bits
logic "0" is a 300us pulse followed by a 300us space
logic "1" is a 600us pulse followed by a 600us space
and a 33rd bit is added, equal to the 32nd bit inverted

So you can safely modify my source to fit your protocol.

[acestu]

Hi Tk,

Not sure what is going on here because if I put the no1 - on through my logic analyser I get this:

and it dosent seem to be the same as mr bodgits

cheers
Stuart

[tklucis]

Then you have this protocol.

[acestu]

Hi Tk,

Thanks for the info it is spot on 25 bits, it doesn't look good though because I don't think you can use more than 4 sockets.

cheers
Stuart

[tklucis]

Wrong. Unique ID is for 4 sockets. Change ID and you will get 4 more sockets to control.
Socket itself doesnt cares about ID - thats why they are self learning. You can provide any ID to it. It just memorize it.

[stamb]

Hi all

I redone the install already several times but always run into the same problem.
When I finally go to the rp IP i see this page and not the Pihome page.

Any idea what the problem could be?

thanks,

Steve

[thebestion]

Hi,

Put pihome under /var/www/html/
That's it.

Best regards

On 05 Jan 2016, at 11:29, stamb [email protected] wrote:

Hi all

I redone the install already several times but always run into the same problem.
When I finally go to the rp IP i see this page and not the Pihome page.

Any idea what the problem could be?

thanks,

Steve

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

[stamb]

Hi
Thanks, so i suppose that this should be the code
I changed what i found with waybackmachine since the pihome site (http://pihome.harkemedia.de/) isn't available anymore.

'# [ Install PIHome ]

'# Change directory
cd /var/www/html/

'# Download PIHome from GitHub
git clone https://github.com/cerosx/RPI.PIHome2.0-GUI-Frontend/

'# Copy all files in the web server directory
cp -r /home/pi/RPI.PIHome2.0-GUI-Frontend/pihome/* /var/www/html

'# awarded rights
sudo chown www-data:www-data /var/www/html
sudo chmod 775 /var/www/html
sudo usermod -a -G www-data pi

'# rights for use rcswitch per website
sudo visudo
'# add the following line
www-data ALL=NOPASSWD: /home/div/rcswitch-pi/send
'# CTRL + O -> save
'# CTRL + X -> close

Thanks,

Steve

[acestu]

Hi Steve,

I had to add this path in order to get the home page loaded:

Typed:
nano /etc/apache2/apache2.conf

and add this line, save and reboot

Include /etc/phpmyadmin/apache.conf

cheers
Stuart

[stamb]

Hi Stuart

Thanks for the tip. I already did that so I could open the php admin, so that was OK.
The problem is the Pihome UI.

I'll start another build tonight.

greetings,

Steve

[acestu]

Hi Steve, what problem are you having with it ?

Stuart

[stamb]

Hi

putting pihome under var/www/html gives me the access to the pihome interface.
But when selecting the menu's "room" and "settings" give an error (The requested URL /home/room/1/ was not found on this server) because they still refer to an home folder in the url, any idea where/how i can change that.

thanks,

Steve

[thebestion]

Hi Steve,

you must make a new config

cd /etc/apache2/sites-available

touch 192.168.1.100.conf # your ip

nano 192.168.1.100.conf

copy paste this.
<VirtualHost *:80>

    ServerName 192.168.1.100
    ServerAlias 192.168.1.100
    DocumentRoot /var/www/html/
    <Directory /var/www/html/>
            Options -Indexes +FollowSymLinks -MultiViews
            AllowOverride all
    </Directory>

    CustomLog /var/log/apache2/pihome.de-access.log combined
    ErrorLog /var/log/apache2/pihome.de-error.log

    # Possible values include: debug, info, notice, warn, error, crit,
    # alert, emerg.
    LogLevel warn

a2ensite 192.168.1.100.conf

sudo service apache2 restart

that’s it :)

On 07 Jan 2016, at 21:44, stamb [email protected] wrote:

Hi

putting pihome under var/www/html gives me the access to the pihome interface.
But when selecting the menu's "room" and "settings" give an error (The requested URL /home/room/1/ was not found on this server) because they still refer to an home folder in the url, any idea where/how i can change that.

thanks,

Steve

—
Reply to this email directly or view it on GitHub #2 (comment).

Mit freundlichen Grüßen /
best regards

Sebastian Harke
drawDESIGN

Contact:
Telephone: (0049) 0241 450 18 63
Mobile: (0049) 01520 365 99 70
Email: [email protected]
Internet: page.draw-design.com

[stamb]

Hi Sebastian

The site works now, thanks for the aid, looks really nice.
First I still got some errors on the last code, but I changed the "Options -Indexes +FollowSymLinks -MultiViews" into "Options +Indexes +FollowSymLinks +MultiViews".

Now i'll build the HomyEasy binaries in the /var/www/html/tools/Proo...HomeEasy/send and receive folders with the command "chmod +x ./build" and connect the Chacon DIO hardware.

I'll keep you posted.

Steve

[stamb]

Hi all
when I enter the command ./scan_433RF 2 (pin 13) I get an error message, Permission denied.
Any idea, i'm logged in as root.

this is the wiring:

pin 2 = +
pin 6 = GND
pin 11 = GPIO 0, data transmitter
pin 13 = GPIO 2, data receiver

gr,

Steve

[thebestion]

you must make file executable
chmod +x scan_433RF
try this

On 11 Jan 2016, at 18:14, stamb [email protected] wrote:

Hi all
when I enter the command ./scan_433RF 2 (pin 13) I get an error message, Permission denied.
Any idea, i'm logged in as root.

this is the wiring:

pin 2 = +
pin 6 = GND
pin 11 = GPIO 0, data transmitter
pin 13 = GPIO 2, data receiver

gr,

Steve

—
Reply to this email directly or view it on GitHub #2 (comment).

Mit freundlichen Grüßen /
best regards

Sebastian Harke
drawDESIGN

Contact:
Telephone: (0049) 0241 450 18 63
Mobile: (0049) 01520 365 99 70
Email: [email protected]
Internet: page.draw-design.com

[stamb]

Hi

The program works, but it gives the same result as Stuart's sceenshot, and I thing I don't see any usable codes, even when I hold it very close.

Chacon Dio ref 54760

Any suggestions?

Thanks,

Steve