Rocksolid Light

News from da outaworlds

mail  files  register  groups  login

Message-ID:  

BOFH excuse #269: Melting hard drives

rocksolid / Rocksolid Nodes Help / Re: sqlite db doesn't have articles, but they exist on the web

SubjectAuthor
* sqlite db doesn't have articles, but they exist on the webMarco Moock
`* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
 `* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
  `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
   `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
    `* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
     +- Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
     `* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
      `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
       +- Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
       `* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
        `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
         +* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
         |`* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
         | `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
         |  `* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
         |   `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
         |    `* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
         |     `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
         |      `* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
         |       `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
         |        `* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
         |         `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
         |          `- Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
         `* Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
          +- Re: sqlite db doesn't have articles, but they exist on the webMarco Moock
          `* Re: sqlite db doesn't have articles, but they exist on the webRetro Guy
           `- Re: sqlite db doesn't have articles, but they exist on the webRetro Guy

Pages:12
Subject: Re: sqlite db doesn't have articles, but they exist on the web
From: Marco Moock
Newsgroups: rocksolid.nodes.help
Organization: A noiseless patient Spider
Date: Fri, 3 May 2024 07:34 UTC
References: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Path: eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: mm+usenet@dorfdsl.de (Marco Moock)
Newsgroups: rocksolid.nodes.help
Subject: Re: sqlite db doesn't have articles, but they exist on the web
Date: Fri, 3 May 2024 09:34:12 +0200
Organization: A noiseless patient Spider
Lines: 61
Message-ID: <v1241l$d7bl$3@dont-email.me>
References: <v0gsqn$3r63q$1@dont-email.me>
<e89c9f6680c1371e55c2b69ce767ce71$1@invalid.invalid>
<v0ipub$bo9k$1@dont-email.me>
<320ce2e09ac1cc3cfcb5477b8b3210fb@www.rocksolidbbs.com>
<e0574b7cffc0202d6f672dd7dd4e5f05@www.novabbs.org>
<v0j00u$bo9k$2@dont-email.me>
<v0tmmo$35326$2@dont-email.me>
<9e7551182924bf0aca4ab9fa7e1a1da0$1@invalid.invalid>
<v0tv4t$39sdv$1@dont-email.me>
<9d885566ed21da3a88197f6d84ae7d64$1@invalid.invalid>
<4464da8bef610dac30dbbfc4feb8f654$1@invalid.invalid>
<v0u2rr$3ai6i$1@dont-email.me>
<fdeb712097f93a743f7756ab699f3cba$1@invalid.invalid>
<v0u4kq$3ai6i$3@dont-email.me>
<78d766a8bf88741b5f16b0babbdfda82$1@invalid.invalid>
<v0vnc5$3ovd3$1@dont-email.me>
<43649357df70ab0edf0feca5dbdc0231@www.novabbs.org>
<v10o9d$10ft$1@dont-email.me>
<da693d979729d39da607649e72ad2cf6$1@invalid.invalid>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 03 May 2024 09:34:13 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="01c1c1977e409460ecb8cd6f8fe85198";
logging-data="433525"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/53KjSKZPwJVycDff/w6gc"
Cancel-Lock: sha1:XeTT/gG62yvBaqeXaGfhF1W/XgI=
View all headers

Am 02.05.2024 schrieb Retro Guy <retroguy@novabbs.com>:

> On Thu, 2 May 2024 21:07:24 +0200, Marco Moock wrote:
>
> > On 02.05.2024 um 10:07 Uhr Retro Guy wrote:
> >
> >> Everything in /var/www/html recursively should be readable by the
> >> web server user.
> >
> > That is now the case.
> >
> > root@pi-dach:~# find /var/www/html -name "config.inc.php"
> > /var/www/html/rocksolid/config.inc.php
> > /var/www/html/common/config.inc.php
> > /var/www/html/spoolnews/config.inc.php
> > root@pi-dach:~# find /var/www/html -name "config.inc.php" -exec ls
> > -la {} \; -rw-r--r-- 1 www-data www-data 7044 18. Apr 12:45
> > /var/www/html/rocksolid/config.inc.php -rw-r--r-- 1 www-data
> > www-data 545 18. Apr 12:46 /var/www/html/common/config.inc.php
> > lrwxrwxrwx 1 www-data www-data 27 18. Apr 12:45
> > /var/www/html/spoolnews/config.inc.php ->
> > ../rocksolid/config.inc.php root@pi-dach:~#
> >
> > Although, the script won't run.
> >
> > root@pi-dach:~# sudo -u www-data php
> > /etc/rslight/scripts/maintenance.php -import de.soc.wirtschaft PHP
> > Warning: include(config.inc.php): Failed to open stream:
> > Permission denied in /etc/rslight/scripts/maintenance.php on line
> > 20 PHP Warning: include(): Failed opening 'config.inc.php' for
> > inclusion (include_path='.:/usr/share/php') in
> > /etc/rslight/scripts/maintenance.php on line 20 PHP Warning:
> > Undefined variable $file_newsportal in
> > /etc/rslight/scripts/maintenance.php on line 21 PHP Fatal error:
> > Uncaught ValueError: Path cannot be empty in
> > /etc/rslight/scripts/maintenance.php:21 Stack trace: #0 {main}
> > thrown in /etc/rslight/scripts/maintenance.php on line 21
> > root@pi-dach:~#
> >
> > Running cat as www-data works fine.
>
> Are you running from the spoolnews dir?

I wasn't.

> >> Run as your web server user. I'm guessing www-data
> >>
> >> cd /var/www/html/spoolnews
> >> php /etc/rslight/scripts/maintenance.php -help
>
> If you are, make sure there is a config.inc.php in that dir that is a
> symlink to the one in /var/www/html/rocksolid

I created that, but that now throws more errors.
I think he path handling should be done in the php script if possible.

root@pi-dach:/var/spool/rslight# sudo -u www-data php /etc/rslight/scripts/maintenance.php -import de.soc.wirtschaft
PHP Warning: include(../common/config.inc.php): Failed to open stream: No such file or directory in /var/www/html/rocksolid/config.inc.php on line 2
PHP Warning: include(): Failed opening '../common/config.inc.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/rocksolid/config.inc.php on line 2

Subject: Re: sqlite db doesn't have articles, but they exist on the web
From: Retro Guy
Newsgroups: rocksolid.nodes.help
Organization: Rocksolid Light
Date: Fri, 3 May 2024 08:03 UTC
References: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Path: eternal-september.org!news.eternal-september.org!feeder3.eternal-september.org!i2pn.org!i2pn2.org!.POSTED!not-for-mail
From: retroguy@novabbs.com (Retro Guy)
Newsgroups: rocksolid.nodes.help
Subject: Re: sqlite db doesn't have articles, but they exist on the web
Date: Fri, 3 May 2024 08:03:16 +0000
Organization: Rocksolid Light
Message-ID: <9b27444fcfd6d2479d2991a55609342d@www.novabbs.org>
References: <v0gsqn$3r63q$1@dont-email.me> <e89c9f6680c1371e55c2b69ce767ce71$1@invalid.invalid> <v0ipub$bo9k$1@dont-email.me> <320ce2e09ac1cc3cfcb5477b8b3210fb@www.rocksolidbbs.com> <e0574b7cffc0202d6f672dd7dd4e5f05@www.novabbs.org> <v0j00u$bo9k$2@dont-email.me> <v0tmmo$35326$2@dont-email.me> <9e7551182924bf0aca4ab9fa7e1a1da0$1@invalid.invalid> <v0tv4t$39sdv$1@dont-email.me> <9d885566ed21da3a88197f6d84ae7d64$1@invalid.invalid> <4464da8bef610dac30dbbfc4feb8f654$1@invalid.invalid> <v0u2rr$3ai6i$1@dont-email.me> <fdeb712097f93a743f7756ab699f3cba$1@invalid.invalid> <v0u4kq$3ai6i$3@dont-email.me> <78d766a8bf88741b5f16b0babbdfda82$1@invalid.invalid> <v0vnc5$3ovd3$1@dont-email.me> <43649357df70ab0edf0feca5dbdc0231@www.novabbs.org> <v10o9d$10ft$1@dont-email.me> <da693d979729d39da607649e72ad2cf6$1@invalid.invalid> <v1241l$d7bl$3@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Info: i2pn2.org;
logging-data="3108862"; mail-complaints-to="usenet@i2pn2.org";
posting-account="gg+dDWHMzVrdxGO9Gmt8aqyeWDXqlxfqiuS0jX/WMXY";
User-Agent: Rocksolid Light
X-Spam-Checker-Version: SpamAssassin 4.0.0
X-Rslight-Posting-User: a93aefeeff923def71455caae2dbfb277a59e046
X-Face: .&YR-G(w(DZ$$,}%k=]*5*!p'=(anr"IT`wZG'2VWdfl\r)l[42u7JH`n(JUQ*e5*A|XCDf
?&\X&uwkl38"CYX3O8m}C8E4p'%N$2#kSTVzx{Ly|DjLT\Vk7NE}NQ(VC$Yq]i:7|z[.9iv^g>*8_B
H0=hZt'[%)4kG|
X-Rslight-Site: $2y$10$DVg0nqlUqzW4xyLnSg9hw.KRc5P6chYOgaMuaZO37k6EQ1t5TQlZ6
View all headers

