sangseu / raspberrypi-gpio Goto Github PK

What steps will reproduce the problem?
1. Successfully installed the project up to trying to log on to the control 
page (http://ipaddress/control.php)
2. user "admin" and pw "gpio" do not let me in 
3.

What is the expected output? What do you see instead?
Expect the control page but I get 
"http://192.168.0.6/control.php?error=incorrectLogin"

What version of the product are you using? On what operating system?
June 2012 downloads, OS Raspian 2012-10-28 updated

Please provide any additional information below.
Every other stage works fine.

Hope you can help.

Kind regards
Stan Woods (newbe to Linux and RPi)

Hi I want to monitor input pins can I do this?? I just want to see status of a 
reed switch attached to door 

The issue:
My hardware was inverted so the on was the off and the off was the on

My solution
I've updated the database to add another column in pinDirection table called 
pinType with values of inverted or normal.  I then query this in the GPIO 
server.sh

I've attached the files here

I've tested this for GPIO 17 only so may have bugs in this 

What steps will reproduce the problem?
1. i see instruction on Elettronica In n.170 but when i import gpio.sql i have 
problems:
Errore
Query SQL:


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Messaggio di MySQL: Documentazione

#1231 - Variable 'character_set_client' can't be set to the value of 'NULL' 

What is the expected output? What do you see instead?
Impostazione eseguita con successo

What version of the product are you using? On what operating system?
I'm using phpMyAdmin 4.3.3
Apache/2.2.22 (Debian)
Versione del client del database: libmysql - 5.5.40
Estensione PHP: mysqli
Server: Localhost via UNIX socket
Tipo di server: MySQL
Versione del server: 5.5.40-0+wheezy1 - (Debian)
Versione protocollo: 10
Utente: root@localhost
Codifica caratteri del server: UTF-8 Unicode (utf8)


Please provide any additional information below.

please add the following pins to ur sql script

(1, '4', 'out'),
(2, '7', 'out'),
(3, '8', 'out'),
(4, '9', 'out'),
(5, '11', 'out'),
(6, '17', 'out'),
(7, '18', 'out'),
(8, '22', 'out'),
(9, '23', 'out'),
(10, '24', 'out'),
(11, '25', 'out');
(12, '27', 'out'),

What steps will reproduce the problem?
1. trying to login t o control.php as the correct user with the correct password
2.
3.

What is the expected output? What do you see instead?

No idea what to expect but not just being asked to login again.

What version of the product are you using? On what operating system?
? no idea it's control.php which I downloaded today 15/09/2013

Ubuntu 12.04 3.5.0-40-generic #62~precise1-Ubuntu SMP Fri Aug 23 17:38:26 UTC 
2013 x86_64 x86_64 x86_64 GNU/Linux


Please provide any additional information below.
I downloaded the file and edited the username and password fields. O restarted 
mysql and apache and refreshed the web page 

What steps will reproduce the problem?
1. brows trough phpmyadmin


What is the expected output? What do you see instead?
Ports that are turned on will turn off for a short time. But enough time to 
switch a relay.


What version of the product are you using? On what operating system?
Downloaded it today.

Please provide any additional information below.
This problem always exists what I can see on my led's you turn off all ports 
then turn them on again. But when the raspberry is busy, enough time passes to 
switch the relay. Perhaps cache previous state and only change when the state 
changes in mysql. 

Why not use Beanstalk as the PHP -> GPIO interface, just write a PHP shell 
script that runs with the appropriate permissions taking instructions from the 
beanstalk FIFO, no polling required. Have the front end push instructions into 
the beanstalk queue, simple and no MySQL overhead.