Menu
SuiteCRM dedicated support by SalesAgility
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Brand new installation More than slow

Brand new installation More than slow 4 months 1 day ago #70398

  • MaitreCake
  • MaitreCake's Avatar
  • Offline
  • Junior Member
  • Posts: 23
  • Karma: 1
Hello,

I did a post few days ago, and did not have any reply. I can not edit it anymore and my title was not be really relevant. https://suitecrm.com/suitecrm/forum/suitecrm-7-0-discussion/20038-installation-really-really-really-slow).

By the way, I believed that my speed issue could come from old settings, so I decided to make a new installation on my OVH shared hosting. You can access it here https://www.septentriontours.com/SUITE/ .
You will see that it can take up to 3 minutes just to see the login page. On PhpMyAdmin, I can see that there is up to 3000 requests/ 5 secondes sent to the database just to display this login page.

My database has been just implemented, and I did not install any language pack or other moduls, neither any datas.

I am a kind of newby in computoring, but this one makes me crazy.

If anybody have a clue, I will be delighted.

Thx in advance

Php 7
Newbie who loves to have the last word with his computer.
_____________________________________________
Version 7.10.10

Sugar Version 6.5.25 (Build 344)

MYSQL v.5.5 PHP 7.2
The administrator has disabled public write access.

Brand new installation More than slow 3 months 3 weeks ago #70481

  • MaitreCake
  • MaitreCake's Avatar
  • Offline
  • Junior Member
  • Posts: 23
  • Karma: 1
Hello,

Up
Any help, please ?
Just a clue, may be?

Thanks
Newbie who loves to have the last word with his computer.
_____________________________________________
Version 7.10.10

Sugar Version 6.5.25 (Build 344)

MYSQL v.5.5 PHP 7.2
The administrator has disabled public write access.

Brand new installation More than slow 3 months 3 weeks ago #70576

  • MaitreCake
  • MaitreCake's Avatar
  • Offline
  • Junior Member
  • Posts: 23
  • Karma: 1
:whistle: I presume that August is not the better time of the year to have this kind of issue.

Just for your information, Joomla and Owncloud work perfectly under the same envirronement...
Newbie who loves to have the last word with his computer.
_____________________________________________
Version 7.10.10

Sugar Version 6.5.25 (Build 344)

MYSQL v.5.5 PHP 7.2
The administrator has disabled public write access.

Brand new installation More than slow 3 months 3 weeks ago #70583

  • urdhvatech
  • urdhvatech's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 468
  • Thank you received: 93
  • Karma: 15
Hello,

Have you checked the permission & correct ownership of the SuiteCRM folder?
1) Yes, it took a huge time to load login page. Maybe multiple redirect or issue with https?
2) Can you try to access directly with IP?
3) Also, check apache error log & suitecrm.log this may lead you to Investigate to the correct direction.
Thanks & Regards,
Team Urdhva Tech
Web : www.urdhva-tech.com
Skype : urdhvatech

- Official code partner
- Official Integration partner
The administrator has disabled public write access.
The following user(s) said Thank You: MaitreCake

Brand new installation More than slow 3 months 3 weeks ago #70589

  • springfielddr
  • springfielddr's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Thank you received: 1
  • Karma: 1
Are these any errors in your Apache Log? SuiteCRM logs?
$295 flat-rate data recovery with free shipping and a "no recovery, no fee" guarantee
The administrator has disabled public write access.
The following user(s) said Thank You: MaitreCake

Brand new installation More than slow 3 months 3 weeks ago #70637

  • MaitreCake
  • MaitreCake's Avatar
  • Offline
  • Junior Member
  • Posts: 23
  • Karma: 1
Hello,

Here is what I have done with no results :

Reset Cache Custom Data Module Upload Theme and ConfigOveride on 775, everything else is on 755.
About the ownership, Filezilla give me a 845386 100 (this is the same for all the files I have on my shared host)
If you want me to change it, please tell me wich one I have to set, it is going to be my first Chmod.