Marco Moock wrote:

> Am 02.05.2024 schrieb Retro Guy <retroguy@novabbs.com>:

>> On Thu, 2 May 2024 21:07:24 +0200, Marco Moock wrote:
>>
>> > On 02.05.2024 um 10:07 Uhr Retro Guy wrote:
>> >
>> >> Everything in /var/www/html recursively should be readable by the
>> >> web server user.
>> >
>> > That is now the case.
>> >
>> > root@pi-dach:~# find /var/www/html -name "config.inc.php"
>> > /var/www/html/rocksolid/config.inc.php
>> > /var/www/html/common/config.inc.php
>> > /var/www/html/spoolnews/config.inc.php
>> > root@pi-dach:~# find /var/www/html -name "config.inc.php" -exec ls
>> > -la {} \; -rw-r--r-- 1 www-data www-data 7044 18. Apr 12:45
>> > /var/www/html/rocksolid/config.inc.php -rw-r--r-- 1 www-data
>> > www-data 545 18. Apr 12:46 /var/www/html/common/config.inc.php
>> > lrwxrwxrwx 1 www-data www-data 27 18. Apr 12:45
>> > /var/www/html/spoolnews/config.inc.php ->
>> > ../rocksolid/config.inc.php root@pi-dach:~#
>> >
>> > Although, the script won't run.
>> >
>> > root@pi-dach:~# sudo -u www-data php
>> > /etc/rslight/scripts/maintenance.php -import de.soc.wirtschaft PHP
>> > Warning: include(config.inc.php): Failed to open stream:
>> > Permission denied in /etc/rslight/scripts/maintenance.php on line
>> > 20 PHP Warning: include(): Failed opening 'config.inc.php' for
>> > inclusion (include_path='.:/usr/share/php') in
>> > /etc/rslight/scripts/maintenance.php on line 20 PHP Warning:
>> > Undefined variable $file_newsportal in
>> > /etc/rslight/scripts/maintenance.php on line 21 PHP Fatal error:
>> > Uncaught ValueError: Path cannot be empty in
>> > /etc/rslight/scripts/maintenance.php:21 Stack trace: #0 {main}
>> > thrown in /etc/rslight/scripts/maintenance.php on line 21
>> > root@pi-dach:~#
>> >
>> > Running cat as www-data works fine.
>>
>> Are you running from the spoolnews dir?

