Page 1 of 2
Database problem
Posted: Fri Mar 29, 2024 5:02 am
by Cicca
Accessing to any of the dynamic pages, an error occurs:
Code: Select all
something happened
: No module named _mysql
File "index.cgi", line 23, in
import database
File "/home/dooglus/replay.marpirc.net/database.py", line 4, in
import MySQLdb
File "pythonlib/MySQLdb.py", line 19, in
from _mysql import *
Can someone fix it, please?
Thanks
Cicca
Re: Database problem
Posted: Fri Mar 29, 2024 6:08 am
by mahlemiut
If it can't find MySQL, then it seems like a server issue. Not much can be done.
Re: Database problem
Posted: Tue Apr 02, 2024 5:13 am
by Cicca
Still broken.....who this issue could be addressed to...?! Who's hosting the server...?!
Re: Database problem
Posted: Tue Apr 02, 2024 12:10 pm
by seymour
mahlemiut wrote: ↑Fri Mar 29, 2024 6:08 am
If it can't find MySQL, then it seems like a server issue. Not much can be done.
Is Dooglus still active around here? Something might have changed on one of Dreamhost's updates, could be a simple fix somewhere. If not, if you know his login you can let me know and I can look (or you can) - I don't want to change his password on him so I can
Re: Database problem
Posted: Tue Apr 02, 2024 7:06 pm
by mahlemiut
I have sent an e-mail to Zwaxy, but no response so far (he's not particularly active)
I can upload or modify files on the server if need be, although I am no Python/MySQL expert.
Re: Database problem
Posted: Wed Apr 03, 2024 9:38 am
by seymour
I'm not familiar with his code at all, a few things seem to have been changed around the time the site stopped working, such as maybe pythonlib/ and pythonlib.old.
The whole instance actually was moved to a new shared server, it seems. With an OS update, so something there may have been broken. I don't know if there was something specific in here that was relied on (python and mysql specifically) -
https://help.dreamhost.com/hc/en-us/art ... untu-Focal
Re: Database problem
Posted: Wed Apr 03, 2024 6:20 pm
by mahlemiut
Going from Python 2.x to 3.x could be the main issue here, I seem to remember they are not all that compatible with each other.
Re: Database problem
Posted: Wed Apr 03, 2024 10:02 pm
by ChrisP
On behalf of those of us who love MARP, let me say that if the site disappeared it would be an enormous loss. GL with the issues, hoping for the best.
Re: Database problem
Posted: Thu Apr 04, 2024 7:23 am
by Cicca
ChrisP wrote: ↑Wed Apr 03, 2024 10:02 pm
On behalf of those of us who love MARP, let me say that if the site disappeared it would be an enormous loss. GL with the issues, hoping for the best.
MARP is a priceless patrimony in the arcade scene, and shall not disappear for any reason....
Re: Database problem
Posted: Thu Apr 04, 2024 7:26 am
by Cicca
mahlemiut wrote: ↑Tue Apr 02, 2024 7:06 pm
I have sent an e-mail to Zwaxy, but no response so far (he's not particularly active)
I can upload or modify files on the server if need be, although I am no Python/MySQL expert.
We have precise indication of files, and code lines in them, that are failing...could be, in the luckyest scenario, a matter of paths...any chance of having a look at them...?! I'd try to help.....
In any case, Dreamhost has a pretty responsive tech support.....
Re: Database problem
Posted: Sat Apr 06, 2024 1:37 pm
by seymour
mahlemiut wrote: ↑Wed Apr 03, 2024 6:20 pm
Going from Python 2.x to 3.x could be the main issue here, I seem to remember they are not all that compatible with each other.
Seems python 2 is still there, they just updated the versions of both 2 and 3. It's possible a slight change broke something though. The bigger issue may be the update to MySQL 8? I'm not familiar with his code so I don't know how it's being used exactly.
Re: Database problem
Posted: Mon Apr 08, 2024 5:30 pm
by Weehawk
Wes Copeland, "wc" on the Donkey Kong Forum, and in charge there since Jeff Harrist passed away, indicates that if he can be of assistance with a Python or SQL issue he is willing.
https://donkeykongforum.net/index.php?t ... n#msg46318
Re: Database problem
Posted: Mon Apr 08, 2024 6:42 pm
by Zerstorung
Without being able to look at the source code or a shell...
MySQLdb is not a built-in python package -- it has to be installed via pip.
Most likely scenario is one of two things:
1) The script was running via a python virtual environment that had the MySQLdb package installed, and post-change, an alias or something didn't get ported.
2) Python was changed or updated, and the post-change version doesn't have the MySQLdb package installed.
Happy to help any way I can.
Re: Database problem
Posted: Tue Apr 09, 2024 12:20 pm
by Cicca
I hope he'll fix here....and it woudn't be a bad idea to consider to ask him to be in charge of the site (Python + MySQL) mantenance....unless someone in MARP with enough expertise (Zerstorung ?) offers to....
Re: Database problem
Posted: Sun Apr 14, 2024 4:34 pm
by Chufoglu
The best replay site in the world should not die, it would be a tragedy...