Spot-net.nl Forums

Support Request Template

Welk spotX programma gebruik je?: SpotWeb
Wat is de versie van het spotX programma?: SpotWeb v0.58.25.29
Wat is je besturingssysteem?: Linux
Wat is de versie van het besturingssysteem?: 32bits
Welke Usenet Provider heb je?: Giganews
Welke Internet Provider heb je?: ViewQwest (Singapore)
Welk Anti-Virus/Firewall programma gebruik je?: None
Met welk programma download je?: Sabnzbd
Wanneer begon je probleem?: Tijdens het ophalen van headers
Geef een beschrijving van je probleem: Eerste installatie, nog steeds bezig met het binnenhalen van de headers, spotweb crashed. Headers binnen halen stocked op 19-01-2012, begonnen bij Nov 2010.

Gebruik hiervoor de terminal window in Winscp (root access naar de NAS) versie 5.20. NAS is een Synology 1812+ met 3 Gb geheugen en 32Tb HDD.
XML bestand.: Geen antwoord gegeven

Generated by Support Toolkit SRT Generator.

Addional info vanuit de terminal window:

/volume1/web/spotweb$ php retrieve.php
Last retrieve at Thu 01 Jan 1970 07:30:00 AM SGT
Retrieving new Spots from server news.giganews.com...
Looking for articlenumber for messageid

Spoiler: show

Searching from 3333146 to 3338147
Searching from 3328146 to 3333147
Searching from 3323146 to 3328147
Searching from 3318146 to 3323147
Searching from 3313146 to 3318147
Searching from 3308146 to 3313147
Searching from 3303146 to 3308147
Searching from 3298146 to 3303147
Searching from 3293146 to 3298147
Searching from 3288146 to 3293147
Searching from 3283146 to 3288147
Searching from 3278146 to 3283147
Searching from 3273146 to 3278147
Searching from 3268146 to 3273147
Searching from 3263146 to 3268147
Searching from 3258146 to 3263147
Searching from 3253146 to 3258147
Searching from 3248146 to 3253147
Searching from 3243146 to 3248147
Searching from 3238146 to 3243147
Searching from 3233146 to 3238147
Searching from 3228146 to 3233147
Searching from 3223146 to 3228147
Searching from 3218146 to 3223147
Searching from 3213146 to 3218147
Searching from 3208146 to 3213147
Searching from 3203146 to 3208147
Searching from 3198146 to 3203147
Searching from 3193146 to 3198147
Searching from 3188146 to 3193147
Searching from 3183146 to 3188147
Searching from 3178146 to 3183147
Searching from 3173146 to 3178147
Searching from 3168146 to 3173147
Searching from 3163146 to 3168147
Searching from 3158146 to 3163147
Searching from 3153146 to 3158147
Searching from 3148146 to 3153147
Searching from 3143146 to 3148147
Searching from 3138146 to 3143147
Searching from 3133146 to 3138147
Searching from 3128146 to 3133147
Searching from 3123146 to 3128147
Searching from 3118146 to 3123147
Searching from 3113146 to 3118147
Searching from 3108146 to 3113147
Searching from 3103146 to 3108147
Searching from 3098146 to 3103147
Searching from 3093146 to 3098147
Searching from 3088146 to 3093147
Searching from 3083146 to 3088147
Searching from 3078146 to 3083147
Searching from 3073146 to 3078147
Searching from 3068146 to 3073147
Searching from 3063146 to 3068147
Searching from 3058146 to 3063147
Searching from 3053146 to 3058147
Searching from 3048146 to 3053147
Searching from 3043146 to 3048147
Searching from 3038146 to 3043147
Searching from 3033146 to 3038147
Searching from 3028146 to 3033147
Searching from 3023146 to 3028147
Searching from 3018146 to 3023147
Searching from 3013146 to 3018147
Searching from 3008146 to 3013147
Searching from 3003146 to 3008147
Searching from 2998146 to 3003147
Searching from 2993146 to 2998147
Searching from 2988146 to 2993147
Searching from 2983146 to 2988147
Searching from 2978146 to 2983147
Searching from 2973146 to 2978147
Searching from 2968146 to 2973147
Searching from 2963146 to 2968147
Searching from 2958146 to 2963147
Searching from 2953146 to 2958147
Searching from 2948146 to 2953147
Searching from 2943146 to 2948147
Searching from 2938146 to 2943147
Searching from 2933146 to 2938147
Searching from 2928146 to 2933147
Searching from 2923146 to 2928147
Searching from 2918146 to 2923147
Searching from 2913146 to 2918147
Searching from 2908146 to 2913147
Searching from 2903146 to 2908147
Searching from 2898146 to 2903147
Searching from 2893146 to 2898147
Searching from 2888146 to 2893147
Searching from 2883146 to 2888147
Searching from 2878146 to 2883147
Searching from 2873146 to 2878147
Searching from 2868146 to 2873147
Searching from 2863146 to 2868147
Searching from 2858146 to 2863147
Searching from 2853146 to 2858147
Searching from 2848146 to 2853147
Searching from 2843146 to 2848147
Searching from 2838146 to 2843147
Searching from 2833146 to 2838147
Searching from 2828146 to 2833147
Searching from 2823146 to 2828147
Searching from 2818146 to 2823147
Searching from 2813146 to 2818147
Searching from 2808146 to 2813147
Searching from 2803146 to 2808147

