Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: mic_comte on November 05, 2021, 04:57:20 AM

Title: Cannot login to my forum
Post by: mic_comte on November 05, 2021, 04:57:20 AM
 Hello,
My old forum is still running on SMF 1.1.19, and since yesterday I cannot login anymore:
http://forum.braquedubourbonnais.info/index.php?language=french-utf8

The failing part is here:

In LogInOut.php, this test condition is false:

      // Challenge passed.
      elseif ($_REQUEST['hash_passwrd'] == sha1($user_settings['passwd'] . $sc))
         $sha_passwd = $user_settings['passwd'];

The site is hosted on Godaddy.

Any idea?

Title: Re: Cannot login to my forum
Post by: Dzonny on November 05, 2021, 06:25:40 AM
Hello there.

Did you made any changes on forum, ie new mods added or anything?
Also can you tell us what is happening when you try to login, which error you're getting? Anything in error log?
Which php version you're on?

I assume that you're aware that 1.1.x branch is quite outdated and it's anyway highly suggested to upgrade to newer branch. ;)
Title: Re: Cannot login to my forum
Post by: mic_comte on November 05, 2021, 07:09:17 AM
 Yes I am aware it is outdated, but for this low activity forum, I would like to keep it online at the lowest cost.

 The message I get is that the password is wrong.

 And indeed, I made an echo of $_REQUEST['hash_passwrd'], sha1($user_settings['passwd'] and $sc, the test is failling.

 The PHP version is this one:


PHP Version 5.4.19
Title: Re: Cannot login to my forum
Post by: shadav on November 05, 2021, 12:06:24 PM
you can try
https://wiki.simplemachines.org/smf/Administration_-_I_accidentally_lost_my_admin_account!_What_can_I_do
at the bottom of the page
Resetting the Password of an Admin User

Quote from: mic_comte on November 05, 2021, 07:09:17 AMYes I am aware it is outdated, but for this low activity forum, I would like to keep it online at the lowest cost.

sorry but I don't understand this statement, smf is free
staying on an outdated version leaves your site open to known security issues and possibly hacking

Quote from: mic_comte on November 05, 2021, 07:09:17 AMPHP Version 5.4.19
this surprises me as most hosts are ditching php 5.x or anything under 7.2
Title: Re: Cannot login to my forum
Post by: Sir Osis of Liver on November 05, 2021, 01:30:47 PM
GoDaddy has some really old servers that haven't been updated in years, not unusual to see a 1.1 forum running on one of these clunkers.
Title: Re: Cannot login to my forum
Post by: mic_comte on November 05, 2021, 01:57:45 PM
Quote from: mic_comte on November 05, 2021, 07:09:17 AMYes I am aware it is outdated, but for this low activity forum, I would like to keep it online at the lowest cost.

I am not speaking of money but of time.
Title: Re: Cannot login to my forum
Post by: mic_comte on November 05, 2021, 02:39:57 PM
Quote from: shadav on November 05, 2021, 12:06:24 PMyou can try
https://wiki.simplemachines.org/smf/Administration_-_I_accidentally_lost_my_admin_account!_What_can_I_do
at the bottom of the page
Resetting the Password of an Admin User

 I don't think it is the problem, none of the passwords work since yesterday.
Title: Re: Cannot login to my forum
Post by: shadav on November 05, 2021, 02:58:41 PM
if no one's passwords are working, sounds more like you were hacked
have you noticed any suspicious files on your site(s)?

check your server logs

sorry but the only real advice I can give is to
1) make sure there aren't any rogue files or codes in any files on your site
2) check your server logs
3) update to the latest stable version of smf, currently 2.0.18
4) reset yours and everyone's passwords
6) make sure there's not a rogue admin account that a hacker might have created
7) have everyone change their passwords
8 ) move away from godaddy as they are known for having all sorts of issues
Title: Re: Cannot login to my forum
Post by: Kindred on November 05, 2021, 03:10:02 PM
potentially, since this is GODaddy, they might have changed something on the server (mySQL version or settings) which causes your system to fail.

You need to
1- leave goDaddy
2- Upgrade to 2.0.18

It's not a matter of cost (even time) -- are you willing to leave your system WITH KNOWN SECURITY HOLES? (Holes that have since been patched in the 2.0 releases)

A 30 minute update can save you a world of hurt.
Title: Re: Cannot login to my forum
Post by: mic_comte on November 05, 2021, 04:54:37 PM
 30 minutes to change provider and upgrade to 2.0.18? You are optimistic...

 Where do you htink I should go instead of Godaddy?
