Er mogen op dit forum GEEN verzoekjes of requests gevraagd worden, dit staat ook in de regels die je accepteert bij het registreren op dit forum, hiervoor krijg je direct een permanente ban.

Install.php niet bereikbaar na installatie, wel spotweb

Gebruikers helpen andere gebruikers. Als je hulp nodig of een probleem hebt , post het dan hier.

Moderator: Moderator Team

Forumregels
LEES: Forum Regels!

Topicstarter
suheyl
Berichten: 5
Lid geworden op: 05 aug 2014, 14:41
Reputation: 0

Install.php niet bereikbaar na installatie, wel spotweb

#1

Bericht door suheyl »

Support Request Template

Welk spotX programma gebruik je?: SpotWeb
Wat is de versie van het spotX programma?: Verse installatie
Wat is je besturingssysteem?: Linux
Wat is de versie van het besturingssysteem?: 64bits
Welke Usenet Provider heb je?: nvt
Welke Internet Provider heb je?: nvt
Welk Anti-Virus/Firewall programma gebruik je?: nvt
Met welk programma download je?: nvt
Wanneer begon je probleem?: Tijdens en na de installatie
Geef een beschrijving van je probleem: Ik heb vandaag een "schone" installatie gedaan van mijn OS, Ubuntu 18.04 en alle updates gedraaid. Vervolgens Sabnzbd en SickBeard geïnstalleerd en succesvol getest. Vervolgens heb ik Spotweb geïnstalleerd. Tijdens de installatie kreeg ik aan foutmelding over een index die niet aangemaakt kon worden. Dit bleek een bekend probleem te zijn en opgelost te kunnen worden door bij een alter statement het woord IGNORE uit het script te halen. Vervolgens liep de installatie succesvol door en kan ik bij de webinterface van spotweb. Ik dacht dus een succesvolle installatie gedaan te hebben.
Echter, ik heb nooit de install.php pagina gezien en daardoor lijkt mijn installatie ook niet voltooid. Ik kan ook niet naar die installatiepagina http://x.x.x./spotweb/install.php toe. Ik krijg dan een 404 page not found error. Ik heb ben naar het pad /var/www/spotweb gegaan, maar daar staat wel degelijk install.php. In de webinterface kan ik wel een user toevoegen en die configureren, maar dit is geen admin user en kan dus ook usenetserver niet toevoegen en gebruikersgroepen aanmaken.
Ik heb op command line install.php gedraaid. Die geeft wel resultaat.
Vreemde is, hij geeft aan dat mijn tijdzone niet goed staat in php.ini maar die staat wel degelijk op Europe/Amsterdam.
Ook heb ik gezocht of er ergens anders ook een php.ini bestaat, maar dat is niet het geval.
XML bestand.: Geen antwoord gegeven

Generated by Support Toolkit SRT Generator.
Laatst gewijzigd door suheyl op 01 apr 2020, 18:02, 1 keer totaal gewijzigd.

Neem je online privacy serieus en gebruik een VPN verbinding!

Met een VPN verbinding van IPVanish wordt uw gehele internet verbinding versleuteld

U kunt dus veilig browsen, Torrents downloaden, Usenet downloaden en onderling versleutelde verbindingen opzetten.



UsenetDude
Berichten: 72
Lid geworden op: 27 dec 2011, 13:54
Reputation: 0
Usenet: XSnews
Internet: Kwello
Locatie: Usenet
Contacteer:

Re: Install.php niet bereikbaar na installatie, wel spotweb

#2

Bericht door UsenetDude »

Het lijkt er op dat er iets niet goed gegaan is tijdens de installatie.

De install.php maakt de Admin user aan.

Wat krijgt je als je onderstaande doet?

timedatectl status | grep "Time zone"
Je kan een gratis nieuwsserver proberen maar die is lang niet zo goed als een betaalde nieuwsserver! Kan je iets niet vinden gebruik binsearch


Topicstarter
suheyl
Berichten: 5
Lid geworden op: 05 aug 2014, 14:41
Reputation: 0

Re: Install.php niet bereikbaar na installatie, wel spotweb

#3

Bericht door suheyl »

Hi,

Dit lijkt dus ook goed te staan:
timedatectl status | grep "Time zone"
Time zone: Europe/Amsterdam (CEST, +0200)

Output van install.php op CLI

