Forum


Thousands of hits on the Jomres sessions is destroying my site....

More
1 month 5 days ago #47638 by Maurice Frinchaboy
Hello,

I have been using Jomres on a test site for some time, but since the latest addon for syndicated properties, there have been THOUSANDS of error messages sent to me ! Apparently lots of he sites that are in the syndication have errors, and they are passed along to me when the site tries to visit them.
Second problem, the rediculous amounts of hits that are causing my site to shutdown, as the sessions DB is being filled beyond capacity.

My site is now bugged, as I needed to remove the sessions DB or the webserver would stop. Anyone else having this issue.....???

Thanks !

Please Log in or Create an account to join the conversation.

More
1 month 5 days ago #47639 by Vince Wooll
First, make sure that you're running the most recent version of the system, there are changes to how those errors are captured.

If you can't/wont update, go to

github.com/WoollyinWalesIT/jomres/tree/n.../core-minicomponents

and search for "cron_synd" in your browser and download the 4 files there, they're the most up-to-date versions of the cron files.

As for the sessions, is the session cleanup cron job being run reliably? You can see in the Settings > Site Configuration > Cron jobs tab. Look at the bottom, it'll tell you the last time the sessions cleanup task was run. Sessions over a day old should be deleted.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
1 month 4 days ago #47641 by Maurice Frinchaboy
I forgot to mention, the test site is a Joomla. I don't see the cron tab.... And I have deleted Jomres, now I can't reinstall it, it says :
Error
Unable to find install package
Using direct download, upload, any way same error.....

Please Log in or Create an account to join the conversation.

More
1 month 4 days ago #47643 by Vince Wooll
What method are you using to do the re-installation?

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
1 month 4 days ago #47644 by Vince Wooll
Try install from web, does that work?

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
3 weeks 1 day ago #47652 by Maurice Frinchaboy
Been there done that.... Web, download, nothing seems to work.....

Please Log in or Create an account to join the conversation.

More
3 weeks 1 day ago #47653 by Maurice Frinchaboy
I get the message :
Error
Unable to find install package

Please Log in or Create an account to join the conversation.

More
2 weeks 6 days ago #47654 by Vince Wooll
Please raise a ticket, I'll look into it for you.

tickets.jomres.net/

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
2 weeks 6 days ago #47658 by Maurice Frinchaboy
Thanks, I managed to install Jomres again. I had to delete ALL the old files.... So far; no more exploding emails from errors. Seemed there where bots who kept sending error messages because the affiliate sites where down..... I will try to post a copy of the mails if they return !

Please Log in or Create an account to join the conversation.

More
2 weeks 6 days ago #47659 by Vince Wooll
Which reminded me to commit this change

github.com/WoollyinWalesIT/jomres/commit...cd3580dc6f94d36111a0

It needs a new release and sites to update, but the purpose of the exercise is to not trigger scheduled tasks if the visitor is a bot/crawler. That should reduce the overhead in the longer term.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
2 weeks 18 hours ago #47676 by Maurice Frinchaboy
Well, after some issues with my server, I am back with more info.
My DB _jomres_sessions shows 18 MEGABYTES of data, and is shutting my site down ! Here are a couple of samples :
{"info":{"ip":"0.0.0.0","user_agent":"Jomres"},"tmpbooking":{"requestedRoom":"","rate_pernight":"","variancetypes":"","varianceuids":"","varianceqty":"","variancevals":"","variancevals_nodiscount":"","lastminute_id":"","agent_booking":"","arrivalDate":"","departureDate":"","stayDays":"","dateRangeString":"","guests_uid":"","property_uid":"","rates_uid":"","tag":"","resource":"","single_person_suppliment":"","deposit_required":"","contract_total":"","extrasvalue":"","extrasvalues_items":"","extras":"","extrasquantities":"","third_party_extras":"","third_party_extras_private_data":"","room_allocations":"","room_allocations_note":"","total_discount":"","booking_discounted":false,"depositpaidsuccessfully":false,"tax":"","booker_class":"","ok_to_book":"","beds_available":"","referrer":"","error_log":"","total_in_party":"","room_total":"","room_total_nodiscount":"","lang":"","timestamp":"","wisepricediscount":"","lastminutediscount":"","confirmationSeen":false,"mininterval":"","discounts":[],"coupon_id":"","coupon_code":"","coupon_details":[],"coupon_discount_value":"","cfg_showExtras":false,"booking_notes":[],"additional_line_items":"","booking_number":0,"room_feature_filter":"","override_room_total":null,"override_deposit":null,"property_currencycode":null,"booked_in":0,"sendGuestEmail":true,"sendHotelEmail":true,"secret_key_payment":false,"channel_manager_booking":0},"cart_data":[],"tmpguest":{"guests_uid":"","mos_userid":0,"existing_id":"","firstname":"","surname":"","house":"","street":"","town":"","region":"","country":"","postcode":"","tel_landline":"","tel_mobile":"","tel_fax":"","property_uid":"","email":"","discount":"0","tag":"","timestamp":""},"tmpsearch_data":{"jomsearch_availability":"","jomsearch_availability_departure":""},"tmplang":{"jomreslang":"en-GB"},"user_settings":{"editing_on":false,"property_management_view":false,"last_viewed_property_uid":0,"geolocated_country":"--","current_exchange_rate":"EUR"}}

