 |
|
|
|
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Current status: new server has now been relocated to the data center and
now has its normal bandwidth available again.
I've mostly finished converting the main site PHP code to suit PHP7 and
mysqli, with most of the work being (as expected) in the user
registration, login, password recovery etc code. I've got this working
on a test site and once I've done inspecting a final diff of the code
I'll push it live.
When it does go live (hopefully tomorrow) I'd appreciate it if you'd
bang on it to flush out anything I've missed. I'll let you know when.
-- Chris
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
On 3/17/21 9:57 PM, Chris Cason wrote:
> On 18/03/2021 04:42, Ash Holsenback wrote:
>> forged ahead... i have v1.33.4 wiki testbed running
>
> thanks ... As the wiki ran in a jail (kind of like a lite vm with its
> own ip adress, daemons and login accounts), it and other related sites
> like the texlib etc are last on the list of things I have to recover.
>
> [This is primarily because the jailed processed get a clone of pretty
> much the entire server environment and there's no point in cloning it
> until I've finished setting the server up.]
>
> If you need data from the server pre-crash I have the wiki db recovered
> already and dumped to .sql files (10mb compressed), a tarball of the
> http directory (117mb compressed), and a tarball of your home directory
> (1.2gb compressed). Just LMK what you need and I'll email you a link.
>
> [If you need the latter it may need to wait until the machine has been
> moved back to the DC as the outbound bandwidth at the office is a bit
> more limited than the DC.]
>
> -- Chris
downloaded files... thanks for the crib notes on known issues. one other
thing i'm going to need to check my db compliance:
ash@rogue:/users/ash/POV-Ray/WikiDocGen $ mysqladmin version
mysqladmin Ver 9.1 Distrib 10.2.36-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Server version 10.2.36-MariaDB
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /run/mysql/mysql.sock
Uptime: 11 min 25 sec
Threads: 7 Questions: 12 Slow queries: 0 Opens: 17 Flush tables: 1
Open tables: 11 Queries per second avg: 0.017
if you've seen anything on this ( before i start poking ) let me know
cheers
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Sorry if this is mentioned already, but in Thunderbird I am sometimes
getting the wrong messages with the wrong thread titles. Maybe it's a
database issue?
Mike
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
On 21/03/2021 08:40, Mike Horvath wrote:
> Sorry if this is mentioned already, but in Thunderbird I am sometimes
> getting the wrong messages with the wrong thread titles. Maybe it's a
> database issue?
The NNTP server doesn't use a database per se; it's a monolithic app
that stores the articles in its own format.
It's possible something has gone awry in its indexing of the articles.
I'll take a look and see if I can find a way to re-generate the XOVER files.
-- Chris
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
On 21/03/2021 01:09, Ash Holsenback wrote:
> ash@rogue:/users/ash/POV-Ray/WikiDocGen $ mysqladmin version
> Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
>
>
>
> if you've seen anything on this ( before i start poking ) let me know
Since we're restoring from .SQL files MariaDB 10 should be fine. I could
possibly even install that on the server, though ideally I'd prefer to
use MySQL 5.7 for the wiki as that's what I'm using for everything else.
TBH it probably doesn't matter as long as you export your final setup
into SQL queries (like mysqldump does) as we could import them into
MySQL. My only concern about that would be that the mysql database
itself (user and privilege stuff) may not be compatible, so for those
you'd need to keep a copy of the queries you use to create those users
and permissions so we can re-run them on the final system.
If I were to install MariaDB on the server it would be version 10.5.8,
so if you want to stick with MariaDB then I'd suggest working with that
version.
-- Chris
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
On 2021-03-20 6:46 PM (-4), Chris Cason wrote:
> On 21/03/2021 08:40, Mike Horvath wrote:
>> Sorry if this is mentioned already, but in Thunderbird I am sometimes
>> getting the wrong messages with the wrong thread titles. Maybe it's a
>> database issue?
> The NNTP server doesn't use a database per se; it's a monolithic app
> that stores the articles in its own format.
>
> It's possible something has gone awry in its indexing of the articles.
> I'll take a look and see if I can find a way to re-generate the XOVER
> files.
I submitted an article to povray.binaries.images Thursday night, but I
am not seeing it. Thunderbird records it as having been sent.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
On 21/03/2021 15:26, Cousin Ricky wrote:
> I submitted an article to povray.binaries.images Thursday night, but I
I've told the server to re-generate its indexes and overview files; see
if that helps.
I can see a post from you called "Hooded lamp occlusion" in pbi now, so
if that's the one you are referring to, it's definitely there (though I
didn't check before re-generating the indexes, so I don't know if that
was the cause or not).
-- Chris
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Current status: www.povray.org is now back in read-write mode with the
database hooked back in.
I've made extensive changes to the code, particularly in respect to the
user account creation, login, recovery, and so forth.
While I was at it I took out the ability to add a homepage and 'about'
during account creation as 99% of user registrations over the past few
years that had these filled in were from spammers thinking that we'd
display them on the site.
Please bang on the user registration stuff to see if you can flush out
any problems. If you want to create new accounts for testing just use
your email address with a '+' (e.g. 'myemail+tes### [at] mydomain com'). The
plussed address is considered different for registration purposes but
all standards-compliant mail severs will ignore the part after the '+'
when accepting email.
(If you do this please let me know when you're done so I can delete the
accounts; so you don't need to post email address here, just use unique
user names for each and tell me what that is).
Other smaller changes: I have tweaked the navigation menu to add a
'Login' link as I think the old login page was harder than it should be
to find.
I've also changed the povQandT link that used to point to tag.povray.org
to instead be called 'FAQ' and now points directly at the main server. I
edited the QandT pages a bit to try to fit them into the new location a
little better; I will need to re-jig them to use PHP in order to load
the main site theme (they are currently just HTML). At this point I
don't think there's much else on the TAG site that needs to be kept (LMK
if you think there is) so I'll likely change the tag.povray.org config
to just redirect to www.povray.org.
If you find anything broken in the povQandT (apart from some background
images that don't seem to load) please let me know. Also if anyone wants
to volunteer to update the content I'd be happy to drop a zip here or
email it you.
-- Chris
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
While doing the restore I took the opportunity to clean out a lot of
cruft that had built up over the years (mostly in temp dirs or
out-of-the way places that aren't referred to by any of the site code).
One location I did keep (at least for now), even though it's not
referenced anywhere I can find, is http://www.povray.org/nostalgia/. It
looks like I copied those files to the server sometime in 2006 but I
can't remember why and there don't seem to be any links to it out there
(tried google's inurl: search and also the wayback machine).
I won't link into the main site as it appears I just dropped them there
for someone as it's just a bunch of images. But the nostalgia is strong
with these ones as any old-timers will know, so I'll hold off nuking it
for now :)
-- Chris
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
On 3/21/21 12:26 AM, Cousin Ricky wrote:
> On 2021-03-20 6:46 PM (-4), Chris Cason wrote:
>> On 21/03/2021 08:40, Mike Horvath wrote:
>>> Sorry if this is mentioned already, but in Thunderbird I am sometimes
>>> getting the wrong messages with the wrong thread titles. Maybe it's a
>>> database issue?
>> The NNTP server doesn't use a database per se; it's a monolithic app
>> that stores the articles in its own format.
>>
>> It's possible something has gone awry in its indexing of the articles.
>> I'll take a look and see if I can find a way to re-generate the XOVER
>> files.
>
> I submitted an article to povray.binaries.images Thursday night, but I
>
try re-downloading the headers... i saw the same issue couple of days
ago when news 1st came back online. that all i had to do
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
