Previous Thread
Next Thread
Print Thread
Hop To
#264965 07/21/2021 6:15 PM
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
my site, which I have had with the same host since 1997 may be dead.
they don't answer emails, their telephone is disconnected....

I have been trying to download my SQL database to have a current backup and it fails every time.. I don't know what to do. frown
this is depressing and frustrating all at the same time


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Joined: Jun 2006
Posts: 16,110
Likes: 77
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,110
Likes: 77
What provider are you currently with? Is it their web based backup tool failing? Do you have access to SSH on the machine?

I prefer to make all backups from the command line via SSH vs relying on a tool; you can see the commands on the UBBWiki guide "Backup Guide" (similar instructions are also available on the guide "Migration Guide").

Additionally, the backup utility provided by UBB.threads has come a long way in more recent versions and could be utilized to jump to another provider if need be.

But it definitely think it's likely time for a new host if you're not getting any sort of timely responses to inquiries from your existing provider.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #264967 07/21/2021 6:38 PM
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
I try to connect with PuTTy and it times out... and when I try to use the tools built into UBB it tells me I'm not authorized..? (after testing the download path and passing)


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
been with your-site.com since 97, they have always been good to me... but now, nobody is responding to emails, or tickets, phone is disconnected, half the stuff on their main page doesn't work...

Last edited by Bad Frog; 07/21/2021 6:42 PM.

"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
I sent you a PM on facebook


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Bad Frog #264970 07/22/2021 12:27 PM
Joined: Dec 2003
Posts: 6,406
Likes: 55
Offline
Joined: Dec 2003
Posts: 6,406
Likes: 55
Originally Posted by Bad Frog
been with your-site.com since 97, they have always been good to me... but now, nobody is responding to emails, or tickets, phone is disconnected, half the stuff on their main page doesn't work...
Well the sites performance is extremely acceptable to say the least.
Not sure what host or plan you are on.

Maybe the host is going through new ownership and changes

But the odd part is the internal backup tool fails.
It just runs a php script that access mysql.

What about other UBB CP validation items like attachment location and avatars. Do they pass also and do they work when posting attachments or updating avatars.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
it was acting up last week.. which is what prompted me to open a ticket... and have had no response on that, or any of the emails I have sent, the billing page is gone..

when I run the script, I test the path, it passes, says it's writable.. I start the export, it gets to the address book, and then I get
Forbidden
You don't have permission to access this resource.

the permission checks all pass


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Joined: Jun 2006
Posts: 16,110
Likes: 77
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,110
Likes: 77
I have been looking at this for several hours today and spent some time last night trying to just obtain a copy of your database...
- The UBB.threads backup utility fails after exporting some data, "You don't have permission to access this resource."
- I found and installed 3 PHP backup scripts, all error out 500 when attempting to access system commands to write a database dump
- The SQLYog tunnel provides a 1010 error, which generally would indicate a "Error dropping database" error message in MySQL (which since this is simply attempting a connection, is odd in of itself)
- PHPMyAdmin while able to edit portions of the database fails to dump even a small chunk of data, resulting in a 504 Gateway Time-out error.
- SSH doesn't allow any connections ("You do not have permission to login interactively to this host")

A possible issue could be, since your host uses a separate database server vs hosting it locally, there could be some sort of issue with the bridge between servers, the database server could be having problems, or some unknown variable is at play.

I'm not really sure how to proceed on obtaining a backup at this point if the host is unresponsive... But with the SQL server acting the way it is, I'd be very worried about the completeness of your data; if it is an issue with the SQL server you could end up with a corrupted database.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 16,110
Likes: 77
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,110
Likes: 77
Your hosts webpage indicates in the footer that its owned by a Fluidsoft, whos linkedin is here (which states their homepage is your hosts url) indicates it has 5 employees, couldn't hurt to try to contact one of them.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #264974 07/22/2021 5:25 PM
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
I have tried reaching out to anyone I can find associated with it so far, multiple different emails, phone numbers... no luck.
thank you for trying,!


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Gizmo #264975 07/23/2021 4:36 AM
Joined: Jul 2006
Posts: 113
Likes: 1
P
Member
Offline
Member
P
Joined: Jul 2006
Posts: 113
Likes: 1
Is your webhost using a webhosting control panel like cPanel? Maybe there is an option to create a backup in the control panel itself?

Originally Posted by Gizmo
I have been looking at this for several hours today and spent some time last night trying to just obtain a copy of your database...
- The UBB.threads backup utility fails after exporting some data, "You don't have permission to access this resource."
- I found and installed 3 PHP backup scripts, all error out 500 when attempting to access system commands to write a database dump
Was this 403 error? In this case this could be caused by a rule in mod_security. I have seen this quite often with various scripts. You could try to disable mod_security by adding the following lines to the .htaccess file:
Code
<IfModule mod_security.c>
SecFilterEngine Off
SecFilterScanPOST Off
</IfModule>
This is only working on Apache based installation but there may be also an option to disable mod_security in the webhosting control panel