Appr. Message count: 3335029
First message number: 3118
Last message number: 3338147
Current message: 2806999

Retrieving 2806999 till 2807250

SpotWeb v0.58.25.29 on PHP v5.3.21 crashed

Fatal error occured while connecting to the newsserver:
(0) Unexpected response [response: "Posting-Date: Thu, 19 Jan 2012 18:06:04 +0100"]


#0 /volume1/web/spotweb/NNTP/Protocol/Client.php(620): Net_NNTP_Protocol_Client->throwError('Unexpected resp...', 0, 'Posting-Date: T...')
#1 /volume1/web/spotweb/NNTP/Protocol/Client.php(1200): Net_NNTP_Protocol_Client->_handleUnexpectedResponse(0)
#2 /volume1/web/spotweb/NNTP/Client.php(571): Net_NNTP_Protocol_Client->cmdBody('<mO80gprCQFkek0...')
#3 /volume1/web/spotweb/lib/SpotNntp.php(121): Net_NNTP_Client->getBody('<mO80gprCQFkek0...')
#4 /volume1/web/spotweb/lib/SpotNntp.php(296): SpotNntp->getBody('<mO80gprCQFkek0...')
#5 /volume1/web/spotweb/lib/SpotsOverview.php(333): SpotNntp->getImage(Array)
#6 /volume1/web/spotweb/lib/retriever/SpotRetriever_Spots.php(358): SpotsOverview->getImage(Array, Object(SpotNntp))
#7 /volume1/web/spotweb/lib/retriever/SpotRetriever_Abs.php(169): SpotRetriever_Spots->process(Array, 2806999, 2807250, 1374573097.0568)
#8 /volume1/web/spotweb/lib/retriever/SpotRetriever_Abs.php(230): SpotRetriever_Abs->loopTillEnd(2806999, '250')
#9 /volume1/web/spotweb/retrieve.php(160): SpotRetriever_Abs->perform()
#10 {main}

Updating retrieve status in the database

Finished retrieving spots.

Gevolg is zoals boven aangegeven dat er geen headers meer opgehaald worden na 19-01-2012.

Start retrieve elke keer weer bij het begin?

Eerst even de memory limit verhogen naar 256 of 512 MB.
Zoek in php.ini naar: memory_limit = 128M en verander dit naar memory_limit = 256M
Daarna apache herstarten.

>> Done, same result >> SpotWeb v0.58.25.29 on PHP v5.3.21 crashed

voor de zekerheid even: upgrade-db.php draaien.
Zelfde werkwize als retrieve.php maar nu typ je upgrade-db.php

/volume1/web/spotweb$ php upgrade-db.php
Updating schema..(mysql)

Spoiler: show