and

{"info":{"ip":"0.0.0.0","user_agent":"GuzzleHttp641 curl7660 PHP7133"},"tmpbooking":{"requestedRoom":"","rate_pernight":"","variancetypes":"","varianceuids":"","varianceqty":"","variancevals":"","variancevals_nodiscount":"","lastminute_id":"","agent_booking":"","arrivalDate":"","departureDate":"","stayDays":"","dateRangeString":"","guests_uid":"","property_uid":"","rates_uid":"","tag":"","resource":"","single_person_suppliment":"","deposit_required":"","contract_total":"","extrasvalue":"","extrasvalues_items":"","extras":"","extrasquantities":"","third_party_extras":"","third_party_extras_private_data":"","room_allocations":"","room_allocations_note":"","total_discount":"","booking_discounted":false,"depositpaidsuccessfully":false,"tax":"","booker_class":"","ok_to_book":"","beds_available":"","referrer":"","error_log":"","total_in_party":"","room_total":"","room_total_nodiscount":"","lang":"","timestamp":"","wisepricediscount":"","lastminutediscount":"","confirmationSeen":false,"mininterval":"","discounts":[],"coupon_id":"","coupon_code":"","coupon_details":[],"coupon_discount_value":"","cfg_showExtras":false,"booking_notes":[],"additional_line_items":"","booking_number":0,"room_feature_filter":"","override_room_total":null,"override_deposit":null,"property_currencycode":null,"booked_in":0,"sendGuestEmail":true,"sendHotelEmail":true,"secret_key_payment":false,"channel_manager_booking":0},"cart_data":[],"tmpguest":{"guests_uid":"","mos_userid":"","existing_id":"","firstname":"","surname":"","house":"","street":"","town":"","region":"","country":"","postcode":"","tel_landline":"","tel_mobile":"","tel_fax":"","property_uid":"","email":"","discount":"0","tag":"","timestamp":""},"tmpsearch_data":{"jomsearch_availability":"","jomsearch_availability_departure":""},"tmplang":{"jomreslang":"en-GB"},"user_settings":{"editing_on":false,"property_management_view":false,"last_viewed_property_uid":0}}

Some help would be great, I can't come twice a day and empty the sessions DB out..... Is there an automated fix maybe ?

Please Log in or Create an account to join the conversation.

More
2 weeks 18 hours ago #47677 by Vince Wooll
Did you read my last reply?

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
2 weeks 18 hours ago #47678 by Maurice Frinchaboy
I should add that the _session DB is at 13 megas......!!!

All with Jomres related spam......

Please Log in or Create an account to join the conversation.

More
2 weeks 18 hours ago #47679 by Maurice Frinchaboy
That is going to be implemented, but is not yet production, correct ?

Please Log in or Create an account to join the conversation.

