Jump to content

Problem connection ACARS


Omerr01

Recommended Posts

Hello everyone, 

In the last month Im having some weird problems with ACARS, I have smartCARS and KACARS and suddenly when the pilots wants to send their pireps into the website they getting errors. 

In smartCARS

"Pirep filling error:The virtual airlines web server didn't confirm the pirep filling property with smartcars. This doesn't always mean that the pirep wasn't filed. Please verify that the pirep was filed on the airlines website.
If it was filed, please click the cancel button on the acars tab cancel your flight. If it wasn't filed, please try again by clicking "file pirep" "

In KCARS

There is no physical error but there is some sound that the pirep isn't send to the website.

 

The weird problem in the both of them that everytime there are errors but sometimes the pirep is send to the website even with the error and sometime the pirep wasnt send to the website.

Please help me figure it out my pilots gets crazy about that. 
I thought maybe there is a problem with the host but the hosting support can't understand me if i dont give him the problem. 
Thanks everyone. 
 

Link to comment
Share on other sites

  • Moderators

You need to edit your my.cnf configuration file for your mysql server, find the fine tuning section, MAKE A BACKUP FIRST,

 

These are my settings for guidance they may not work for you so change one thing at a time and test out.

 

#
# * Fine Tuning
#
key_buffer		= 348M

max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8

key_buffer = 512M
table_cache = 1064
sort_buffer_size = 4M
read_buffer_size = 1M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 128M
query_cache_type=1
query_cache_limit=4194304
long_query_time = 3
innodb_buffer_pool_size = 3G
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 16
table_open_cache =200
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

 

Link to comment
Share on other sites

On 9/7/2019 at 6:03 PM, mark1million said:

You need to edit your my.cnf configuration file for your mysql server, find the fine tuning section, MAKE A BACKUP FIRST,

 

These are my settings for guidance they may not work for you so change one thing at a time and test out.

 


#
# * Fine Tuning
#
key_buffer		= 348M

max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8

key_buffer = 512M
table_cache = 1064
sort_buffer_size = 4M
read_buffer_size = 1M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 128M
query_cache_type=1
query_cache_limit=4194304
long_query_time = 3
innodb_buffer_pool_size = 3G
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 16
table_open_cache =200
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

 

Where I can find this file i search all over the cpanel and the ftp and i didnt found it. 

Link to comment
Share on other sites

On 9/7/2019 at 6:05 PM, mark1million said:

Install a free monitor first this really gives you an insight in to what queries are slowing your site down,

https://www.solarwinds.com/database-performance-analyzer

From what I have checked I cannot install it on my hosting company does not approve

Edited by Omerr01
Link to comment
Share on other sites

this is what the hosting supporter send to me : "On the shared hosting environment there isn't a way to tweak the my.cnf file only for a specific user. This could be done if you have a VPS or a dedicate server where you are not sharing resources with other users but you have them allocated only to you.

Could you provide me with a bit more information about the query that you are having and what those people advised you?

"

Link to comment
Share on other sites

  • Moderators

Hi, you need to comment out the event listener

 

<?php
class TopPilot extends CodonModule {
    public static $tour_center = 1; // 0:if no tour system -or- 1:for SimpilotGroup Tour Center -or- 2:for CrazyCreatives Tour Module
    public $title = 'Top Pilots';

   // public function __construct() {
      //  CodonEvent::addListener('TopPilot', array('pirep_filed'));
    //}
    public function EventListener($eventinfo) {
        if($eventinfo[0] == 'pirep_filed') {
            self::refresh_month_stats();
        }
    }

Every time a pirep is filed it recalculates the data which caused a massive delay.

 

You will then need to run a cron every hour or 5 hours to update the stats manually.

 

Give that a try if it works i can tell you how to manually run the update of stats.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...