I tried to disable https, by addind this kind of code in my .htacces, all I had it is redirection errors in Firefox.
RewriteEngine On
RewriteCond %{HTTPS} on
RewriteRule (.*) http://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]

The IP adress I collected using ping or any other web services (213.186.33.40) sent me to a non relevant page of my host.

Regarding logs, the suiteCRM.log gave me about 500 different " [FATAL] Slow Query".

The error log of my provider have several critical errors as this one:
[host www.septentriontours.com] (13)Permission denied: AH00529: /homez.642/DATABASENAME/www/SUITE/cache/jsLanguage/EmailMan/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/homez.642/DATABASENAME/www/SUITE/cache/jsLanguage/EmailMan/' is executable, referer: https://www.septentriontours.com/SUITE/index.php?module=EmailMan&action=index

However, as I said my rights are set properly, and my .htaccess is readable and active ( The redirections error in firefox). I tried to play with its permissions but nothing change. What is is its proper setting by the way ?

As you can see, I am really a newbie. If you need any more details just tell me where to find them.

Thank you very much for helping me on this issue.
Newbie who loves to have the last word with his computer.
_____________________________________________
Version 7.10.10

Sugar Version 6.5.25 (Build 344)

MYSQL v.5.5 PHP 7.2
The administrator has disabled public write access.

Brand new installation More than slow 3 months 2 weeks ago #70897

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 8567
  • Thank you received: 1312
  • Karma: 313
Which version of SuiteCRM do you have?

Can you access it from phpMyAdmin? If so, please give the results of the first query in this post:

pgorod.github.io/Database-tables-size/

I suspect your Alerts table is overgrown. There was an old bug that caused performance problems with this.

Your server is taking 64 seconds to answer this request, and this request is in every screen of SuiteCRM...

www.septentriontours.com/SUITE/index.php...&action=get&to_pdf=1

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: MaitreCake

Brand new installation More than slow 3 months 2 weeks ago #70898

  • MaitreCake
  • MaitreCake's Avatar
  • Offline
  • Junior Member
  • Posts: 23
  • Karma: 1
Hello,

I am on Suite CRM 7.10.

The first query on PHPmyAdmin gives me that :
CONCAT(table_schema, '.', table_name)rowsDATAidxtotal_sizeidxfrac
septentrbbsuite.job_queue0.001M0.000G0.000G0.000G0.355
septentrbbsuite.emails_text0.000M0.000G0.000G0.000G0.032
septentrbbsuite.relationships0.000M0.000G0.000G0.000G0.766
septentrbbsuite.acl_actions0.000M0.000G0.000G0.000G1.791
septentrbbsuite.campaign_log0.000M0.000G0.000G0.000G1.112
septentrbbsuite.email_templates0.000M0.000G0.000G0.000G0.145
septentrbbsuite.prospects0.000M0.000G0.000G0.000G2.636
septentrbbsuite.email_addresses0.000M0.000G0.000G0.000G2.504
septentrbbsuite.emails_beans0.000M0.000G0.000G0.000G0.882
septentrbbsuite.emailman0.000M0.000G0.000G0.000G1.322

Nothing about the alert table...

I hope it can help.

Thank you again
Newbie who loves to have the last word with his computer.
_____________________________________________
Version 7.10.10

Sugar Version 6.5.25 (Build 344)

MYSQL v.5.5 PHP 7.2
The administrator has disabled public write access.

Brand new installation More than slow 3 months 2 weeks ago #70900

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 8567
  • Thank you received: 1312
  • Karma: 313
Definitely no overgrown tables there...

