Go to advanced search

by Canedje
Mon Apr 13, 2015 3:53 pm
Forum: Troubleshooting
Topic: USB packets loss or corrupted
Replies: 2
Views: 985

USB packets loss or corrupted

I'm using a Raspberry reading information with USB0 from a smart energy meter by the P1 port from the smart meter. I did write code at Python to read the port and store the data at a logfile and MYSQL Database. The P1 is sending every 10 seconds 15 lines of information. With a Crontab job I do read ...
by Canedje
Mon Apr 13, 2015 3:38 pm
Forum: Nederlands
Topic: Mysql database op 2 raspberry's gebruiken
Replies: 10
Views: 1297

Re: Mysql database op 2 raspberry's gebruiken

Okee, dus als ik het goed begrijp: P1 (192.168.2.185) host de MySQL database, host de PHP (apache) en leest de energiemeter P2 (192.168.2.201) leest van de sensoren en schrijft die over naar de MySQL db op P1. Hoezo gaat dit niet goed? De link die je doorgestuurd hebt vindt ik ook heel raar, waarom...
by Canedje
Mon Apr 13, 2015 7:06 am
Forum: Nederlands
Topic: Mysql database op 2 raspberry's gebruiken
Replies: 10
Views: 1297

Re: Mysql database op 2 raspberry's gebruiken

Kun je wat dieper ingaan op wat voor project het is? Zo kunnen we misschien zelfs betere/concrete voorbeelden geven. In ieder geval, MySQL werkt vrij simpel. Een Raspberry Pi stel je gewoon in als je 'master' (i.e. je server) waarop je bv Apache en/of MySQL installeerd, deze Pi is die die je tabel ...
by Canedje
Sun Apr 12, 2015 12:27 pm
Forum: Troubleshooting
Topic: Error I dont know coming from
Replies: 2
Views: 816

Re: Error I dont know coming from

These are two separate messages. /etc/cron.daily/logrotate: [Sun Apr 12 06:25:17 2015] [warn] The Alias directive in /etc/phpmyadmin/apache.conf at line 3 will probably never match because it overlaps an earlier Alias. This message seems to tell you nearly everything you need to know. It's a warnin...
by Canedje
Sun Apr 12, 2015 7:31 am
Forum: Troubleshooting
Topic: Error I dont know coming from
Replies: 2
Views: 816

Error I dont know coming from

Since yesterday I installed an ssmtp server and phpmyadmin on both my raspberry's. This is working fine. I do only receive now suddenly mails containing two errors like: /etc/cron.daily/logrotate: [Sun Apr 12 06:25:17 2015] [warn] The Alias directive in /etc/phpmyadmin/apache.conf at line 3 will pro...
by Canedje
Sat Apr 11, 2015 9:13 pm
Forum: Troubleshooting
Topic: sound not playing at crontab -e
Replies: 6
Views: 988

Re: sound not playing at crontab -e

Canedje wrote:
kusti8 wrote:If your script needs root, did you add it to the root crontab?

Yes I did

You triggered me with the root.

The path off the root was not from the root in the python source.
I changed it. Now it workes.
Thanks for the tip
by Canedje
Sat Apr 11, 2015 9:08 pm
Forum: Troubleshooting
Topic: sound not playing at crontab -e
Replies: 6
Views: 988

Re: sound not playing at crontab -e

kusti8 wrote:If your script needs root, did you add it to the root crontab?

Yes I did
by Canedje
Sat Apr 11, 2015 7:56 pm
Forum: Troubleshooting
Topic: sound not playing at crontab -e
Replies: 6
Views: 988

sound not playing at crontab -e

I did add a sound to a python file to play. pygame.mixer.init() pygame.mixer.music.load("ping.wav") pygame.mixer.music.play() while pygame.mixer.music.get_busy() == True: continue This plays fine if I do run by hand: sudo python tuitlezer.py If I do run this file by crontab -e the sound is...
by Canedje
Thu Apr 09, 2015 1:01 pm
Forum: Nederlands
Topic: Mysql database op 2 raspberry's gebruiken
Replies: 10
Views: 1297

Re: Mysql database op 2 raspberry's gebruiken

Ik zal dit weekend even kijken of ik wat uitgebreider antwoord kan geven. In het kort komt het er op neer: Stel één raspberry als server aan, waarschijnlijk ook de Raspberry die al als "web server" fungeert; Laat de andere Raspberry (de 'client') contact leggen met die server om daar zijn...
by Canedje
Thu Apr 09, 2015 11:32 am
Forum: Python
Topic: dt11 is not detecting on raspberry pi 2
Replies: 7
Views: 1474

Re: dt11 is not detecting on raspberry pi 2

This topic helped me.

There was a config setting needed:
viewtopic.php?f=28&t=106341&p=733288#p733288
by Canedje
Thu Apr 09, 2015 11:20 am
Forum: Nederlands
Topic: Mysql database op 2 raspberry's gebruiken
Replies: 10
Views: 1297

Mysql database op 2 raspberry's gebruiken

Via mijn thuis netwerk heb ik 2 raspberry's actief waarbij ik een van de twee als een soort van server/hoofd systeem gebruik. Op beide systemen heb ik een applicatie via Python lopen waarbij ik data verzamel en opsla in een MYSQL database (lokaal). Nu wil ik op de server beide databases van beide ra...
by Canedje
Thu Apr 09, 2015 11:10 am
Forum: Troubleshooting
Topic: How to use one MYSQL datadir on 2 raspberry's?
Replies: 5
Views: 866

Re: How to use one MYSQL datadir on 2 raspberry's?

