Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[tiffy]

@Chrysalis:

For anyone who might be curious I dont mind sharing my winscp batch script, on how I get the historical stats uploaded to my server, martin, and ned are also using it.  The main live stats are uploaded via native sftp function on dslstats.

Yes please, a copy would be appreciated.
Might inspire some further action regarding my stumbling attempts at getting the historical data function operational on my setup as outlined earlier in this post, plenty of time to "play" now with ongoing restrictions.

[Chrysalis]

No worries, the path it sends from matches the snapshots directory configured in dslstats.  I have save in daily folders ticked. dslstats generates first snapshot at 5 past midnight and every 24 hours after.

This batch script runs daily in task scheduler 10 minutes past midnight.

You will need to edit paths to winscp, paths to your data, as well as login details for server, also depends how your server is configured, mine supports sftp which it uses as its incredibly fast vs normal ftp.

Code: [Select]

@echo off

set datefix=%DATE:~6,4%-%DATE:~3,2%-%DATE:~0,2%

xcopy /E /I /C /F /Y D:\BACKUP\dslstats\Snapshots\%DATEFIX% D:\BACKUP\dslstats\snaptemp\%DATEFIX%

"D:\BACKUP\WinSCP\WinSCP.com" ^
  /log="D:\BACKUP\WinSCP2.log" /ini=D:\BACKUP\WinSCP\WinSCP.ini ^
  /command ^
    "open sftp://<USERNAME>:<PASSWORD>@<HOSTNAME>:<PORT>/ -hostkey=<CERTIFICATE HASH> -rawsettings FollowDirectorySymlinks=1 FtpPingType=0 Ftps=3 MinTlsVersion=12" ^
    "lcd D:\BACKUP\dslstats\snaptemp" ^
    "cd /DSLStatsWeb/Graphs/" ^
    "put -transfer=automatic %DATEFIX%" ^
    "exit"
   
rmdir /S /Q D:\BACKUP\dslstats\snaptemp\%DATEFIX%

set WINSCP_RESULT=%ERRORLEVEL%
if %WINSCP_RESULT% equ 0 (
  echo Success
) else (
  echo Error
)

exit /b %WINSCP_RESULT%

[tiffy]

@Chrysalis:

Many thanks, much appreciated.
Will have a little play and adapt to suit my system.

[hacktrix2006]

Thanks for the V2 interface, now running with rossallan/dslstats docker image.
Not sure how one goes to get history.php working but,the reset is working fine.

Link to my stats is in my Signature which will be on 24/7 from now on.

[tiffy]

A hopefully constructive suggestion regarding your DSLStats displays.
Change the tone range within DSLStats to reflect your VDSL provision, provides a more comprehensive display of Bit Loading, QLN and HLog parameters, attached, a Bit Loading graph recent snapshot on my line for comparison.

I am on 40/10 VDSL provision so you will have to extend the tone range to suit if on 80/20 VDSL service.