Error 500 indicates an error in the PHP script. This could be caused by disabled PHP functions. Some webhosts are disabling PHP functions such as system() due to security or performance reasons, especially for websites hosted on a shared virtual hosting plan. If you have no access to the log files, you could try to add after <?php:
Code
error_reporting( E_ALL );
ini_set( "display_errors", "on" );
This should show the actual error message rather then just an error 500 message. Off course, only for debugging purpose wink

Joined: Jun 2006
Posts: 16,110
Likes: 77
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,110
Likes: 77
Originally Posted by Philipp
Is your webhost using a webhosting control panel like cPanel? Maybe there is an option to create a backup in the control panel itself?
User indicated the inability to generate a backup via his hosts control panel in the trouble ticket on the matter.

Originally Posted by Philipp
Was this 403 error? In this case this could be caused by a rule in mod_security. I have seen this quite often with various scripts. You could try to disable mod_security by adding the following lines to the .htaccess file:
Code
<IfModule mod_security.c>
SecFilterEngine Off
SecFilterScanPOST Off
</IfModule>
This is only working on Apache based installation but there may be also an option to disable mod_security in the webhosting control panel
As a part of general troubleshooting various UBB.threads system pages were referenced; the PHPInfo page indicated that mod_security was not loaded but this could vary based on the server handler; the Suhosin status page indicated that Suhosin was not enabled on the server. These pages were added specifically for troubleshooting issues with Suhosin or web server modules and has been a part of the UBB.threads package since at least v7.5.9 (2015).

Some basic checks using the UBB.threads System Requirements Test (also written for basic troubleshooting of the UBB.threads script) indicated no usage of suhosin on the machine or any other detectable server issues that it was designed to detect.

Disabling items in apache is only allowed on a system that allows Allowoverride to disable them, which in most shared hosting environments is not allowed.

Originally Posted by Philipp
Error 500 indicates an error in the PHP script. This could be caused by disabled PHP functions. Some webhosts are disabling PHP functions such as system() due to security or performance reasons, especially for websites hosted on a shared virtual hosting plan. If you have no access to the log files, you could try to add after <?php:
Code
error_reporting( E_ALL );
ini_set( "display_errors", "on" );
This should show the actual error message rather then just an error 500 message. Off course, only for debugging purpose wink
And as stated in my response, the 500 error was encountered only while attempting to utilize system commands.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #264977 07/24/2021 3:48 AM
Joined: Jul 2006
Posts: 113
Likes: 1
P
Member
Offline
Member
P
Joined: Jul 2006
Posts: 113
Likes: 1
Suhosin and mod_security are not the same thing wink

Suhosin was a security extension for PHP 5 and has been discontinued a long time ago.

ModSecurity is a popular extension for Apache, Nginx, and IIS webservers that is completely independent from the PHP installation: https://github.com/SpiderLabs/ModSecurity

A typical sign that mod_security is running are the infamous 403 errors. If you see this error, one of the mod_security filter rules has been triggered. Some of the stock mod_security rules are overly cautious facepalm

I don’t know which hosting control panel Bad Frog is using, but it looks like cPanel has an option to disable mod_security:

Maybe worth a try?

Bad Frog #264979 07/26/2021 11:52 AM
Joined: Jul 2006
Posts: 113
Likes: 1
P
Member
Offline
Member
P
Joined: Jul 2006
Posts: 113
Likes: 1
I just found an easy way to check whether ModSecurity is present. Just add cmd.exe somewhere in the URL.

For example: DOMAIN/forums/ubbthreads.php/cmd.exe

This will trigger one of the more ridiculous ModSecurity rules and should return 403 Forbidden on server with enabled ModSecurity. Servers without ModSecurity will ignore this.

Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
so...
I did some more detective work and actually got a working cell # for the former sysadmin..
they are supposed to call me.
but the story so far is... owner/sysadmin diagnosed with terminal cancer and they just dropped everything, but are leaving all sites on their servers up and running for free
hopefully someone does get back to me so I can get my data backed up properly.

stay tuned!!


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
Originally Posted by Philipp
I just found an easy way to check whether ModSecurity is present. Just add cmd.exe somewhere in the URL.

For example: DOMAIN/forums/ubbthreads.php/cmd.exe

This will trigger one of the more ridiculous ModSecurity rules and should return 403 Forbidden on server with enabled ModSecurity. Servers without ModSecurity will ignore this.