timedatectl status | grep "Time zone"
Time zone: Europe/Amsterdam (CEST, +0200)
suheyl@KODI:~$ ^C
suheyl@KODI:~$ php /var/www/spotweb/install.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.or g/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Test your Installation</title>
<style type='text/css'>
* { font-family: Arial, Helvetica, sans-serif; }
table {margin-left:auto; margin-right:auto; font-size:12px; colo r:#fff; width:800px; background-color:#666; border:0; border-collapse:collapse; border-spacing:0;}
table td {background-color:#CCC; color:#000; padding:4px; border :1px #fff solid;}
table th {background-color:#666; color:#fff; padding:4px; text-a lign:left; border-bottom:2px #fff solid; font-size:12px; font-weight:bold;}
div#error {background-color:#e33b1a; border:1px solid #ab1c00; c olor:#fff; line-height:18px; padding:0; text-align:center; vertical-align:top; margin:12px 15px 13px 5px; -moz-border-radius:4px; -webkit-border-radius:4px; bo rder-radius:4px; font-weight:bold;}
div#success {background-color:#cbffcb; border:1px solid #00ab00; color:#000; line-height:18px; padding:0; text-align:center; vertical-align:top ; margin:12px 15px 13px 5px; -moz-border-radius:4px; -webkit-border-radius:4px; border-radius:4px; font-weight:bold;}

.button { padding: 4px; padding-left: 10px; padding-right: 10px; margin: 0; border: 1px solid black; background-color: #fff; color: #666; text-decoratio n: none; }
table.tableresult tr { height: 34px; }
</style>
</head>
<body>

<table summary="PHP settings">
<tr>
<th>PHP settings</th>
<th>Value</th>
<th>Result</th>
</tr>
<tr>
<td>PHP version</td>
<td>7.2.24-0ubuntu0.18.04.3</td>
<td>OK</td>
</tr>
<tr>
<td>timezone settings</td>
<td></td>
<td>NOT OK (Please specify date.timezone in your PHP.ini)</td>
</tr>
<tr>
<td> Open base dir</td>
<td></td>
<td>OK</td>
</tr>
<tr>
<td> Allow furl open</td>
<td>1</td>
<td>OK</td>
</tr>
<tr>
<td> PHP safe mode</td>
<td></td>
<td>OK</td>
</tr>
<tr>
<td> Memory limit</td>
<td>-1</td>
<td>NOT OK (memory_limit below 128M)</td>
</tr>
</table>
<br/>

<table summary="PHP extensions">
<tr>
<th colspan="2"> PHP extension</th>
<th> Result</th>
</tr>
<tr>
<td colspan="2"> curl</td>
<!--<td>OK</td>-->
<td>OK</td>
</tr>
<tr>
<td colspan="2"> DOM</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> gettext</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> mbstring</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> json</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> xml</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> zip</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> zlib</td>
<td>OK</td>
</tr>

<tr>
<th colspan="2"> Database support</th>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> MySQL (PDO)</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> PostgreSQL (PDO)</td>
<td>NOT OK</td>
</tr>
<tr>
<td colspan="2"> SQLite (PDO)</td>
<td>NOT OK</td>
</tr>
<tr>
<th colspan="2"> GD</th>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> FreeType Support</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> GIF Read Support</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> GIF Create Support</td>
<td>OK</td>
</tr>
<tr>
<td colspan="2"> JPEG Support</td>
<td>OK</td>
</tr><!-- Previous to PHP 5.3.0, the JPEG Support attribute was named JPG Su pport. -->
<tr>
<td colspan="2"> PNG Support</td>
<td>OK</td>
</tr>
<tr>
<th colspan="3"> OpenSSL</th>
</tr>
<tr>
<td rowspan="3"> At least 1 of these must be OK <br/>these modules are s orted from fastest to slowest</td>
<td> openssl</td>
<td>OK</td>
</tr>
<tr>
<td> gmp</td>
<td>OK</td>
</tr>
<tr>
<td> bcmath</td>
<td>NOT OK</td>
</tr>
<tr>
<td colspan="2"> Can create private key?</td>
<td>OK</td>
</tr>
<tr>
<th colspan="3"> Cache directory</th>
</tr>
<tr>
<td colspan="2"> Cache directory is writable?</td>
<td>NOT OK</td>
</tr>
</table>
<br/>

<table summary="Include files">
<tr>
<th> Include files</th>
<th> Result</th>
</tr>
<tr>
<td> Settings file</td>
<td>OK (/var/www/spotweb)</td>
</tr>
<tr>
<td> Own settings file</td>
<td>NOT OK (optional)</td>
</tr>
</table>
<br/>

<table summary="result" class="tableresult">
<tr>
<th colspan="2"> Please continue to setup Spotweb</th>
<th><a href="?page=2" class="button">Next</a></th>
</tr>
</table>
<br/>
suheyl@KODI:~$

Ik snap dus niet waar deze install.php naar kijkt en waarom ik dit niet kan oproepen in de browser


Topicstarter
suheyl
Berichten: 5
Lid geworden op: 05 aug 2014, 14:41
Reputation: 0

Re: Install.php niet bereikbaar na installatie, wel spotweb

#4

Bericht door suheyl »

Hi,

Ik heb zojuist de vorige installatie en opnieuw geïnstalleerd. Wederom lijkt het goed te gaan, echter, weer geen install.php

suheyl@KODI:~$ sudo apt install spotweb [sudo] password for suheyl:
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
php-seclib
Suggested packages:
php-mcrypt php-compat nzbget
The following NEW packages will be installed:
php-seclib spotweb
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/829 kB of archives.
After this operation, 4663 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Selecting previously unselected package php-seclib.
(Reading database ... 198883 files and directories currently installed.)
Preparing to unpack .../php-seclib_1.0.9-1_all.deb ...
Unpacking php-seclib (1.0.9-1) ...
Selecting previously unselected package spotweb.
Preparing to unpack .../spotweb_20130826+dfsg3-4_all.deb ...
Unpacking spotweb (20130826+dfsg3-4) ...
Setting up php-seclib (1.0.9-1) ...
Setting up spotweb (20130826+dfsg3-4) ...
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/spotweb.conf

Creating config file /etc/dbconfig-common/spotweb.conf with new version

Creating config file /etc/spotweb/dbconfig.php with new version
checking privileges on database spotweb for spotweb@localhost: user creation needed.
granting access to database spotweb for spotweb@localhost: success.
verifying access for spotweb@localhost: success.
creating database spotweb: success.
verifying database spotweb exists: success.
populating database via scriptfile... PHP Deprecated: __autoload() is deprecated, use spl_autoload_register() instead in /usr/share/spotweb/lib/SpotClassAutoload.php on line 3
PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /usr/share/spotweb/lib/SpotCommandline.php on line 67
Updating schema..(pdo_mysql)
Validating spots(messageid)
Adding column messageid(VARCHAR(128)) to spots
Validating spots(poster)
Adding column poster(VARCHAR(128)) to spots
Validating spots(title)
Adding column title(VARCHAR(128)) to spots
Validating spots(tag)
Adding column tag(VARCHAR(128)) to spots
Validating spots(category)
Adding column category(INTEGER) to spots
Validating spots(subcata)
Adding column subcata(VARCHAR(64)) to spots
Validating spots(subcatb)
Adding column subcatb(VARCHAR(64)) to spots
Validating spots(subcatc)
Adding column subcatc(VARCHAR(64)) to spots
Validating spots(subcatd)
Adding column subcatd(VARCHAR(64)) to spots
Validating spots(subcatz)
Adding column subcatz(VARCHAR(64)) to spots
Validating spots(stamp)
Adding column stamp(UNSIGNED INTEGER) to spots
Validating spots(reversestamp)
Adding column reversestamp(INTEGER) to spots
Validating spots(filesize)
Adding column filesize(UNSIGNED BIGINTEGER) to spots
Validating spots(moderated)
Adding column moderated(BOOLEAN) to spots
Validating spots(commentcount)
Adding column commentcount(INTEGER) to spots
Validating spots(spotrating)
Adding column spotrating(INTEGER) to spots
Validating spots(reportcount)
Adding column reportcount(INTEGER) to spots
Validating spots(spotterid)
Adding column spotterid(VARCHAR(32)) to spots
Validating spotsfull(messageid)
Adding column messageid(VARCHAR(128)) to spotsfull
Validating spotsfull(verified)
Adding column verified(BOOLEAN) to spotsfull
Validating spotsfull(usersignature)
Adding column usersignature(VARCHAR(255)) to spotsfull
Validating spotsfull(userkey)
Adding column userkey(VARCHAR(512)) to spotsfull
Validating spotsfull(xmlsignature)
Adding column xmlsignature(VARCHAR(255)) to spotsfull
Validating spotsfull(fullxml)
Adding column fullxml(TEXT) to spotsfull
Validating nntp(server)
Adding column server(VARCHAR(128)) to nntp
Validating nntp(maxarticleid)
Adding column maxarticleid(INTEGER) to nntp
Validating nntp(nowrunning)
Adding column nowrunning(INTEGER) to nntp
Validating nntp(lastrun)
Adding column lastrun(INTEGER) to nntp
Validating nntp(serverdatelastrun)
Adding column serverdatelastrun(VARCHAR(14)) to nntp
Validating commentsxover(messageid)
Adding column messageid(VARCHAR(128)) to commentsxover
Validating commentsxover(nntpref)
Adding column nntpref(VARCHAR(128)) to commentsxover
Validating commentsxover(spotrating)
Adding column spotrating(INTEGER) to commentsxover
Validating commentsxover(moderated)
Adding column moderated(BOOLEAN) to commentsxover
Validating commentsxover(stamp)
Adding column stamp(UNSIGNED INTEGER) to commentsxover
Validating reportsxover(messageid)
Adding column messageid(VARCHAR(128)) to reportsxover
Validating reportsxover(fromhdr)
Adding column fromhdr(VARCHAR(128)) to reportsxover
Validating reportsxover(keyword)
Adding column keyword(VARCHAR(128)) to reportsxover
Validating reportsxover(nntpref)
Adding column nntpref(VARCHAR(128)) to reportsxover
Validating spotstatelist(messageid)
Adding column messageid(VARCHAR(128)) to spotstatelist
Validating spotstatelist(ouruserid)
Adding column ouruserid(INTEGER) to spotstatelist
Validating spotstatelist(download)
Adding column download(INTEGER) to spotstatelist
Validating spotstatelist(watch)
Adding column watch(INTEGER) to spotstatelist
Validating spotstatelist(seen)
Adding column seen(INTEGER) to spotstatelist
Validating commentsfull(messageid)
Adding column messageid(VARCHAR(128)) to commentsfull
Validating commentsfull(fromhdr)
Adding column fromhdr(VARCHAR(128)) to commentsfull
Validating commentsfull(stamp)
Adding column stamp(INTEGER) to commentsfull
Validating commentsfull(usersignature)
Adding column usersignature(VARCHAR(255)) to commentsfull
Validating commentsfull(userkey)
Adding column userkey(VARCHAR(512)) to commentsfull
Validating commentsfull(spotterid)
Adding column spotterid(VARCHAR(32)) to commentsfull
Validating commentsfull(hashcash)
Adding column hashcash(VARCHAR(255)) to commentsfull
Validating commentsfull(body)
Adding column body(TEXT) to commentsfull
Validating commentsfull(verified)
Adding column verified(BOOLEAN) to commentsfull
Validating commentsfull(avatar)
Adding column avatar(TEXT) to commentsfull
Validating settings(name)
Adding column name(VARCHAR(128)) to settings
Validating settings(value)
Adding column value(TEXT) to settings
Validating settings(serialized)
Adding column serialized(boolean) to settings
Validating commentsposted(ouruserid)
Adding column ouruserid(INTEGER) to commentsposted
Validating commentsposted(messageid)
Adding column messageid(VARCHAR(128)) to commentsposted
Validating commentsposted(inreplyto)
Adding column inreplyto(VARCHAR(128)) to commentsposted
Validating commentsposted(randompart)
Adding column randompart(VARCHAR(32)) to commentsposted
Validating commentsposted(rating)
Adding column rating(INTEGER) to commentsposted
Validating commentsposted(body)
Adding column body(TEXT) to commentsposted
Validating commentsposted(stamp)
Adding column stamp(INTEGER) to commentsposted
Validating spotsposted(messageid)
Adding column messageid(VARCHAR(128)) to spotsposted
Validating spotsposted(ouruserid)
Adding column ouruserid(INTEGER) to spotsposted
Validating spotsposted(stamp)
Adding column stamp(UNSIGNED INTEGER) to spotsposted
Validating spotsposted(title)
Adding column title(VARCHAR(128)) to spotsposted
Validating spotsposted(tag)
Adding column tag(VARCHAR(128)) to spotsposted
Validating spotsposted(category)
Adding column category(INTEGER) to spotsposted
Validating spotsposted(subcats)
Adding column subcats(VARCHAR(255)) to spotsposted
Validating spotsposted(filesize)
Adding column filesize(UNSIGNED BIGINTEGER) to spotsposted
Validating spotsposted(fullxml)
Adding column fullxml(TEXT) to spotsposted
Validating reportsposted(ouruserid)
Adding column ouruserid(INTEGER) to reportsposted
Validating reportsposted(messageid)
Adding column messageid(VARCHAR(128)) to reportsposted
Validating reportsposted(inreplyto)
Adding column inreplyto(VARCHAR(128)) to reportsposted
Validating reportsposted(randompart)
Adding column randompart(VARCHAR(32)) to reportsposted
Validating reportsposted(body)
Adding column body(TEXT) to reportsposted
Validating reportsposted(stamp)
Adding column stamp(INTEGER) to reportsposted
Validating usersettings(userid)
Adding column userid(INTEGER) to usersettings
Validating usersettings(privatekey)
Adding column privatekey(TEXT) to usersettings
Validating usersettings(publickey)
Adding column publickey(TEXT) to usersettings
Validating usersettings(avatar)
Adding column avatar(TEXT) to usersettings
Validating usersettings(otherprefs)
Adding column otherprefs(TEXT) to usersettings
Validating users(username)
Adding column username(VARCHAR(128)) to users
Validating users(firstname)
Adding column firstname(VARCHAR(128)) to users
Validating users(passhash)
Adding column passhash(VARCHAR(40)) to users
Validating users(lastname)
Adding column lastname(VARCHAR(128)) to users
Validating users(mail)
Adding column mail(VARCHAR(128)) to users
Validating users(apikey)
Adding column apikey(VARCHAR(32)) to users
Validating users(lastlogin)
Adding column lastlogin(INTEGER) to users
Validating users(lastvisit)
Adding column lastvisit(INTEGER) to users
Validating users(lastread)
Adding column lastread(INTEGER) to users
Validating users(lastapiusage)
Adding column lastapiusage(INTEGER) to users
Validating users(deleted)
Adding column deleted(BOOLEAN) to users
Validating sessions(sessionid)
Adding column sessionid(VARCHAR(128)) to sessions
Validating sessions(userid)
Adding column userid(INTEGER) to sessions
Validating sessions(hitcount)
Adding column hitcount(INTEGER) to sessions
Validating sessions(lasthit)
Adding column lasthit(INTEGER) to sessions
Validating sessions(ipaddr)
Adding column ipaddr(VARCHAR(45)) to sessions
Validating sessions(devicetype)
Adding column devicetype(VARCHAR(8)) to sessions
Validating securitygroups(name)
Adding column name(VARCHAR(128)) to securitygroups
Validating grouppermissions(groupid)
Adding column groupid(INTEGER) to grouppermissions
Validating grouppermissions(permissionid)
Adding column permissionid(INTEGER) to grouppermissions
Validating grouppermissions(objectid)
Adding column objectid(VARCHAR(128)) to grouppermissions
Validating grouppermissions(deny)
Adding column deny(BOOLEAN) to grouppermissions
Validating usergroups(userid)
Adding column userid(INTEGER) to usergroups
Validating usergroups(groupid)
Adding column groupid(INTEGER) to usergroups
Validating usergroups(prio)
Adding column prio(INTEGER) to usergroups
Validating notifications(userid)
Adding column userid(INTEGER) to notifications
Validating notifications(stamp)
Adding column stamp(INTEGER) to notifications
Validating notifications(objectid)
Adding column objectid(VARCHAR(128)) to notifications
Validating notifications(type)
Adding column type(VARCHAR(128)) to notifications
Validating notifications(title)
Adding column title(VARCHAR(128)) to notifications
Validating notifications(body)
Adding column body(TEXT) to notifications
Validating notifications(sent)
Adding column sent(BOOLEAN) to notifications
Validating filters(userid)
Adding column userid(INTEGER) to filters
Validating filters(filtertype)
Adding column filtertype(VARCHAR(128)) to filters
Validating filters(title)
Adding column title(VARCHAR(128)) to filters
Validating filters(icon)
Adding column icon(VARCHAR(128)) to filters
Validating filters(torder)
Adding column torder(INTEGER) to filters
Validating filters(tparent)
Adding column tparent(INTEGER) to filters
Validating filters(tree)
Adding column tree(TEXT) to filters
Validating filters(valuelist)
Adding column valuelist(TEXT) to filters
Validating filters(sorton)
Adding column sorton(VARCHAR(128)) to filters
Validating filters(sortorder)
Adding column sortorder(VARCHAR(128)) to filters
Validating filters(enablenotify)
Adding column enablenotify(BOOLEAN) to filters
Validating filtercounts(userid)
Adding column userid(INTEGER) to filtercounts
Validating filtercounts(filterhash)
Adding column filterhash(VARCHAR(40)) to filtercounts
Validating filtercounts(currentspotcount)
Adding column currentspotcount(INTEGER) to filtercounts
Validating filtercounts(lastvisitspotcount)
Adding column lastvisitspotcount(INTEGER) to filtercounts
Validating filtercounts(lastupdate)
Adding column lastupdate(INTEGER) to filtercounts
Validating spotteridblacklist(spotterid)
Adding column spotterid(VARCHAR(32)) to spotteridblacklist
Validating spotteridblacklist(ouruserid)
Adding column ouruserid(INTEGER) to spotteridblacklist
Validating spotteridblacklist(idtype)
Adding column idtype(INTEGER) to spotteridblacklist
Validating spotteridblacklist(origin)
Adding column origin(VARCHAR(255)) to spotteridblacklist
Validating spotteridblacklist(doubled)
Adding column doubled(BOOLEAN) to spotteridblacklist
Validating cache(resourceid)
Adding column resourceid(VARCHAR(128)) to cache
Validating cache(cachetype)
Adding column cachetype(INTEGER) to cache
Validating cache(stamp)
Adding column stamp(INTEGER) to cache
Validating cache(metadata)
Adding column metadata(TEXT) to cache
Validating cache(serialized)
Adding column serialized(BOOLEAN) to cache
Validating cache(content)
Adding column content(MEDIUMBLOB) to cache
Validating permaudit(stamp)
Adding column stamp(INTEGER) to permaudit
Validating permaudit(userid)
Adding column userid(INTEGER) to permaudit
Validating permaudit(permissionid)
Adding column permissionid(INTEGER) to permaudit
Validating permaudit(objectid)
Adding column objectid(VARCHAR(128)) to permaudit
Validating permaudit(result)
Adding column result(BOOLEAN) to permaudit
Validating permaudit(ipaddr)
Adding column ipaddr(VARCHAR(45)) to permaudit
Validating index idx_spots_1
Adding index idx_spots_1


SpotWeb crashed

Database schema or settings upgrade failed:
42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE spots ADD UNIQUE INDEX idx_spots_1(messageid)' at line 1


#0 /usr/share/spotweb/lib/dbstruct/SpotStruct_mysql.php(78): dbeng_pdo->rawExec('ALTER IGNORE TA...')
#1 /usr/share/spotweb/lib/dbstruct/SpotStruct_abs.php(109): SpotStruct_mysql->addIndex('idx_spots_1', 'UNIQUE', 'spots', Array)
#2 /usr/share/spotweb/lib/dbstruct/SpotStruct_abs.php(608): SpotStruct_abs->validateIndex('idx_spots_1', 'UNIQUE', 'spots', Array)
#3 /usr/share/spotweb/lib/SpotUpgrader.php(50): SpotStruct_abs->updateSchema()
#4 /usr/share/spotweb/scripts/upgrade-db.php(30): SpotUpgrader->database()
#5 {main}error encountered populating database:
/usr/share/dbconfig-common/scripts/spotweb/install/mysql exited with non-zero status
If the script logged anything about what went wrong,
it can be found in /var/log/apt/term.log.
dbconfig-common: spotweb configure: trying again.
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/spotweb.conf
spotweb already exists and has privileges on spotweb.
creating database spotweb: already exists.
populating database via scriptfile... PHP Deprecated: __autoload() is deprecated, use spl_autoload_register() instead in /usr/share/spotweb/lib/SpotClassAutoload.php on line 3
PHP Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /usr/share/spotweb/lib/SpotCommandline.php on line 67
Updating schema..(pdo_mysql)
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)
Adding column resourceid(VARCHAR(128)) to cache
Validating cache(cachetype)
Adding column cachetype(INTEGER) to cache
Validating cache(stamp)
Adding column stamp(INTEGER) to cache
Validating cache(metadata)
Adding column metadata(TEXT) to cache
Validating cache(serialized)
Adding column serialized(BOOLEAN) to cache
Validating cache(content)
Adding column content(MEDIUMBLOB) to cache
Validating permaudit(stamp)
Validating permaudit(userid)
Validating permaudit(permissionid)
Validating permaudit(objectid)
Validating permaudit(result)
Validating permaudit(ipaddr)
Validating index idx_spots_1
Adding index idx_spots_1
Validating index idx_spots_2
Adding index idx_spots_2
Validating index idx_spots_3
Adding index idx_spots_3
Validating index idx_spots_4
Adding index idx_spots_4
Validating index idx_spots_5
Adding index idx_spots_5
Validating FTS idx_fts_spots
Adding FTS idx_fts_spots
Validating index idx_nntp_1
Adding index idx_nntp_1
Validating index idx_spotsfull_1
Adding index idx_spotsfull_1
Validating index idx_commentsfull_1
Adding index idx_commentsfull_1
Validating index idx_commentsxover_1
Adding index idx_commentsxover_1
Validating index idx_commentsxover_2
Adding index idx_commentsxover_2
Validating index idx_reportsxover_1
Adding index idx_reportsxover_1
Validating index idx_reportsxover_2
Adding index idx_reportsxover_2
Validating index idx_reportsposted_1
Adding index idx_reportsposted_1
Validating index idx_reportsposted_2
Adding index idx_reportsposted_2
Validating index idx_reportspostedrel_1
Adding index idx_reportspostedrel_1
Validating index idx_commentsposted_1
Adding index idx_commentsposted_1
Validating index idx_commentspostedrel_1
Adding index idx_commentspostedrel_1
Validating index idx_spotsposted_1
Adding index idx_spotsposted_1
Validating index idx_spotspostedrel_1
Adding index idx_spotspostedrel_1
Validating index idx_settings_1
Adding index idx_settings_1
Validating index idx_usersettings_1
Adding index idx_usersettings_1
Validating index idx_users_1
Adding index idx_users_1
Validating index idx_users_2
Adding index idx_users_2
Validating index idx_users_3
Adding index idx_users_3
Validating index idx_users_4
Adding index idx_users_4
Validating index idx_sessions_1
Adding index idx_sessions_1
Validating index idx_sessions_2
Adding index idx_sessions_2
Validating index idx_sessions_3
Adding index idx_sessions_3
Validating index idx_sessionsrel_1
Adding index idx_sessionsrel_1
Validating index idx_spotstatelist_1
Adding index idx_spotstatelist_1
Validating index idx_spotstatelistrel_1
Adding index idx_spotstatelistrel_1
Validating index idx_securitygroups_1
Adding index idx_securitygroups_1
Validating index idx_grouppermissions_1
Adding index idx_grouppermissions_1
Validating index idx_usergroups_1
Adding index idx_usergroups_1
Validating index idx_usergroupsrel_1
Adding index idx_usergroupsrel_1
Validating index idx_notifications_1
Adding index idx_notifications_1
Validating index idx_notifications_2
Adding index idx_notifications_2
Validating index idx_filters_1
Adding index idx_filters_1
Validating index idx_filtercounts_1
Adding index idx_filtercounts_1
Validating index idx_spotteridblacklist_1
Adding index idx_spotteridblacklist_1
Validating index idx_spotteridblacklist_2
Adding index idx_spotteridblacklist_2
Validating index idx_cache_1
Adding index idx_cache_1
Validating index idx_cache_2
Adding index idx_cache_2
Schema update done
Updating settings
PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Math_BigInteger has a deprecated constructor in /usr/share/spotweb/Math/BigInteger.php on line 190
Settings update done
Updating users
Users' update done
Performing basic analysis of database tables
Basic database optimalisation done
done.
dbconfig-common: flushing administrative password
apache2_invoke rewrite: already enabled
apache2_invoke: Enable configuration spotweb

suheyl@KODI:~$ sudo find / -name install.php
find: ‘/run/user/1000/gvfs’: Permission denied
suheyl@KODI:~$



Snap er echt niets meer van. Vorige installatie had deze nl wel, en kon ik deze op CLI uitvoeren. Nu dus helemaal niet meer. Ook bevat de /var/www folder ook geen spotweb meer. Spotweb draait echter wel en is benaderbaar via web. Alleen dus geen configuratie noch een admin user om te configureren...

Plaats reactie Vorig onderwerpVolgend onderwerp
Spot-net.nl Forums : Disclaimer