Validating spots(messageid)
Validating spots(poster)
Validating spots(title)
Validating spots(tag)
Validating spots(category)
Validating spots(subcata)
Validating spots(subcatb)
Validating spots(subcatc)
Validating spots(subcatd)
Validating spots(subcatz)
Validating spots(stamp)
Validating spots(reversestamp)
Validating spots(filesize)
Validating spots(moderated)
Validating spots(commentcount)
Validating spots(spotrating)
Validating spots(reportcount)
Validating spots(spotterid)
Validating spotsfull(messageid)
Validating spotsfull(verified)
Validating spotsfull(usersignature)
Validating spotsfull(userkey)
Validating spotsfull(xmlsignature)
Validating spotsfull(fullxml)
Validating nntp(server)
Validating nntp(maxarticleid)
Validating nntp(nowrunning)
Validating nntp(lastrun)
Validating nntp(serverdatelastrun)
Validating commentsxover(messageid)
Validating commentsxover(nntpref)
Validating commentsxover(spotrating)
Validating commentsxover(moderated)
Validating commentsxover(stamp)
Validating reportsxover(messageid)
Validating reportsxover(fromhdr)
Validating reportsxover(keyword)
Validating reportsxover(nntpref)
Validating spotstatelist(messageid)
Validating spotstatelist(ouruserid)
Validating spotstatelist(download)
Validating spotstatelist(watch)
Validating spotstatelist(seen)
Validating commentsfull(messageid)
Validating commentsfull(fromhdr)
Validating commentsfull(stamp)
Validating commentsfull(usersignature)
Validating commentsfull(userkey)
Validating commentsfull(spotterid)
Validating commentsfull(hashcash)
Validating commentsfull(body)
Validating commentsfull(verified)
Validating commentsfull(avatar)
Validating settings(name)
Validating settings(value)
Validating settings(serialized)
Validating commentsposted(ouruserid)
Validating commentsposted(messageid)
Validating commentsposted(inreplyto)
Validating commentsposted(randompart)
Validating commentsposted(rating)
Validating commentsposted(body)
Validating commentsposted(stamp)
Validating spotsposted(messageid)
Validating spotsposted(ouruserid)
Validating spotsposted(stamp)
Validating spotsposted(title)
Validating spotsposted(tag)
Validating spotsposted(category)
Validating spotsposted(subcats)
Validating spotsposted(filesize)
Validating spotsposted(fullxml)
Validating reportsposted(ouruserid)
Validating reportsposted(messageid)
Validating reportsposted(inreplyto)
Validating reportsposted(randompart)
Validating reportsposted(body)
Validating reportsposted(stamp)
Validating usersettings(userid)
Validating usersettings(privatekey)
Validating usersettings(publickey)
Validating usersettings(avatar)
Validating usersettings(otherprefs)
Validating users(username)
Validating users(firstname)
Validating users(passhash)
Validating users(lastname)
Validating users(mail)
Validating users(apikey)
Validating users(lastlogin)
Validating users(lastvisit)
Validating users(lastread)
Validating users(lastapiusage)
Validating users(deleted)
Validating sessions(sessionid)
Validating sessions(userid)
Validating sessions(hitcount)
Validating sessions(lasthit)
Validating sessions(ipaddr)
Validating sessions(devicetype)
Validating securitygroups(name)
Validating grouppermissions(groupid)
Validating grouppermissions(permissionid)
Validating grouppermissions(objectid)
Validating grouppermissions(deny)
Validating usergroups(userid)
Validating usergroups(groupid)
Validating usergroups(prio)
Validating notifications(userid)
Validating notifications(stamp)
Validating notifications(objectid)
Validating notifications(type)
Validating notifications(title)
Validating notifications(body)
Validating notifications(sent)
Validating filters(userid)
Validating filters(filtertype)
Validating filters(title)
Validating filters(icon)
Validating filters(torder)
Validating filters(tparent)
Validating filters(tree)
Validating filters(valuelist)
Validating filters(sorton)
Validating filters(sortorder)
Validating filters(enablenotify)
Validating filtercounts(userid)
Validating filtercounts(filterhash)
Validating filtercounts(currentspotcount)
Validating filtercounts(lastvisitspotcount)
Validating filtercounts(lastupdate)
Validating spotteridblacklist(spotterid)
Validating spotteridblacklist(ouruserid)
Validating spotteridblacklist(idtype)
Validating spotteridblacklist(origin)
Validating spotteridblacklist(doubled)
Validating cache(resourceid)
Validating cache(cachetype)
Validating cache(stamp)
Validating cache(metadata)
Validating cache(serialized)
Validating cache(content)
Validating permaudit(stamp)
Validating permaudit(userid)
Validating permaudit(permissionid)
Validating permaudit(objectid)
Validating permaudit(result)
Validating permaudit(ipaddr)
Validating index idx_spots_1
Validating index idx_spots_2
Validating index idx_spots_3
Validating index idx_spots_4
Validating index idx_spots_5
Validating FTS idx_fts_spots
Validating index idx_nntp_1
Validating index idx_spotsfull_1
Validating index idx_commentsfull_1
Validating index idx_commentsxover_1
Validating index idx_commentsxover_2
Validating index idx_reportsxover_1
Validating index idx_reportsxover_2
Validating index idx_reportsposted_1
Validating index idx_reportsposted_2
Validating index idx_reportspostedrel_1
Validating index idx_commentsposted_1
Validating index idx_commentspostedrel_1
Validating index idx_spotsposted_1
Validating index idx_spotspostedrel_1
Validating index idx_settings_1
Validating index idx_usersettings_1
Validating index idx_users_1
Validating index idx_users_2
Validating index idx_users_3
Validating index idx_users_4
Validating index idx_sessions_1
Validating index idx_sessions_2
Validating index idx_sessions_3
Validating index idx_sessionsrel_1
Validating index idx_spotstatelist_1
Validating index idx_spotstatelistrel_1
Validating index idx_securitygroups_1
Validating index idx_grouppermissions_1
Validating index idx_usergroups_1
Validating index idx_usergroupsrel_1
Validating index idx_notifications_1
Validating index idx_notifications_2
Validating index idx_filters_1
Validating index idx_filtercounts_1
Validating index idx_spotteridblacklist_1
Validating index idx_spotteridblacklist_2
Validating index idx_cache_1
Validating index idx_cache_2