Title: Re: Cannot login to my forum
Post by: shadav on November 05, 2021, 05:28:55 PM
Quote from: mic_comte on November 05, 2021, 04:54:37 PM30 minutes to change provider and upgrade to 2.0.18? You are optimistic...

 Where do you htink I should go instead of Godaddy?
not really, log into your hosting account get a full backup (files and database)

signup for a new host, create database, install backups (or ask new host to migrate your site for you, this might take some time yes)

download and run repair_settings tool to point all urls and paths to new server: https://wiki.simplemachines.org/smf/Repair_settings.php/en

download the 2.0.18 Large upgrade: https://download.simplemachines.org/ install files over existing smf files (except for settings.php), run the update, boom you're done
(in all honesty you may not even need your old files other than the settings.php, but I could be wrong there)

as for hosting, that would depend on what all you are looking for
I suggest either https://www.icdsoft.com/ or https://www.a2hosting.com/

you can also check through the threads in the Hosts, Hosting and Commercial Services (https://www.simplemachines.org/community/index.php?board=4.0) boards and their sub boards

stay away from godaddy and hostgator
they've had too many issues over the years

basically don't use any hosts listed here
https://researchasahobby.com/full-list-eig-hosting-companies-brands/

[edit]
then again considering you're on smf 1.x it would probably be better to update first because as stated most hosts have done away with php 5.x
so update first then grab a full backup of your files and database from hosting account then move it to the new host, then run the repair settings tool
and now you are on a stable release of smf, on a better host, and on the latest stable php version (7.4)
Title: Re: Cannot login to my forum
Post by: mic_comte on November 07, 2021, 10:49:11 AM
 Hi,
I will try to setup a new SMF2.1 and import my database first and see if it works.

I will loose the customisations I did, but it is not a big deal.

Because I have a whole site with the forum, with hundreds of subdomains, etc... it is not so easy to move.

Thanks for your help.

Best regards
Michael
Title: Re: Cannot login to my forum
Post by: Sir Osis of Liver on November 07, 2021, 05:58:47 PM
Crocweb support will migrate your GoDaddy account using cpanel backup, directory structure will be exactly the same.  You'll have access to the new install using direct server links so you can check everything and make any necessary adjustments before updating nameservers and going live.  Your forum and any other sites you have will continue running on GD until you do dns update.

Title: Re: Cannot login to my forum
Post by: mic_comte on November 08, 2021, 04:34:29 AM
Ok, thanks.

Now one thing, I made a new installation with smf_2-0-18_install.zip and imported my old 1.1 database.

http://www.braquedubourbonnais.info/forum2/install.php

Should I download the upgrade.php and execute it to make necessary changes to my database?
Title: Re: Cannot login to my forum
Post by: Doug Heffernan on November 08, 2021, 04:47:06 AM
Quote from: mic_comte on November 08, 2021, 04:34:29 AMOk, thanks.

Now one thing, I made a new installation with smf_2-0-18_install.zip and imported my old 1.1 database.

http://www.braquedubourbonnais.info/forum2/install.php

Should I download the upgrade.php and execute it to make necessary changes to my database?


Yes, you should run the upgrade to upate the database to 2.0.18. Is that the url of your live forum btw or a test forum that you installed to do a dry run of the upgrade?
Title: Re: Cannot login to my forum
Post by: mic_comte on November 08, 2021, 05:12:24 AM
 This is a test but will become the next forum once it works:
http://www.braquedubourbonnais.info/forum2/install.php

 The original forum is here:
http://forum.braquedubourbonnais.info/index.php?language=english

 So, I will upload the upgrade.php here and run it first: http://www.braquedubourbonnais.info/forum2


Title: Re: Cannot login to my forum
Post by: Doug Heffernan on November 08, 2021, 05:14:52 AM
Quote from: mic_comte on November 08, 2021, 05:12:24 AMThis is a test but will become the next forum once it works:
http://www.braquedubourbonnais.info/forum2/install.php

 The original forum is here:
http://forum.braquedubourbonnais.info/index.php?language=english

 So, I will upload the upgrade.php here and run it first: http://www.braquedubourbonnais.info/forum2


Another thing that you must do after the forum is upgraded, is to run the repair_settings.php tool to straighten out the paths and url as they will point to the original forum.

Good luck with the upgrade and keep us posted.
Title: Re: Cannot login to my forum
Post by: mic_comte on November 08, 2021, 06:54:52 AM
 I have uploaded upgrade.php and all the sql files (upgrade_1-0.sql, etc...)

But now when I try to execute http://www.braquedubourbonnais.info/forum2/upgrade.php

I am directly rerouted to http://www.braquedubourbonnais.info/forum2/install.php

Title: Re: Cannot login to my forum
Post by: mic_comte on November 08, 2021, 07:02:31 AM
 The files I have in forum2 are extracted from smf_2-0-18_install.zip

Should I replace them with those from smf_2-0-18_upgrade.zip? (except Setting.php of course)
Title: Re: Cannot login to my forum
Post by: Kindred on November 08, 2021, 07:41:29 AM
They are the same files, except for the sql....  delete the ihstall.php
Title: Re: Cannot login to my forum
Post by: mic_comte on November 08, 2021, 08:25:48 AM
I a stuck in the step below (Step 4: Database Changes).




SMF Upgrade UtilitySimple Machines Forum
Progress
Step 1: Login
Step 2: Upgrade Options
Step 3: Backup
Step 4: Database Changes
Step 5: Delete Upgrade
14%
 
Overall Progress
0.2%
 
Step Progress
Time Elapsed: 11 mins, 11 seconds.
Database Changes
Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 3.
Executing: "Creating new tables and inserting default data..." (1 of 8 - of this script)

!!Error!
Server has not responded for 30 seconds. It may be worth waiting a little longer or otherwise please click here to try this step again
Title: Re: Cannot login to my forum
Post by: Doug Heffernan on November 08, 2021, 08:25:54 AM
Quote from: mic_comte on November 08, 2021, 07:02:31 AMThe files I have in forum2 are extracted from smf_2-0-18_install.zip

Should I replace them with those from smf_2-0-18_upgrade.zip? (except Setting.php of course)

That is not necessary. All you have to do, as mentioned above, is delete the install.php file and upload the upgrade.php file and sql files from the large 2.0.28 upgrade package and then run the upgrader.
Title: Re: Cannot login to my forum
Post by: Doug Heffernan on November 08, 2021, 08:29:07 AM
Quote from: mic_comte on November 08, 2021, 08:25:48 AMI a stuck in the step below (Step 4: Database Changes).




SMF Upgrade UtilitySimple Machines Forum
Progress
Step 1: Login
Step 2: Upgrade Options
Step 3: Backup
Step 4: Database Changes
Step 5: Delete Upgrade
14%
 
Overall Progress
0.2%
 
Step Progress
Time Elapsed: 11 mins, 11 seconds.
Database Changes
Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 3.
Executing: "Creating new tables and inserting default data..." (1 of 8 - of this script)

!!Error!
Server has not responded for 30 seconds. It may be worth waiting a little longer or otherwise please click here to try this step again

As it says, wait a few minutes first and see what happens. How large is your database btw?
Title: Re: Cannot login to my forum
Post by: mic_comte on November 08, 2021, 08:32:06 AM
The *.sql of y database is 160 mb
Title: Re: Cannot login to my forum
Post by: Kindred on November 08, 2021, 09:26:26 AM
that's relatively small....   it will take a few refreshes that's all.

I converted a forum with over 2 gigabytes in the database.   That took over 24 hours. :D
Title: Re: Cannot login to my forum
Post by: mic_comte on November 08, 2021, 10:52:45 AM
It does not seem to be moving. Should I click on Continue?

SMF Upgrade UtilitySimple Machines Forum
Progress
Step 1: Login
Step 2: Upgrade Options
Step 3: Backup
Step 4: Database Changes
Step 5: Delete Upgrade
14%
 
Overall Progress
0.2%
 
Step Progress
Time Elapsed: 158 mins, 24 seconds.
Database Changes
Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 3.
Executing: "Creating new tables and inserting default data..." (1 of 8 - of this script)

!!Error!
Server has not responded for 30 seconds. It may be worth waiting a little longer or otherwise please click here to try this step again
Title: Re: Cannot login to my forum
Post by: Sir Osis of Liver on November 08, 2021, 11:55:12 AM
2.0 upgrade will not run on some of GoDaddy's older servers (they're that bad :P).  I've done several upgrades where I had to export the db, upgrade it on my server, then import it back to GD server.  You may have to upgrade after moving to new host.
Title: Re: Cannot login to my forum
Post by: mic_comte on November 08, 2021, 02:25:31 PM
Hi,
In the background I see those warnings:

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/content/29/3600029/html/forum2/upgrade.php on line 886

Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /home/content/29/3600029/html/forum2/upgrade.php on line 888

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/content/29/3600029/html/forum2/upgrade.php on line 1574

Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /home/content/29/3600029/html/forum2/upgrade.php on line 1576