Do you like it?

Yes
83%
5
No
17%
1
Maybe
No votes
0
It sucks
No votes
0
 
Total votes: 6
Caelan
Posts: 11
Joined: Mon Jul 29, 2013 9:00 am

[PHP-NodeJS-MySQL] System Info Panel

Thu Nov 28, 2013 1:02 pm

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: )
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

Re: [PHP] System Info Panel

Thu Nov 28, 2013 5:43 pm

is there a screenshot somewhere?


User avatar
DougieLawson
Posts: 35381
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website Twitter

Re: [PHP] System Info Panel

Thu Nov 28, 2013 9:24 pm

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 2
Note: Having anything remotely humorous in your signature is completely banned on this forum.

Any DMs sent on Twitter will be answered next month.

This is a doctor free zone.

Caelan
Posts: 11
Joined: Mon Jul 29, 2013 9:00 am

Re: [PHP] System Info Panel

Thu Nov 28, 2013 9:34 pm

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.

User avatar
DougieLawson
Posts: 35381
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website Twitter

Re: [PHP] System Info Panel

Thu Nov 28, 2013 10:59 pm

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

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.php
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).
Note: Having anything remotely humorous in your signature is completely banned on this forum.

Any DMs sent on Twitter will be answered next month.

This is a doctor free zone.

Caelan
Posts: 11
Joined: Mon Jul 29, 2013 9:00 am

Re: [PHP] System Info Panel

Thu Nov 28, 2013 11:23 pm

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.

Caelan
Posts: 11
Joined: Mon Jul 29, 2013 9:00 am

Re: [PHP] System Info Panel

Fri Nov 29, 2013 12:24 am

Released 0.1.7 version with working installer on MySQL. Queries are now splitted so I think there's no problem with MariaDB.

User avatar
DougieLawson
Posts: 35381
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website Twitter

Re: [PHP] System Info Panel

Fri Nov 29, 2013 12:27 am

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.
Note: Having anything remotely humorous in your signature is completely banned on this forum.

Any DMs sent on Twitter will be answered next month.

This is a doctor free zone.

txt3rob
Posts: 365
Joined: Sat Aug 11, 2012 3:45 pm
Contact: Website

Re: [PHP] System Info Panel

Fri Nov 29, 2013 1:35 pm

i like this ill install this on my pi's
The Raspberry Pi Hell Guy - Random Ramblings to assist me and others.
http://raspberrypihell.blogspot.com
My Github - http:/www.github.com/random-robbie/
http://www.smspi.co.uk - send free uk sms via your raspberry pi from here

Caelan
Posts: 11
Joined: Mon Jul 29, 2013 9:00 am

Re: [PHP] System Info Panel

Fri Nov 29, 2013 3:41 pm

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

User avatar
DougieLawson
Posts: 35381
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website Twitter

Re: [PHP] System Info Panel

Fri Nov 29, 2013 9:46 pm

I'll give it another go when I've finished my Wheezy to Jessie update.
Note: Having anything remotely humorous in your signature is completely banned on this forum.

Any DMs sent on Twitter will be answered next month.

This is a doctor free zone.

Caelan
Posts: 11
Joined: Mon Jul 29, 2013 9:00 am

Re: [PHP] System Info Panel

Sun Jan 05, 2014 11:11 pm

I'm coding some parts in NodeJS instead of PHP. Does MariaDB is supported with same MySQL modules?

User avatar
DougieLawson
Posts: 35381
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website Twitter

Re: [PHP-NodeJS-MySQL] System Info Panel

Mon Jan 06, 2014 12:24 am

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).
Note: Having anything remotely humorous in your signature is completely banned on this forum.

Any DMs sent on Twitter will be answered next month.

This is a doctor free zone.

Return to “Networking and servers”