Ai Dreams Forum

AI Dreams => Welcome to AI Dreams forum. => Announcements => Topic started by: infurl on July 02, 2020, 11:04:20 am

Title: New Server
Post by: infurl on July 02, 2020, 11:04:20 am
Hi folks,

I've been toiling away since last week to get the new server up and running. Freddy let me have a copy of the forum software and database for testing, but since we won't switch the aidreams.co.uk domain name to the new server until we're sure it's working properly, it is at https://charidge.com (https://charidge.com) for now.

If you can spare a few minutes, please go to https://charidge.com (https://charidge.com) and see if it's working for you, but note the following:

1. It is a copy of the database from last week so it is missing anything that has been posted since then.
2. The new mail server isn't set up yet so you can't get any email notifications from it at the moment.
3. You will have to reset your password using your secret question and answer before you can log in there.
4. Try making some test posts but remember they will be deleted when we switch to the live database.
5. Please post here if you have any problems and I'll try to fix them.

I've still got a lot to learn about this forum software and finding and fixing problems is the fastest way to learn how to manage it.
Title: Re: New Server
Post by: manases on July 02, 2020, 11:17:13 am
getting
Data too long for column 'ip' at row 1
Looks like you need to make it bigint or smth :)

I was just about to say the website looks really amazing - wondering why the changes... I guess there is a lot to read around.
Title: Re: New Server
Post by: infurl on July 02, 2020, 11:56:11 am
getting
Data too long for column 'ip' at row 1
Looks like you need to make it bigint or smth :)

Thank you very much for the bug report. I got that problem once as well but I hadn't been able to reproduce it again; that's why I decided to announce the test site to see if anyone else got the same problem.

From studying the logs now I believe I know what is wrong. The server is receiving a mix of requests via both the IPv4 and IPv6 internet protocols but the database is only able to store IPv4 addresses. I expect if I modify that database field so it will accept longer strings for IPv6, the problem should go away.
Title: Re: New Server
Post by: ivan.moony on July 02, 2020, 12:18:58 pm
Can't reset password, says I gave a wrong answer to my secret question. Then I tried other reset password by getting a reset-password mail, but I didn't receive the mail in more than ten minutes.
Title: Re: New Server
Post by: infurl on July 02, 2020, 12:33:02 pm
Can't reset password, says I gave a wrong answer to my secret question. Then I tried other reset password by getting a reset-password mail, but I didn't receive the mail in more than ten minutes.

You won't be able to get any email yet because I haven't got the mail server working and your secret answer and password are encrypted so I can't get them from the database. I'll keep working on it though and I'll let you know when it is worth trying again.

I've altered the database to allow storing IPv6 addresses, so if anyone else encounters that problem, please let me know and I'll "go back to the drawing board" :D

Title: Re: New Server
Post by: Art on July 02, 2020, 12:49:35 pm
Trying the Brave, Chrome, and Firefox browsers I received the same messages:
Data too long for column 'ip' at row 1
Title: Re: New Server
Post by: infurl on July 02, 2020, 01:10:20 pm
Trying the Brave, Chrome, and Firefox browsers I received the same messages:
Data too long for cloumn 'ip' at row 1

I've increased the size of the IP field from the original 15 characters up to 255 characters, but looking through the code I think there might be other problems. There's only one place in the forum software where it cares about IP addresses but it does all it's processing by converting the IP address to an integer. While that works fine for a 32-bit IPv4 address, it can't be made to work for a 128-bit IPv6 address.

I'll have to either rewrite that part of the forum software to use strings, find an updated version of the module, uninstall the module and hope we can live without it, or figure out how to disable IPv6 on the new server.

Thanks for giving it a whirl Art. I'll have to pick this up again tomorrow.
Title: Re: New Server
Post by: Hopefully Something on July 02, 2020, 01:17:07 pm
I logged in to charidge without changing my password.
Title: Re: New Server
Post by: infurl on July 02, 2020, 01:24:34 pm
I logged in to charidge without changing my password.

That's interesting. I wonder why some passwords work and some don't. I had to reset my password using my secret question and answer. Another question to add to the list...
Title: Re: New Server
Post by: manases on July 02, 2020, 02:09:29 pm
Sometimes I also do programming but server configurations or software configurations, are my absolute nightmares.

I always thought that the first thing AI should pickup should be programming.
It is all repetitive with a small set of variables (problems) and with a huge return in progress.

The problem it is how to transfer knowledge, isn't it?
In Starcraft2 - they have replays and clear wind/lose conditions.

Maybe google should launch an IDE (or make a module for an existing one) where you can set the problem and then mark the problem as solved - so developers can train the AI.
This would be so amazing...

Setting the problem as fixed is easy but how do you tell google the problem?
Maybe trough voice commands?
Google - set problem - Data too long for column 'ip' at row 1
Then you monkey-code until is fixed then you mark the problem as fixed.
Actually this also involves db changes outside the IDE.. so there should be a general observer agent...
Title: Re: New Server
Post by: Korrelan on July 02, 2020, 02:22:10 pm
Arrived and got the usual cookie request.
Entered current username & password... and it let me straight In, made a post.

I am running XP 32bit and Firefox ATM.

Chrome works as above too.

Win7 32 & Chrome... no problems

Win 10 & Chrome... no problems
Win 10 & Edge... no problems

Win 1, 1.1, win95, win98... Failed... Lol

 :)