Though I still suspect the Alerts because of the delays (you can see for yourself on your browser's netwrok tab while you wait for pages to load).

The alerts code uses the date to check a condition. Can you check if your server's date is correct, and if your PHP's timezone is correctly defined?

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Brand new installation More than slow 3 months 2 weeks ago #70901

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 8567
  • Thank you received: 1312
  • Karma: 313
Another thing: you said you had lots of "slow query" FATAL errors in suitecrm.log: which query is that? Is there a particular query that appears to be repeated most often?

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Brand new installation More than slow 3 months 2 weeks ago #70903

  • MaitreCake
  • MaitreCake's Avatar
  • Offline
  • Junior Member
  • Posts: 23
  • Karma: 1
Thanks for all theses advices :

In PHPMyAdmin,
SELECT CURTIME(), CURRENT_TIME(), CURRENT_TIME
give me the same time than the following php script I put in the SuiteCRM folder
<?php
$date = date("d-m-Y");
$heure = date("H:i");
Print("Nous sommes le $date et il est $heure");
?>
That's the Paris one, the one set my users profile, and it looks the same as the one in my logs files.

Slow queries fatal logs are about anything starting by SELECT or INSERT in any table. It is just about what I am trying to do.

Sometimes I have
[FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME  is not set
but not so often.

Thank you so much for helping me on this one.
Newbie who loves to have the last word with his computer.
_____________________________________________
Version 7.10.10

Sugar Version 6.5.25 (Build 344)

MYSQL v.5.5 PHP 7.2
The administrator has disabled public write access.

Brand new installation More than slow 3 months 2 weeks ago #70933

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 8567
  • Thank you received: 1312
  • Karma: 313
Does your PHP date script give the same results when you run it from the browser, and from the command-line?
php -f yourDateScript.php

The MY_FRAME message is a known issue, it is fixed in the next version which can be coming out as soon as this week, if tests go well. It is not a relevant message.

If you can't solve the mystery, sometimes it's a good idea to try and bypass it altogether, upgrading every software you can. So you could try going up to PHP 7.2 and MySQL 5.7 and hope the problem magically goes away. As a side-effect you get safer, more robust and efficient software in place.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
Last Edit: 3 months 2 weeks ago by pgr.
The administrator has disabled public write access.

Brand new installation More than slow 3 months 2 weeks ago #70952

  • MaitreCake
  • MaitreCake's Avatar
  • Offline
  • Junior Member
  • Posts: 23
  • Karma: 1
Thank you about that.

My database is on a shared host, so I can not upgrade SQL.
About php, I went to the 7.2, nothing change.
The time is the same by command line or by the browser.

I hope the "magic effect" will take place once the new release you mentioned will be available.

It is a really a pity because I wanted to make my team use SuiteCRM that delighted me untill this issue. :S

Thx again
Newbie who loves to have the last word with his computer.
_____________________________________________
Version 7.10.10

Sugar Version 6.5.25 (Build 344)

MYSQL v.5.5 PHP 7.2
The administrator has disabled public write access.

Brand new installation More than slow 3 months 2 weeks ago #70966

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 8567
  • Thank you received: 1312
  • Karma: 313
Your issue is very strange, and rare. I wonder if your hosting is providing you with a server that is fit for business. Maybe you can try getting your hosting support involved, say it's behaving very slow, and ask them if they get some diagnostic of possible reasons...

Sometimes they'll discover a failing disk or one of the other accounts on the server was hacked and is draining resources...

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: MaitreCake

Brand new installation More than slow 3 months 2 weeks ago #70967

  • MaitreCake
  • MaitreCake's Avatar
  • Offline
  • Junior Member
  • Posts: 23
  • Karma: 1
Well,

I will try but at the end of the day, I have a Joomla website and a Owncloud storage on the same hosting that don't look impacted by the same issue. That's why it makes me mad.

I come back here if any kind of advice is given by them.

Thanks again,
Newbie who loves to have the last word with his computer.
_____________________________________________
Version 7.10.10

Sugar Version 6.5.25 (Build 344)

MYSQL v.5.5 PHP 7.2
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Time to create page: 0.135 seconds
Powered by Kunena Forum