that results in Forbidden
You don't have permission to access this resource.


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Joined: Jul 2006
Posts: 113
Likes: 1
P
Member
Offline
Member
P
Joined: Jul 2006
Posts: 113
Likes: 1
That's Mod Security. You could try to disable it either over cPanel (if available) or .htaccess. Instructions are above smile

Mod Security can be a very powerful tool to block incoming attacks, but it need a lot of tuning/tweaking to run properly with scripts like UBB.threads.

Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
It's not a cpanel option, there are very few options there. I'll give the htaccess method a try later today


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
so adding
<IfModule mod_security.c>
SecFilterEngine Off
SecFilterScanPOST Off
</IfModule>


to my htaccess didn't help.

I get

Forbidden
You don't have permission to access this resource.

still when trying to run the backup, it gets to the address book and then kicks out that error.

where would I add that PHP snippet?

Last edited by Bad Frog; 08/05/2021 8:51 AM.

"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Bad Frog #264988 08/05/2021 10:56 AM
Joined: Jul 2006
Posts: 113
Likes: 1
P
Member
Offline
Member
P
Joined: Jul 2006
Posts: 113
Likes: 1
You can use the PHP snippet on any PHP file that you want debug. However, this will not help with Mod Security.

I just installed Mod Security on my test server and tried the UBB backup. It failed with the 403 error after the first refresh. I checked the logs and this issue is related to the dumpdir (Absolute PATH to Backup Storage Directory) field.

I found a workaround. Create a directory backup in your UBB admin directory and then use just backup as your new backup directory:
[Linked Image]

At least this solved the problem on my test server.

Philipp #264989 08/05/2021 11:58 AM
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
ok, just tried that.

var/www/virtual/v/a/vanning.com/www/threads/admin/backup/
directory test passed

backup still fails at the same point.

thanks for trying :\


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Bad Frog #264990 08/05/2021 12:19 PM
Joined: Jul 2006
Posts: 113
Likes: 1
P
Member
Offline
Member
P
Joined: Jul 2006
Posts: 113
Likes: 1
Have you used the full path (var/www/virtual/v/a/vanning.com/www/threads/admin/backup/)? Just set it to "backup" like in the screenshot.

Bad Frog #264993 08/05/2021 12:59 PM
Joined: May 2008
Posts: 753
Likes: 1
Old Hand
OP Offline
Old Hand
Joined: May 2008
Posts: 753
Likes: 1
tried both, still get forbidden when running the backup


"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"
Joined: Jun 2006
Posts: 16,110
Likes: 77
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,110
Likes: 77
Again, mod security in general cannot be disabled on most servers, it does not make sense from a security standpoint to install a security module and allow your users to disable it outright. And yes mod_security is still used to this day by shared hosts.

This was all tested weeks ago, we attempted to make backups of the full path and a virtual path with the built in tools, this was all part of standard testing with what little access is allowed on the machine.

The end result is he must obtain a backup of his MySQL database directly from the host as an SQL dump in order to migrate to another provider. There is no way we're going to be able to get this data elsewhere.

I am quite aware that executing system commands are what is proving to be the issue here, we've already exhausted all of these tests weeks ago.

All that it seems you're attempting to do is provide false hope on an already stressful situation by completely ignoring that hands on services have already been attempted in the matter and ignored by you providing the same information that's can covered on my responses on the issue.

For note, this thread is outside of the scope of UBB.threads support, it has been left as a courtesy to the user. If the same posts are going to be just repeated this thread will be locked.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #264996 08/05/2021 2:55 PM
Joined: Jul 2006
Posts: 113
Likes: 1
P
Member
Offline
Member
P
Joined: Jul 2006
Posts: 113
Likes: 1
Originally Posted by Bad Frog
tried both, still get forbidden when running the backup
Have you access to the log files? Any Mod Security error should be logged there including the exact pattern that cause the error.

Originally Posted by Gizmo
And yes mod_security is still used to this day by shared hosts.
Did I say something else? I was taking about Suhosin.

Joined: Dec 2003
Posts: 6,406
Likes: 55
Offline
Joined: Dec 2003
Posts: 6,406
Likes: 55
Another testament to why making regular full backups are important.
Looks to me that every possible method has been tried to resolve the issue.
But without the host's intervention it is not going to happen.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Cancel subscription membership
by Morgan - 09/10/2021 4:16 AM
PM email notification
by Ruben - 08/31/2021 4:21 PM
Buttons overly long
by Baldeagle - 08/26/2021 10:45 PM
Kudos to the UBB programmers
by Baldeagle - 08/22/2021 7:49 PM
Who's Online Now
0 members (), 71 guests, and 109 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5