Pass2PHP

[Trigun]

Hi Guys,

for a while now Pass2php has been running very smoothly unitl yesterday.
my domoticz install crashed due to my SSD reaching its limit becauseof the backup job and the many logfiles.
I was able to delete alle thos files but now my phpmyadmin is not working anymore.

any ideas to restart it?

thanks in advance!

[Egregius]

Backup job? You don't do that on the device itself I would think.
Logfiles can be minimized, you can minimize the number of lg functions you call. Also for the domoticz log there are options. Also consider logrotation to keep the size of logfiles minimal.
Isn't there anything shown for phpMyAdmin, or something in the error log?

[Trigun]

Backup job? You don't do that on the device itself I would think.
Logfiles can be minimized, you can minimize the number of lg functions you call. Also for the domoticz log there are options. Also consider logrotation to keep the size of logfiles minimal.
Isn't there anything shown for phpMyAdmin, or something in the error log?

I found the cause. the backup copy job could not find the network repository.
therefor the proces could not be completed, which causes massive logfiles and a huge swapfile.

thx for the info regarding limiting the logfiles and even the logfile rotate option, am going to look at it.

[ropske]

with what type of OS you installed these Sincze?
I have now a Raspberry Pi3b+ with image: 2019-07-10-raspbian-buster-lite

And when i'm doing the sudo apt-get install xxx what you said, I'm getting these errors:

[Trigun]

with what type of OS you installed these Sincze?
I have now a Raspberry Pi3b+ with image: 2019-07-10-raspbian-buster-lite

And when i'm doing the sudo apt-get install xxx what you said, I'm getting these errors:

Please check if Apache is running. Depending on the command Apache might also be installed and will get in the way of Nginx to work


Sent from my iPhone using Tapatalk

[ropske]

i got this in response, so i guess it is running?
I need to remove it / disable it?

And then start again with the 'installation guide' from Sincze?
THank you

[ropske]

and i'm getting this when i'm enter command: mysql -u root -p

3.jpg (47.68 KiB) Viewed 895 times

i stopped the apache service by doing this command: sudo service apache2 stop

and when i want to go to phpmyadmin page it says forbidden:

3.jpg (47.68 KiB) Viewed 895 times

[Trigun]

Hi Robske,

See the file attached for a how to.
It took me a few times to get it right but I after getting it wrong all the time, I started to make a how to with all the info and help from the guys in this forum.

Hope you'll manage to get it working!

14-8-2019 Pass2php Guide.txt

(7.33 KiB) Downloaded 61 times

[ropske]

thanks mate

i managed to install the database and all

when i want to check the values in devices, i get this error message:

5.jpg (95.23 KiB) Viewed 887 times

when i click: ignore all, i can see my values

6.jpg (110.68 KiB) Viewed 887 times

[Trigun]

thanks mate

i managed to install the database and all

when i want to check the values in devices, i get this error message:
5.jpg

when i click: ignore all, i can see my values
6.jpg

Great, good to hear!
Do you have spaces or other unnormal characters in your devicesnames?

[ropske]

some underscores _
but for the rest i don't have strange characters

btw, i got these errors when i click on every column, even the ones that are standard in phpmyadmin

[Trigun]

some underscores _
but for the rest i don't have strange characters

btw, i got these errors when i click on every column, even the ones that are standard in phpmyadmin

That should not happen. try to do it according to the how to.
it might help.

[ropske]

ok, i will check.

i installed a motion sensor now, and i see its taking some time to switch on my lights

7.jpg (97.57 KiB) Viewed 880 times

in screenshot above its 4seconds, but i happened allready it was +-7seconds

this is what is in my motion.php

motion.jpg (6.66 KiB) Viewed 880 times

[Trigun]

ok, i will check.

i installed a motion sensor now, and i see its taking some time to switch on my lights

7.jpg

in screenshot above its 4seconds, but i happened allready it was +-7seconds

this is what is in my motion.php

motion.jpg

The how to also shows some optimizations so really check it as it will definitely help.


Sent from my iPhone using Tapatalk

[ropske]

btw,
what raspbian is preferred?
stretch lite or buster lite for raspberry pi3b+ ? or does it not matter?

my new ssd is arriving today, before i was running on an usb-stick, that will probably be the cause of my slow reaction speed?

[Trigun]

btw,
what raspbian is preferred?
stretch lite or buster lite for raspberry pi3b+ ? or does it not matter?

my new ssd is arriving today, before i was running on an usb-stick, that will probably be the cause of my slow reaction speed?

I am using Stretch on a 3B+

bare in mind, slow responses can have multiple reasons. I've had it as well and in my case it was due to a zwave connection issue.
I needed to add an extra wired device in order to expand my mesh network.

[ropske]

almost all my zwave devices are wired

[ropske]

when i want to install this:

Install MySQLserver
sudo apt-get install mysql-server

i get this error message:

8.jpg (28.79 KiB) Viewed 852 times

may i do:
sudo apt-get install mariadb-server-10.0

?
is there anything else that changes then?
thanks

[ropske]

btw, im running raspbian buster full on pi3b+

or is it better to run stretch?

[Egregius]

The current Debian version is 10 Buster, so best is to run that one.