More
2 weeks 18 hours ago #47680 by Vince Wooll
I don't think it is, yet, but there's no reason why you can't add the change manually and confirm if it resolves the issue for you. That's why I posted it here, I want to know if it has been successful for you.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
2 weeks 17 hours ago #47681 by Maurice Frinchaboy
How do I implement that? I used to code phpNuke, but it's been a long time lol :!:

Please Log in or Create an account to join the conversation.

More
2 weeks 16 hours ago #47683 by Vince Wooll
Click on Show 1 file

That tells you the file that was modified, and you can already see the line, so just change that line in your copy of jomres.php in the /jomres/ directory.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
1 week 6 days ago #47686 by Maurice Frinchaboy
Done. I will follow the DB and let you know of hat helped !

Please Log in or Create an account to join the conversation.

More
1 week 5 days ago #47689 by Maurice Frinchaboy
Well.... Any idea what GuzzleHttp641 is ? They have left another 15 mega in jomres_session in less than 24 hours..... I need to do something, its blowing up my DB.....

Please Log in or Create an account to join the conversation.

More
1 week 1 day ago #47690 by Vince Wooll
Those sessions should be deleted after 24 hours, I wouldn't worry too much about them.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
1 week 1 day ago #47691 by Maurice Frinchaboy
Well, no..... This weekend I was up to 50mb of session data, website shut down..... This is a real problem now, my website lasts 24 hhours before it is too loaded with session data and my DB is closed off to read only.....! :(

Please Log in or Create an account to join the conversation.

More
1 week 1 day ago #47692 by Vince Wooll
Are you still seeing rows where the IP number is 0.0.0.0 ?

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
1 week 1 day ago #47693 by Maurice Frinchaboy
Looks that way.....
{"info":{"ip":"0.0.0.0","user_agent":"GuzzleHttp641 curl7620 PHP7131"},"tmpbooking":
The following user(s) said Thank You: Ally

Please Log in or Create an account to join the conversation.

More
1 week 1 day ago #47694 by Ally
Sessions table growth 130+ records per 5 minutes =1560per hour = 37,440 per day.

I am glad I am not alone in my concerns.
The following user(s) said Thank You: Maurice Frinchaboy

Please Log in or Create an account to join the conversation.

More
1 week 1 day ago #47695 by Mirko
Same to me: The session file is deleted after 24 hours, but until this it grows up to more than 1 GB (!) - and my website has been down several times.
I have just checked it now: The last clean up was 16 hours ago and now the table has grown to 155.000 rows... all data contains the ip 0.0.0.0 with GuzzleHttp641.

Please Log in or Create an account to join the conversation.

More
1 week 22 hours ago #47696 by Maurice Frinchaboy
Mine doesn't delete, after 24 hours my site shuts down... And I am also getting massive hits on the joomla sessions DB

Please Log in or Create an account to join the conversation.

More
1 week 22 hours ago #47697 by Maurice Frinchaboy
I am trying a proven fix, old school. I added :
deny from 0.0.0.0

to the .htaccess file...... I will let you all know if it works !
The following user(s) said Thank You: Ally

Please Log in or Create an account to join the conversation.

More
1 week 21 hours ago #47699 by Maurice Frinchaboy

Please Log in or Create an account to join the conversation.

More
1 week 19 hours ago #47700 by Vince Wooll
In the sessions table, how many of them have the is_localhost flag set to 1 ?

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
1 week 18 hours ago #47702 by Maurice Frinchaboy
It appears that NONE of them do......

Please Log in or Create an account to join the conversation.

More
1 week 18 hours ago #47703 by Vince Wooll
But they have the IP number of 0.0.0.0 ?

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
1 week 18 hours ago #47704 by Ally
Here is my contribution



1,441 in just a few minutes
Attachments:

Please Log in or Create an account to join the conversation.

More
1 week 16 hours ago #47705 by Maurice Frinchaboy
For me, ALL of the lines have is_localhost flag set to 0 and the IP are all 0.0.0.0

Please Log in or Create an account to join the conversation.

More
4 days 9 hours ago #47713 by Vince Wooll
That doesn't make sense.

Localhost is 0.0.0.0 so that flag should be being set to 1. Raise a ticket please so that I can investigate that further.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
1 day 22 hours ago #47718 by Maurice Frinchaboy
Done. Hope you can help my website is offline every day now because of this issue.....

Please Log in or Create an account to join the conversation.

More
1 day 19 hours ago #47720 by Maurice Frinchaboy
Apparently since I have not yet purchased the program, they won't fix the bug. I will now remove it from my website, and look for an option that works. Good luck to the others with the same issue !

Please Log in or Create an account to join the conversation.

More
1 day 18 hours ago #47721 by Vince Wooll
I won't work on any website that doesn't have a license. If anybody else is still having issues (Ally, I know about you) please let me know.

I want to see if there's a problem with the scheduled task job not removing 0.0.0.0 IP number sessions that are greater than 1 hour old.

That said, it's important to remember that scheduled tasks, if not created as cron jobs, are triggered when the website is visited, not on a strict schedule, so if your site (for example a dev site) isn't visited at least once every hour by a client that isn't a bot, then naturally the tasks will not get triggered.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
1 day 18 hours ago #47723 by Maurice Frinchaboy
Thing is, your prog is nice, but way more than I need right now. I have also developed programs, I was the owner of PayPalNuke for PhpNuke. But I will not purchase a program that blows up my database with publicity for a hotel in Aruba.... It is a test site, not online.
The affiliate system, that"s not an interesting option for me. You may want to consider removing it. I don't see a lot of people interested in that.... Especially if it bugs...

Please Log in or Create an account to join the conversation.

More
1 day 18 hours ago #47724 by Vince Wooll
My longterm goals are much grander than being simply an affiliates scheme. Remember, I don't make any money whatsoever from it, it's for all users in the long term.

www.jomres.net/features-and-license-comp...-syndication-network

As I said before, any new feature, especially one with as many moving parts as this feature does, will have bugs. It's an inevitable part of development, as somebody with a history of development you would be well aware of that fact.

Unfortunately, everybody wants a part of my time and this job is as much about prioritising paying customers before anybody else and I have no choice but to draw the line there. My regular users know that this is one of those issues that I'll get around to resolving in time.

Follow me on twitter
Do not send me PMs, if you need to contact me use the ticket system.
Read this before you customise Jomres files

Please Log in or Create an account to join the conversation.

More
23 hours 35 minutes ago #47727 by Mirko
I still have this issue. Has anyone raised a ticket yet? If not, I will ;)

Please Log in or Create an account to join the conversation.

More
21 hours 41 minutes ago #47729 by Maurice Frinchaboy
Yes, but only if you paid for the prog. He won't help if you haven't..... Bugs are only for paid customers lol

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum

ABOUT US

vince picDeveloped and maintained by Vince Wooll, Jomres was initially conceived in early 2005 as a Mambo based solution to a client’s hotel management needs. While it wasn't originally expected to be an online booking system it quickly morphed into one as users requested more and more features.

As the number of feature requests grew Vince knew that he would need to dedicate more time to the project and in July 2005 Jomres was formally released as a commercial project. Since then, Jomres has become one of Mambo’s, and now Joomla’s, longest running projects. It has survived various versions of Mambo, then Joomla 1.0, 1.5, 1.6, 1.7, 2.5 and 3.

Aladar joined the project in 2010 after using Jomres for his own projects. He was active on the forum, helping other members of the community and eventually Vince invited him to join the team. Between 2010 and 2018 he was an integral part of the project and made many significant contributions.

Whilst not formally part of the Jomres project, Rodrigo Rocco and Vince have become firm friends. Rod is a freelancer who specialises in doing custom work for Jomres users and developing custom plugins for the system that take advantage of it's modular design. He has built many useful extensions including his fabulous Valentina Template Override Package.

Jomres and the Jomres Logo is trademarked and can't be used without written consent from the owner.

www.jomres.net is not affiliated with or endorsed by the Joomla! Project, Open Source Matters or the WordPress project. The Joomla! & WordPress names and logos are used under a limited license granted by Open Source Matters and the WordPress Projects.

© Copyright 2005 - 2018 Woollyinwales IT.