Anyone able to install SqStat on 1.2.3?

Cino

I tried to install SqStat on my box and it destroyed it! lol, it added php5 and I think that killed it.. Looks like a nice tool to have to see in realtime what users are doing… I see that their are files on http://diskatel.narod.ru/pfSense/ but not sure how to install it.. Need to image my box before I mess around with SqStat again.. Takes to long to load all the packages..lol

thanks,

Cino

mhab12

I haven't seen this package before but it looks pretty cool, maybe dvserg could get it back to a functional status.

dvserg

New (18 apr 2010). Download, unpack, read readme.txt.
diskatel.narod.ru/files/sqstat.zip

Cino

Thanks dvserg!! I just want to be sure before I install this.. Has it been tested on pf Sense 1.2.3RC? I ask because when I did a manual install of sqstat from FreeBSD packages, it killed my box.

NeophyteHeaven

got this

Warning: fopen(/usr/local/share/sqstat/config.inc.php): failed to open stream: No such file or directory in /etc/inc/pfsense-utils.inc on line 1160 Warning: fwrite(): supplied argument is not a valid stream resource in /etc/inc/pfsense-utils.inc on line 1161 Warning: fclose(): supplied argument is not a valid stream resource in /etc/inc/pfsense-utils.inc on line 1162 Warning: fopen(/usr/local/share/sqstat/index.php): failed to open stream: No such file or directory in /etc/inc/pfsense-utils.inc on line 1160 Warning: fwrite(): supplied argument is not a valid stream resource in /etc/inc/pfsense-utils.inc on line 1161 Warning: fclose(): supplied argument is not a valid stream resource in /etc/inc/pfsense-utils.inc on line 1162 Warning: Cannot modify header information - headers already sent by (output started at /etc/inc/pfsense-utils.inc:1160) in /usr/local/www/pkg_edit.php on line 35

dvserg

??? Sorry. Will test on clean system.

Cino

dvserg,

Thank you!! I'll wait before trying to install the files… This is off topic but I see on your site, you have a couple of packages.. Have they been updated to with pfSense 1.2.3RC? Would like to try the 3proxy over the current squid package.. I'm asking because none of these packages are in the built-in package manager..Well other then HAVP...

Thanks again!!

dvserg

Replace source. Test this archive pls - now manual installation without any broken depences.
http://forum.pfsense.org/index.php/topic,24362.msg126188.html#msg126188

Now simple type in cmd

> pkg_add -r http://diskatel.narod.ru/files/sqstat-1.20_2.tbz

Disabled damage depences and added pfsense GUI elements.
After open via browser http://pfsense_ip/pkg_edit.php?xml=sqstat.xml&id=0

May be warning messages with pkg deinstallatin. But nothing damage - only not clean deinstallation.

Cino

That was a quick fix!! I was able to install but received this error message

# pkg_add -r http://diskatel.narod.ru/files/sqstat-1.20_2.tbz
Fetching http://diskatel.narod.ru/files/sqstat-1.20_2.tbz… Done.
pkg_add: cannot open /var/db/pkg/sqstat-1.20_2/+DISPLAY as display file

But it does seem to be working tho :-) Just need to add it to my config.xml so I dont have to manually enter the url…. Just need to fully test it now... Picks up watching videos and streaming music and some page downloads.. THanks again!!

Now could this become an official package?

dvserg

@Cino:

That was a quick fix!! I was able to install but received this error message

# pkg_add -r http://diskatel.narod.ru/files/sqstat-1.20_2.tbz
Fetching http://diskatel.narod.ru/files/sqstat-1.20_2.tbz… Done.
pkg_add: cannot open /var/db/pkg/sqstat-1.20_2/+DISPLAY as display file

But it does seem to be working tho :-) Just need to add it to my config.xml so I dont have to manually enter the url…. Just need to fully test it now... Picks up watching videos and streaming music and some page downloads.. THanks again!!

Now could this become an official package?

You are seeing this and other warnings, as I did everything fast and not watching the details.
I do not consider the installation of this package in the official list.

Cino

@dvserg:

You are seeing this and other warnings, as I did everything fast and not watching the details.

I do not consider the installation of this package in the official list.

Thanks again!! One last question, well 2 questions. Are you still working on your 3proxy project? Also how would I add a menu item under Status? I thought if I added an entry between menu /menu that it would work.. It didn't.

NeophyteHeaven

@Cino:

That was a quick fix!! I was able to install but received this error message

# pkg_add -r http://diskatel.narod.ru/files/sqstat-1.20_2.tbz
Fetching http://diskatel.narod.ru/files/sqstat-1.20_2.tbz… Done.
pkg_add: cannot open /var/db/pkg/sqstat-1.20_2/+DISPLAY as display file

But it does seem to be working tho :-) Just need to add it to my config.xml so I dont have to manually enter the url…. Just need to fully test it now... Picks up watching videos and streaming music and some page downloads.. THanks again!!

Now could this become an official package?

it need to be run on webgui..not terminal..

thanks dvserg for the fast package..

mikesamo

it should be in official package :)