> I wasn't.

>> >> Run as your web server user. I'm guessing www-data
>> >>
>> >> cd /var/www/html/spoolnews
>> >> php /etc/rslight/scripts/maintenance.php -help
>>
>> If you are, make sure there is a config.inc.php in that dir that is a
>> symlink to the one in /var/www/html/rocksolid

> I created that, but that now throws more errors.

> root@pi-dach:/var/spool/rslight# sudo -u www-data php
/etc/rslight/scripts/maintenance.php -import de.soc.wirtschaft
> PHP Warning: include(../common/config.inc.php): Failed to open stream:
No such file or directory in /var/www/html/rocksolid/config.inc.php on line
2 > PHP Warning: include(): Failed opening '../common/config.inc.php' for
inclusion (include_path='.:/usr/share/php') in
/var/www/html/rocksolid/config.inc.php on line 2

Something is really messed up on your install. That symlink shouldn't be
missing, and permissions should be ok unless manually changed. The fact
that the symlink was missing is a sign that other things may also be
missing.

I would suggest to disable the cron.php job.

Back up /etc/rslight/* and /var/spool/rslight/* (Backup everything is
better and safer)

Then perform a normal install.

Then restore /etc/rslight/* and /var/spool/rslight/*

Then restore the cron.php job.

> I think he path handling should be done in the php script if possible.

I fully agree. I have been bothered by that for a while, but it's not a
quick fix. I'm actually taking a look into that today.

--
Retro Guy

Subject: Re: sqlite db doesn't have articles, but they exist on the web
From: Marco Moock
Newsgroups: rocksolid.nodes.help
Organization: A noiseless patient Spider
Date: Fri, 3 May 2024 13:50 UTC
References: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Path: eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: mm+usenet@dorfdsl.de (Marco Moock)
Newsgroups: rocksolid.nodes.help
Subject: Re: sqlite db doesn't have articles, but they exist on the web
Date: Fri, 3 May 2024 15:50:18 +0200
Organization: A noiseless patient Spider
Lines: 10
Message-ID: <v12q2q$ii0q$1@dont-email.me>
References: <v0gsqn$3r63q$1@dont-email.me>
<e89c9f6680c1371e55c2b69ce767ce71$1@invalid.invalid>
<v0ipub$bo9k$1@dont-email.me>
<320ce2e09ac1cc3cfcb5477b8b3210fb@www.rocksolidbbs.com>
<e0574b7cffc0202d6f672dd7dd4e5f05@www.novabbs.org>
<v0j00u$bo9k$2@dont-email.me>
<v0tmmo$35326$2@dont-email.me>
<9e7551182924bf0aca4ab9fa7e1a1da0$1@invalid.invalid>
<v0tv4t$39sdv$1@dont-email.me>
<9d885566ed21da3a88197f6d84ae7d64$1@invalid.invalid>
<4464da8bef610dac30dbbfc4feb8f654$1@invalid.invalid>
<v0u2rr$3ai6i$1@dont-email.me>
<fdeb712097f93a743f7756ab699f3cba$1@invalid.invalid>
<v0u4kq$3ai6i$3@dont-email.me>
<78d766a8bf88741b5f16b0babbdfda82$1@invalid.invalid>
<v0vnc5$3ovd3$1@dont-email.me>
<43649357df70ab0edf0feca5dbdc0231@www.novabbs.org>
<v10o9d$10ft$1@dont-email.me>
<da693d979729d39da607649e72ad2cf6$1@invalid.invalid>
<v1241l$d7bl$3@dont-email.me>
<9b27444fcfd6d2479d2991a55609342d@www.novabbs.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 03 May 2024 15:50:19 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="01c1c1977e409460ecb8cd6f8fe85198";
logging-data="608282"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX184g8SU9F9CfYEXJa8lqo1g"
Cancel-Lock: sha1:7oDFgFL2XlQheLBoJ8+S6XrVxOo=
View all headers

Am 03.05.2024 schrieb Retro Guy <retroguy@novabbs.com>:

> Something is really messed up on your install. That symlink shouldn't
> be missing, and permissions should be ok unless manually changed. The
> fact that the symlink was missing is a sign that other things may
> also be missing.

Now it worked by the nocem message, no maintenance script needed
anymore.

Pages:12

rocksolid light 0.9.8
clearnet tor