Database Troubles about timeline HOT 5 CLOSED

That was quite detailed, and I appreciate it. You've put a lot of work on that.

The database structure part: You are good to go (you could have just run DatabasePort.py, by giving old-db name as a dummy database :male_shrug:)

Now to the issue, it seems MySQL is unable to find the server on default IP/Port it's supposed to run. Clarify these, make sure your didn't set custom port for MySQL server, if so you might wanna change some codes (and get a coffee). Also that your MySQL database is hosted on your remote environment (localhost)

Next I would suggest you to try these changes, open in a text editor

Timeline/Database/__init__.py, line 38

Try changing that line to

Registry.DBPOOL = ReconnectingMySQLConnectionPool('MySQLdb', user=user, passwd=passd, db=db, cp_reconnect=True, port='3306', host='127.0.0.1')

Sometimes, depending upon the os, MySQL accepts connection only via 127.0.0.1. If above doesn't work, you can try changing host='...' to host='0.0.0.0'.

Else, if you are hosting your database on a different server (outside your vps), change host to that server IP (make sure in this case you allow remote connection)

And (yh while drinking your coffee) if you have set custom port, change the port parameter value too

from timeline.

Haha no worries! I get that it can be hard to reproduce or answer if info is missing or undetailed.

Thanks for the fix! It's now connecting like it should.

Unfortunately getting another error thrown:

Looking into this myself now, but if you might know the fix before I find it I'd appreciate it ;)

P.s. got my coffee =)

from timeline.

Did I forget to mention? Timeline has some self-healing capabilities 😋. Just restart the server and check if that error still persists.

from timeline.

Brilliant my dude!

Thanks for creating this piece of art 🥇

It's been a long time since I've been working in this scene, me and a friend were, back in the day the first operational cpps with a webclient. Back then that was the shizzle, eventually got the game running on SmartFoxServer. Unfortunately most of that data is lost. Talking +/- 10 years ago 😝

Anyways, thanks for the quick replies as well!

from timeline.

Sweet! Have a great (coffee) day!

from timeline.