[PHP-NodeJS-MySQL] System Info Panel
Hi all,
I'm developing a system information panel in php. I want to share this project with you to know if it's a good idea and if anyone is interested ;) .
It's in a pre-release/developing state so bugs are behind the corner :oops: . The project is on github free and open source for everyone and if someone want to collaborate I'm glad to share this work with someone else :) .
The github project: :arrow: https://github.com/Ar3sDevelopment/rpi-systempanel
If you want to see a demo pm me so I can give you my demo version access.
If you want to install it I'm ready to support everyone because I haven't tested the install.php yet :oops: .
Hope someone is interested :roll: .
(Sorry for the english, I'm Italian :roll: )
I'm developing a system information panel in php. I want to share this project with you to know if it's a good idea and if anyone is interested ;) .
It's in a pre-release/developing state so bugs are behind the corner :oops: . The project is on github free and open source for everyone and if someone want to collaborate I'm glad to share this work with someone else :) .
The github project: :arrow: https://github.com/Ar3sDevelopment/rpi-systempanel
If you want to see a demo pm me so I can give you my demo version access.
If you want to install it I'm ready to support everyone because I haven't tested the install.php yet :oops: .
Hope someone is interested :roll: .
(Sorry for the english, I'm Italian :roll: )
Last edited by Caelan on Mon Jan 27, 2014 9:55 am, edited 2 times in total.
- fightforlife
- Posts: 14
- Joined: Thu May 30, 2013 11:02 am
- DougieLawson
- Posts: 43604
- Joined: Sun Jun 16, 2013 11:19 pm
Re: [PHP] System Info Panel
There's a file missing from your github tree.
Code: Select all
[Thu Nov 28 21:20:44 2013] [error] [client 10.x.x.xx] PHP Warning: require_once(db.conf.inc.php): failed to open stream: No such file or directory in /var/www/rpi/framework/database.inc.php on line 2
[Thu Nov 28 21:20:44 2013] [error] [client 10.x.x.xx] PHP Fatal error: require_once(): Failed opening required 'db.conf.inc.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/rpi/framework/database.inc.php on line 2
[Thu Nov 28 21:20:44 2013] [error] [client 10.x.x.xx] PHP Warning: require_once(db.conf.inc.php): failed to open stream: No such file or directory in /var/www/rpi/framework/database.inc.php on line 2
[Thu Nov 28 21:20:44 2013] [error] [client 10.x.x.xx] PHP Fatal error: require_once(): Failed opening required 'db.conf.inc.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/rpi/framework/database.inc.php on line 2Languages using left-hand whitespace for syntax are ridiculous
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
Re: [PHP] System Info Panel
You're right, it's a simile php file created by install.php. You can get it from the code. Sorry i'll fix that ASAP.
- DougieLawson
- Posts: 43604
- Joined: Sun Jun 16, 2013 11:19 pm
Re: [PHP] System Info Panel
I had a lot of trouble with install.php, MariaDB didn't like the multiple SQL statements in one query, so I ended up breaking that down to eleven queries (so my database may not be complete). My database is running on Ubuntu. MariaDB is the MySQL fork, rather than regular MySQL. I've also disabled InnoDB in favour of Aria (for performance reasons).
Now login.php gets
It could be a problem with Apache, I only installed it on the RPi yesterday and this is the first go at running php5 on it. So I may be getting some problems from not being on my normal Ubuntu server.
I'll have a look at session.save_path (that's probably not been set).
Now login.php gets
Code: Select all
[Thu Nov 28 22:50:34 2013] [error] [client 10.x.x.xx] PHP Fatal error: Call to undefined method mysqli_stmt::get_result() in /var/www/rpi/framework/database.inc.php on line 92
[Thu Nov 28 22:50:34 2013] [error] [client 10.x.x.xx] PHP Warning: Unknown: The session id is too long or contains illegal characters, valid characters are a-z, A-Z, 0-9 and '-,' in Unknown on line 0
[Thu Nov 28 22:50:34 2013] [error] [client 10.x.x.xx] PHP Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php5) in Unknown on line 0
[Thu Nov 28 22:50:41 2013] [error] [client 10.x.x.xx] PHP Fatal error: Call to undefined method mysqli_stmt::get_result() in /var/www/rpi/framework/database.inc.php on line 143, referer: http://10.1.1.7/rpi/systempanel/login.phpI'll have a look at session.save_path (that's probably not been set).
Languages using left-hand whitespace for syntax are ridiculous
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
Re: [PHP] System Info Panel
Sorry for the install issue, it's the first time I have heard MariaDB, in the next releases I'll split all those queries for compatibility. Other issue probably depends for the php5-mysqlnd package I use. IDK if it's supported by MariaDB.
Thanks for your reports, I'll work on it ASAP.
I released 0.1.6 version with some login/logout fix and the sid column of Session table is now nullable.
Thanks for your reports, I'll work on it ASAP.
I released 0.1.6 version with some login/logout fix and the sid column of Session table is now nullable.
Re: [PHP] System Info Panel
Released 0.1.7 version with working installer on MySQL. Queries are now splitted so I think there's no problem with MariaDB.
- DougieLawson
- Posts: 43604
- Joined: Sun Jun 16, 2013 11:19 pm
Re: [PHP] System Info Panel
MariaDB is developed by the guy who wrote MySQL, so it's supposed to be a 100% compatible drop-in replacement. It's a good alternative to Oracle's version.
Languages using left-hand whitespace for syntax are ridiculous
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
Re: [PHP] System Info Panel
i like this ill install this on my pi's
https://www.github.com/random-robbie - Infosec tools
Re: [PHP] System Info Panel
Thanks :)
I've updated the Readme on GitHub and made a new screenshot to show the mobile template
Screenshots:
https://www.dropbox.com/s/ao7ec9ooh08sf ... 1%2050.png
https://www.dropbox.com/s/3o4jo655eijsk ... 281%29.png
I've updated the Readme on GitHub and made a new screenshot to show the mobile template
Screenshots:
https://www.dropbox.com/s/ao7ec9ooh08sf ... 1%2050.png
https://www.dropbox.com/s/3o4jo655eijsk ... 281%29.png
- DougieLawson
- Posts: 43604
- Joined: Sun Jun 16, 2013 11:19 pm
Re: [PHP] System Info Panel
I'll give it another go when I've finished my Wheezy to Jessie update.
Languages using left-hand whitespace for syntax are ridiculous
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
Re: [PHP] System Info Panel
I'm coding some parts in NodeJS instead of PHP. Does MariaDB is supported with same MySQL modules?
- DougieLawson
- Posts: 43604
- Joined: Sun Jun 16, 2013 11:19 pm
Re: [PHP-NodeJS-MySQL] System Info Panel
MariaDB is an exact drop-in fork of MySQL.
The guy who originally developed MySQL didn't like the way Sun/Oracle were pushing MySQL so he forked his own code and re-launched it as MariaDB. I've been running it for months (possibly years).
The guy who originally developed MySQL didn't like the way Sun/Oracle were pushing MySQL so he forked his own code and re-launched it as MariaDB. I've been running it for months (possibly years).
Languages using left-hand whitespace for syntax are ridiculous
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
DMs sent on Bluesky or by LinkedIn will be answered next month.
Fake doctors - are all on my foes list.
The use of crystal balls and mind reading is prohibited.
Return to "Networking and servers"
Jump to
- Community
- General discussion
- Announcements
- Other languages
- Deutsch
- Español
- Français
- Italiano
- Nederlands
- 日本語
- Polski
- Português
- Русский
- Türkçe
- User groups and events
- Raspberry Pi Official Magazine
- Using the Raspberry Pi
- Beginners
- Troubleshooting
- Advanced users
- Assistive technology and accessibility
- Education
- Picademy
- Teaching and learning resources
- Staffroom, classroom and projects
- Astro Pi
- Mathematica
- High Altitude Balloon
- Weather station
- Programming
- C/C++
- Java
- Python
- Scratch
- Other programming languages
- Windows 10 for IoT
- Wolfram Language
- Bare metal, Assembly language
- Graphics programming
- OpenGLES
- OpenVG
- OpenMAX
- General programming discussion
- Projects
- Networking and servers
- Automation, sensing and robotics
- Graphics, sound and multimedia
- Other projects
- Media centres
- Gaming
- AIY Projects
- Hardware and peripherals
- Camera board
- Compute Module
- Official Display
- HATs and other add-ons
- Device Tree
- Interfacing (DSI, CSI, I2C, etc.)
- Keyboard computers (400, 500, 500+)
- Raspberry Pi Pico
- General
- SDK
- MicroPython
- Other RP2040 boards
- Zephyr
- Rust
- AI Accelerator
- AI Camera - IMX500
- Hailo
- Software
- Raspberry Pi OS
- Raspberry Pi Connect
- Raspberry Pi Desktop for PC and Mac
- Beta testing
- Other
- Android
- Debian
- FreeBSD
- Gentoo
- Linux Kernel
- NetBSD
- openSUSE
- Plan 9
- Puppy
- Arch
- Pidora / Fedora
- RISCOS
- Ubuntu
- Ye Olde Pi Shoppe
- For sale
- Wanted
- Off topic
- Off topic discussion