Database problem

General discussion on MAME, MARP, or whatever else that doesn't belong in any of the other forums

Moderators: mahlemiut, seymour, QRS

User avatar
Cicca
MARP Knight
MARP Knight
Posts: 214
Joined: Tue Apr 09, 2002 11:56 am
Location: Italy
Contact:

Database problem

Post 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
User avatar
mahlemiut
Editor
Posts: 4187
Joined: Mon Feb 04, 2002 10:05 pm
Location: New Zealand
Contact:

Re: Database problem

Post by mahlemiut »

If it can't find MySQL, then it seems like a server issue. Not much can be done.
- Barry Rodewald
MARP Assistant Web Maintainer
Image
User avatar
Cicca
MARP Knight
MARP Knight
Posts: 214
Joined: Tue Apr 09, 2002 11:56 am
Location: Italy
Contact:

Re: Database problem

Post by Cicca »

Still broken.....who this issue could be addressed to...?! Who's hosting the server...?!
User avatar
seymour
Site Admin
Posts: 241
Joined: Mon Feb 04, 2002 2:59 pm
Location: Newfoundland, Canada

Re: Database problem

Post 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 ;)
Chris Gushue
MARP IRC/Forum Maintainer
http://gushue.net
User avatar
mahlemiut
Editor
Posts: 4187
Joined: Mon Feb 04, 2002 10:05 pm
Location: New Zealand
Contact:

Re: Database problem

Post 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.
- Barry Rodewald
MARP Assistant Web Maintainer
Image
User avatar
seymour
Site Admin
Posts: 241
Joined: Mon Feb 04, 2002 2:59 pm
Location: Newfoundland, Canada

Re: Database problem

Post 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
Chris Gushue
MARP IRC/Forum Maintainer
http://gushue.net
User avatar
mahlemiut
Editor
Posts: 4187
Joined: Mon Feb 04, 2002 10:05 pm
Location: New Zealand
Contact:

Re: Database problem

Post 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.
- Barry Rodewald
MARP Assistant Web Maintainer
Image
ChrisP
Button Slapper
Button Slapper
Posts: 9
Joined: Mon Jul 08, 2013 10:02 pm

Re: Database problem

Post 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.
User avatar
Cicca
MARP Knight
MARP Knight
Posts: 214
Joined: Tue Apr 09, 2002 11:56 am
Location: Italy
Contact:

Re: Database problem

Post 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....
User avatar
Cicca
MARP Knight
MARP Knight
Posts: 214
Joined: Tue Apr 09, 2002 11:56 am
Location: Italy
Contact:

Re: Database problem

Post 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.....
User avatar
seymour
Site Admin
Posts: 241
Joined: Mon Feb 04, 2002 2:59 pm
Location: Newfoundland, Canada

Re: Database problem

Post 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.
Chris Gushue
MARP IRC/Forum Maintainer
http://gushue.net
User avatar
Weehawk
MARPaholic
MARPaholic
Posts: 2558
Joined: Wed Jun 25, 2003 7:43 am
Location: Devil's Canyon
Contact:

Re: Database problem

Post 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
John Cunningham (JTC)
Image
Zerstorung
Button Masher
Button Masher
Posts: 67
Joined: Tue Sep 08, 2009 4:15 pm

Re: Database problem

Post 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.
User avatar
Cicca
MARP Knight
MARP Knight
Posts: 214
Joined: Tue Apr 09, 2002 11:56 am
Location: Italy
Contact:

Re: Database problem

Post by Cicca »

Weehawk wrote: Mon Apr 08, 2024 5:30 pm 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
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....
Chufoglu
MARP Serf
MARP Serf
Posts: 135
Joined: Fri Apr 28, 2006 7:45 am
Location: Madrid, Spain

Re: Database problem

Post by Chufoglu »

The best replay site in the world should not die, it would be a tragedy...
Post Reply