Schema update done
Updating settings
Settings update done
Updating users
Users' update done
Performing basic analysis of database tables
Basic database optimalisation done


Daarna: "mysqlcheck -u {user} -p{passwd} --auto-repair --check --optimize spotweb"
Doe je ook via de terminal

>> Done, same result: SpotWeb v0.58.25.29 on PHP v5.3.21 crashed

Als er nog steeds problemen zijn kan je retrieve.php --retro proberen.
Idem als hierboven, maar dan met de switch --retro

>> Done, same result: SpotWeb v0.58.25.29 on PHP v5.3.21 crashed

-- [bericht automatisch samengevoegd - 24 Jul 2013, 07:57] --

Blauwbek schreef:Start retrieve elke keer weer bij het begin?

Volgens mij wel...ook de retro optie begon bij het begin...

Crasht SW telkens op hetzelfde punt?

Fatal error occured while connecting to the newsserver:
(0) Unexpected response [response: "Posting-Date: Thu, 19 Jan 2012 18:06:04 +0100"]

Zo, ja ga dan ens naar /spotweb/?page=editsettings en start het headeren vanaf 20 jan 2012. Wat gebeurd er dan?
(je mist dan 1 dag, de spots daarvoor staan reeds in de dB)

Dear Wheaten,

To be honest got so sick of not being able to view spots, I de-installed the whole thing and next blew steam for a week.
Still interested though in getting it working (first install was straight from NAS as package offered), I followed the install sequence described here: http://synology.brickman.nl/syn_howto/H ... potweb.txt

Which works 100% even with every regular auto updates...
Me happy...but the NAS pkg install (saw 2 icons just now) needs a fresh look at...