Jump to content

OSCNewbie2

Members
  • Content count

    18
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks for the replies, much appreciated. We found out from the hosting provider the next day, they had moved the entire website and store to another hosting provider without advising my friend about it or asking her if she wanted it moved. We think that was the problem, we caught it in the middle of the move. Anyway NOW the problem is that we need to get into cPanel to make certain changes and to be able to update the SSL when it comes due, do backups etc, and when we asked for the new cPanel log-on info, her hosting company emailed her with this - "Our new server is not having Capnel, it's a highly scalable cloud server with bare Linux OS without any panel." Sounds suspect to me, I've never heard of a commercial web hosting provider that didn't offer some sort of management panel for users to tap in to, but I might be wrong as I always had web hosting accounts for multiple websites, and not just one site like this one my friend has. The site is now up and running on the new web host, and Builtwith.com say's it's Digital Ocean, but other WhatTech sites say it's hostgator, may they're the same thing now. Right now I'm trying to figure out how to check if cPanel is running the back of a site. Without access to the back-end / cPanel, we can't easily make some of the backups we need to do, plus other changes to some of the content and installing the SSL. If there's a tech guru here who can run a test to see if cPanel is on a certain IP address or website, that would help when we discuss this with the hosting provider. All this just reinforces our idea of why we need to move this site from overseas to a good hosting platform here in the USA. And then after the holidays, to a new ecommerce platform. Any suggestions welcome, many thanks..
  2. So now about an hour later, the database is back up without us doing anything. Go figure!
  3. Hi All, So after running OK for months, my friend's osCommerce site has suddenly gone down and we only get this message - "Unable to connect to database server!" The server is running - osCommerce V v2.3.4 PHP Version 7.0.33 MySQL Version 5.6.49 Architecture x86_64 Operating System linux Disk Usage - 3.36 GB / 9.28 GB (36.23%) MySQL® Disk Usage - 1.11 GB / 7.03 GB (15.81%) Bandwidth - 29.42 MB / 39.06 GB (0.07%) When I hit the "Check Database" button under the "MySQL® Databases" page in cPanel, I got this error message - "There was a problem checking the database “tymbada8_osc1”. The request failed. (Error ID: 7mwjh2) Ask your hosting provider to research this error in cPanel & WHM’s main error log. " So then I went to cPanel->Metrics->Errors and I found this - "HP Warning: mysqli_connect(): (08004/1040): Too many connections in /home/tymbada8/public_html/includes/functions/database.php on line 20" I then downloaded that database.php file and had a look at it, and on line 20 is this - "$$link = mysqli_connect($server, $username, $password, $database);" I've looked through the archives on the forum for an answer, but can't find a clear solution. I've also looked at the configuration.php and configure.php files on the server and can't seem to find anything wrong with those either, but bear in mind that I'm an osCommerce newbie, not a coder, and it's possible that I missed something. I can log in to the cPanel account no problem, but I don't have the user and password to log in to phpMyAdmin, or if I did I can't find them at the mo. Before we call the ho$ting company for help, does anyone have any ideas? Wld be appreciated, thanks.
  4. OSCNewbie2

    HOW TO INSTALL "LET'S ENCRYPT" SSL IN OSCOMMERCE v2.3.4?

    Gotcha thanks! I'm not a part of that Phoenix group yet and hadn't planned to upgrade this site to Phoenix, because I believe this install has some custom changes made to various files which might break if we upgrade. But I'm doing the research to see what I can find to check out the best options.
  5. OSCNewbie2

    HOW TO INSTALL "LET'S ENCRYPT" SSL IN OSCOMMERCE v2.3.4?

    @JcMagpie - thanks for that info, I think we got that fixed now 🙏🏼
  6. OSCNewbie2

    HOW TO INSTALL "LET'S ENCRYPT" SSL IN OSCOMMERCE v2.3.4?

    ecartz you da man! (or woman!) I made the changes you suggested and it looks like those fixed everything - - no more “product not found” messages - no more “insecure” pages (or parts of them) - and the test PayPal payment I just made, went through without a hitch. I really appreciate your help. Where’s your tip jar?! I told my friend she owes you.
  7. OSCNewbie2

    HOW TO INSTALL "LET'S ENCRYPT" SSL IN OSCOMMERCE v2.3.4?

    MADE SOME PROGRESS! OK, I tried to make all the changes you suggested, BUT I might have missed the https changes you mentioned, I couldn’t quite figure out where I needed to make those edits. I HAVE ATTACHED THE CURRENT .htaccess file for reference. WEBSITE STATUS NOW: 1) ADMIN LOGIN PROBLEM SEEMS TO BE FIXED! 🎉 I made all the changes I could from your last suggestions, and now I can log in to admin without any apparent problem from any browser. Thank you! PROBLEMS STILL HAPPENING - 2) SECURITY WARNING: After installing the Let’s Encrypt SSL over a week ago and getting NO apparent security errors that we could easily detect after it was installed, now suddenly I’m getting “This is a non-secure form” message when I try to add something to the cart, UNLESS I’m using Chrome, then there’s no warning. (Screenshort attached). 3) PROUCT NOT FOUND WHEN USING DESKTOP OR LAPTOP BROWSER: WHEN ON A DESKTOP OR LAPTOP: In addition to the security warning mentioned above, if I click through the security warning, it now returns a “product not found” response and nothing is added to the cart. This seems to happen with every product IF one is using a desktop or laptop browser. WHEN ON AN IPHONE: There is no security warning and one can add the product to the cart, no problem. 😮 4) PAYMENT GLITCH: The PayPal payment now has apparently stopped working and seems to be hung up. This may have happened when I installed Let’s Encrypt as only one order was received through the store on March 8th since I installed Let’s Encrypt, and that’s the order with the payment problem. Apparently a customer made a payment, but no payment was received in the owners PayPal account. [We have “PayPal website payments standard” set up and connected, and it was working before I installed Let’s Encrypt.] OK so that’s where we’re at. To bed here now, will check back tomorrow Saturday morning EST USA. Any help or suggestions would be very much appreciated. THANK YOU 🙏 htaccess
  8. OSCNewbie2

    HOW TO INSTALL "LET'S ENCRYPT" SSL IN OSCOMMERCE v2.3.4?

    OK many thanks for all that! I was about to post a long list of issues, but let me try your suggestions right now (hopefully I'll be able to figure all that out lol) and see what happens. I'll be back here shortly (with a bit of luck).
  9. OSCNewbie2

    HOW TO INSTALL "LET'S ENCRYPT" SSL IN OSCOMMERCE v2.3.4?

    to ecartz - 😖 Question deleted, found the answer myself
  10. OSCNewbie2

    HOW TO INSTALL "LET'S ENCRYPT" SSL IN OSCOMMERCE v2.3.4?

    Thanks very much for the suggestions, certainly appreciated, will try the first three suggestions and see what I can do. I'm going to leave making the backups and changes to the administrators table for later as I'm not 100% confident about doing those. You may be right about the browser issue - the owner of the site CAN still log in as the Store Administrator if she uses Windows Explorer, but not if she uses Chrome of FireFox. I don't have Win Explorer on my Mac (only Safari, Chrome & FireFox) so I can't try that, and I long since deleted Explored off my old MS PC which is still running WindowsXP . FYI I'm attaching the ,htaccess file for reference from the public_html/ folder, in the format it was BEFORE I made your suggested changes. [I've made a notation in there above the three lines that I added - "#These three lines are what I added on March 7th 2020"] As you suggested, I will remove the following "RewriteEngine On" which is below my new three lines that I input, and see what happens. Also - what about all those references to the "pki-validation" which you can see further down repeated a few times? I believe those were for the previous versions of the SSL, which was a COMODO SSL, and were installed and updated by the hosting company, before I got involved. Maybe I should delete al of those too, to clean up he file generally? Thank you! htaccess
  11. OSCNewbie2

    HOW TO INSTALL "LET'S ENCRYPT" SSL IN OSCOMMERCE v2.3.4?

    HELP! I GOT SSL INSTALLED BUT BROKE ACCESS TO THE ADMIN LOG ON OK, so I carefully followed the instructions from sslforfree dot com and got Let's Encrypt installed without too much trouble, as you can see here - https://www.tymbercreekfabrics.com BUT now we lost access to the Admin page at - https://www.tymbercreekfabrics.com/tymberadmin/login.php When we try to log in as usual, we just get kicked back to the login page again. Part of the Let's Encrypt SSL install process was adding the following lines to the TOP of the ,htaccess file in the public_html folder, as instructed per the video I followed - RewriteEngine On RewriteCond %{SERVER_PORT} 80 RewriteRule ^(.*)$ https://tymbercreekfabrics.com/$1 [R=301,L] There is a lot of other stuff in that .htaccess file though, but that's all now BELOW the above three lines. I didn't want to change or delete any of that without knowing what it does. I read all the instructions and suggestions at - topic/362064-unable-to-access-admin-after-adding-ssl-cert/ but the only changes I could see that might have been required (and which I did) was making these changes in the public_html/includes/configure.php file - define('HTTP_SERVER', 'https://mysite.com'); to define('HTTP_SERVER', 'http://mysite.com'); But that didn't change anything and we still can't log in to Admin. If any one can tell us why we lost Admin Access after installing the SSL Certificate, that would be appreciated, thank you!
  12. OSCNewbie2

    HOW TO INSTALL "LET'S ENCRYPT" SSL IN OSCOMMERCE v2.3.4?

    Thanks very much for that feedback, let me dive into that right now and see what I can do. I'll post the outcome or progress here. Thanks again!
  13. Hi folks, I'm trying to figure out how to install the free SSL certificate "Let's Encrypt" into an existing osCommerce v2.3.4 installation that had a COMODO SSL certificate in it.. Have searched the forum and cannot find anything that specifically deals with this question. (I have installed the Let's Encrypt into a WordPrss website before, so I have some idea how it works, but not with osCommerce.) I have FTP and cPanel access. Any help much appreciated, thanks! os Newbie in Florida
×