DougieLawson wrote:What's your native language? We have forums on here for non-English speakers.
http://www.raspberrypi.org/forums/viewforum.php?f=90
My native language is Dutch.
I do see an subforum over there.
by Canedje
Thu Apr 09, 2015 7:54 am
Forum: Troubleshooting
Topic: How to use one MYSQL datadir on 2 raspberry's?
Replies: 5
Views: 866

Re: How to use one MYSQL datadir on 2 raspberry's?

You can't do that. MySQL does not support filesharing. Make one RPi a server, make the other a client with remote access to the MySQL server. Or make both RPis servers and use table level replication to ensure updates on one system are propagated to the other. https://dev.mysql.com/doc/refman/5.1/e...
by Canedje
Wed Apr 08, 2015 8:04 pm
Forum: Troubleshooting
Topic: How to use one MYSQL datadir on 2 raspberry's?
Replies: 5
Views: 866

How to use one MYSQL datadir on 2 raspberry's?

Hello I like to use one datadir of MYSQL on 2 raspberry's. I did mount 2 directory's on both raspberry's. I tried to put the datadir of MYSQL in one off the mounts by the way mentioned in this link: http://gagsap37.blogspot.nl/2014/11/raspberry-pi-mysql-use-usb-as-data.html After doing this the mysq...
by Canedje
Mon Apr 06, 2015 8:09 pm
Forum: Troubleshooting
Topic: mysql error 1054
Replies: 3
Views: 707

Re: mysql error 1054

After hours and hours trying I do have the solution
I'm able to fill the mysql table
by Canedje
Mon Apr 06, 2015 12:48 pm
Forum: Troubleshooting
Topic: mysql error 1054
Replies: 3
Views: 707

Re: mysql error 1054

Rename your date & time columns. It's a very bad idea to use SQL reserved words for column names. If it doesn't hurt now it could break with ANY future version of the database manager software. Else where you've used a reserved word enclose it in quotes or aposts to avoid the problem. This isn'...
by Canedje
Mon Apr 06, 2015 10:11 am
Forum: Troubleshooting
Topic: mysql error 1054
Replies: 3
Views: 707

mysql error 1054

I'm busy trying to use a MSQL database. I'm able to create a table: CREATE TABLE p1uitlezen (date DATE, time TIME, t1afverm INT(5), t2afverm INT(5), t1terugverm INT(5), t2terugverm INT(5), afverm INT(5), terugverm INT(5)); In Python I do try to fill it in this way: con = mdb.connect('127.0.0.1', 'pi...
by Canedje
Mon Apr 06, 2015 10:06 am
Forum: Troubleshooting
Topic: How to mount 2 raspberry pi's to each other
Replies: 12
Views: 3204

Re: How to mount 2 raspberry pi's to each other

I chnged nothing.
But everything is working fine now???
by Canedje
Sat Apr 04, 2015 7:57 am
Forum: Troubleshooting
Topic: How to mount 2 raspberry pi's to each other
Replies: 12
Views: 3204

Re: How to mount 2 raspberry pi's to each other

I thought it was solved, but I still having some problems. After a separate reboot one of the raspberry's won't mount. As far as I can mention are both configured the same: in exports of raspberry1: ewh@raspberrypi-1 ~ $ cat /etc/exports /home/ewh 192.168.2.201(rw) 192.168.2.186(rw) In exports of ra...
by Canedje
Fri Apr 03, 2015 7:53 pm
Forum: Troubleshooting
Topic: Unable to show .png from other directory then /var/www
Replies: 2
Views: 579

Unable to show .png from other directory then /var/www

I do have two raspberri's connected by a Mount The mount directory is: /mnt/PI I did make a subdirectory : rrdtemp So the total directory will be /mnt/PI/rrdtemp In shell I can read and approach or copy files from the directory mentioned above to a local dir I try to show the pictures from this dire...
by Canedje
Fri Apr 03, 2015 6:42 pm
Forum: Troubleshooting
Topic: How to mount 2 raspberry pi's to each other
Replies: 12
Views: 3204

Re: How to mount 2 raspberry pi's to each other

You need to ensure that your users (/etc/passwd) and groups (/etc/group) are identical on both machines. Or add a new group and a new userid with the same UID=nnnn and GID=nnnn value on both machines. Also ensure that the share is shared as RW and mounted as RW. I do have both enabled as RW the sha...
by Canedje
Fri Apr 03, 2015 2:40 pm
Forum: Troubleshooting
Topic: Not able to read ds18b20 temp sensor
Replies: 5
Views: 1099

Re: Not able to read ds18b20 temp sensor

Thanks again
It all workes fine now!
by Canedje
Fri Apr 03, 2015 2:01 pm
Forum: Troubleshooting
Topic: Not able to read ds18b20 temp sensor
Replies: 5
Views: 1099

Re: Not able to read ds18b20 temp sensor

DougieLawson wrote:Add

Code: Select all

dtoverlay=w1-gpio
to /boot/config.txt and reboot.

Thanks a lot!!!
That was the solution.
I can read the ds18b20 now

I also have the dht22 sensor. Do I need to do something in advance for this sensor?
by Canedje
Fri Apr 03, 2015 1:33 pm
Forum: Troubleshooting
Topic: Not able to read ds18b20 temp sensor
Replies: 5
Views: 1099

Not able to read ds18b20 temp sensor

I do try to read the temp from a ds18b20 sensor. I installed WiringPi by the way: http://wiringpi.com/download-and-install/ I installed the sensor and tried to read it by the: https://iada.nl/blog/artikel/temperatuurmonitoring-met-de-raspberry-pi I checked the connection between the sensor and the p...

Go to advanced search