Title: Re: New Server
Post by: 8pla.net on July 02, 2020, 05:07:02 pm
getting
Data too long for column 'ip' at row 1

This page claims to have found a solution:
https://stackoverflow.com/questions/15949038/error-code-1406-data-too-long-for-column-mysql

May be as easy as:
Code
SET @@global.sql_mode= '';

Good Luck!
Title: Re: New Server
Post by: manases on July 02, 2020, 05:42:20 pm
I am not sure they want to truncate the IP
or to mask the errors in any way, that is something like
https://youtu.be/9F3iBMYvQOs?t=46
It could be a fix for the mo, when installing a large application, you can disable some features in the beginning...
Title: Re: New Server
Post by: infurl on July 05, 2020, 05:56:06 am
Here's a progress report. I believe that I've fixed the "getting data too long for column 'ip' at row 1" problem that some of us (me included) have been experiencing. It was caused because the new server has interfaces to both the old IPv4 internet and the new IPv6 internet. One of the modules in the forum software was unable to handle the longer addresses from the IPv6 network and if your browser tried to connect via that path, the forum would choke. Most people automatically have interfaces to both internets nowadays (even if you don't know it) so for the time being I've disabled the IPv6 interface and I'm no longer getting the error when I try to connect. I hope nobody else is either, so please let me know if it's still not working for you.

Some of us have had to reset our passwords on the test server and I'm not sure why yet. Without a working mail server the only way to reset your password is via the secret question and answer. Now would probably be a good time to review your secret question and answer in case you don't remember what it was. We should have a working mail server soon; I've completed the setup and now I'm just waiting for the hosting service to review it and (I hope) approve it so I can finish testing. It was only slightly harder than getting a loan from a bank. ;)
Title: Re: New Server
Post by: manases on July 05, 2020, 08:11:38 am
Yep - is working now
Title: Re: New Server
Post by: infurl on July 06, 2020, 04:02:55 am
So far so good, I've had no more reports about the forum software not working on the new server. It's possible that the password problems that a few of us had were linked to the IPv6 problems too.

We got approval to have our own mail server and I expect to finish setting it up today. I'll have to go carefully so it doesn't accidentally send out hundreds of bogus emails when I hook it up to the forum, so I apologize in advance if something like that happens, but I'll do my best to avoid it.
Title: Re: New Server
Post by: Korrelan on July 06, 2020, 09:06:46 am
Your doing an excellent job, let the mail flood commence.

 :)
Title: Re: New Server
Post by: infurl on July 13, 2020, 12:43:52 pm
The new server is all set up. The next step will be to make it the authoritative name server and once that process is complete, we will be ready to lock the old forum server, transfer the database, and then point the new name server at the new IP address. If that goes well it should only take a few minutes and you might not even notice the change. It can be hard to say how it will go when changes to name servers are involved because the information can take anything from a few minutes to a few days to propagate across the internet.

In the meantime, mail processing should be working on the new server at the temporary domain name of https://charidge.com. If you do something on the new server that would normally send you an email, you should get one from it from now on.
Title: Re: New Server
Post by: Freddy on July 14, 2020, 01:15:54 pm
Hi folks :)

Infurl is now an administrator - I think we will co-admin things until he feels comfortable, so you ain't rid of me yet  ;)

I will still pop in sometimes as I plan to continue to develop my ElfScript engine for text games.

Take care all :)
Title: Re: New Server
Post by: infurl on August 26, 2020, 11:30:36 pm
Good news everyone!

We changed over to the new server a few days ago and everything seems to be running fine so far. I've still got a lot to learn about the forum software but I'll try to keep on top of things.  :)

If you didn't notice anything different, I'll take that as a good sign.  ;D
Title: Re: New Server
Post by: Hopefully Something on August 27, 2020, 12:29:01 am
Looking normal except for some contractions typed in Word. Let's test how it is now, Don’t Doesn’t Hasn’t I’m he’s she’s we’re It’s haven’t company’s

Ok! Whatever it was seems to have resolved itself.
Title: Re: New Server
Post by: squarebear on August 27, 2020, 02:22:42 am
Great work. Everything looks good from my end.  O0
Title: Re: New Server
Post by: LOCKSUIT on August 27, 2020, 04:13:02 am
Awesome!

I seem to be missing a few coins on my profile rank <

About 5 or 7.

Also somehow my title switched from Admin to Trusty Member.

:)
Title: Re: New Server
Post by: infurl on August 27, 2020, 04:16:12 am
Also somehow my title switched from Admin to Trusty Member.

Nice try but I'm not buying it.  :2funny:
Title: Re: New Server
Post by: LOCKSUIT on August 27, 2020, 08:03:38 am
Attachment issue detected!

Says:
"The attachments upload directory is not writable. Your attachment or avatar cannot be saved."
Title: Re: New Server
Post by: infurl on August 27, 2020, 08:05:45 am
"The attachments upload directory is not writable. Your attachment or avatar cannot be saved."

Thanks for letting me know, I'll look into it in a bit. Out of curiosity, did that work before?
Title: Re: New Server
Post by: LOCKSUIT on August 27, 2020, 08:08:22 am
Yes it did, any name and PNG, it'd upload. It is a small image too.
Title: Re: New Server
Post by: infurl on August 27, 2020, 08:16:42 am
Yes it did, any name and PNG, it'd upload. It is a small image too.

It ought to work now, I changed the access privileges on the attachments directory.
Title: Re: New Server
Post by: LOCKSUIT on August 27, 2020, 08:25:17 am
<image>