Error while posting a POST

luceos

xasharma can you log in and see your index? Because it seems your database isn't up and running. At least that's what the error says.

xasharma

luceos can you log in and see your index

Index ... I didn't understood it, what is index

luceos

xasharma can you open your Flarum forum in a normal way?

xasharma

luceos can you open your Flarum forum in a normal way?

yes

but signups and posts and discussions posting is very slow even after turning off all the notifications and subscription services for each user.

EDIT - I have a VPS with 4 cores and 6GB RAM and it is using around 50% CPU and 60-80% RAM on average .... still so slow

xasharma

luceos i check the DB, no idea about the errors

GreXXL

This seems to be an infrastructure problem or configuration issue. Is this a large community? Can you share your php flarum info output? Are you using any sort of queue? Is this behavior reproducible in certain conditions. Like posting in the same tag?

xasharma

GreXXL Is this a large community?

USERS
94.9K

DISCUSSIONS
11.3K

POSTS
79.2K

GreXXL Can you share your php flarum info output

Flarum core: 1.8.1
PHP version: 8.2.7
MySQL version: 10.3.39-MariaDB
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, random, readline, Reflection, SPL, session, standard, bcmath, bz2, calendar, ctype, curl, dba, dom, enchant, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, imap, intl, ldap, exif, mysqlnd, PDO, Phar, posix, shmop, SimpleXML, soap, sockets, sodium, sqlite3, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlwriter, xsl, zip, mysqli, pdo_mysql, pdo_sqlite, xmlreader, Zend OPcache
+------------------------------------------+---------+--------+
| Flarum Extensions                        |         |        |
+------------------------------------------+---------+--------+
| ID                                       | Version | Commit |
+------------------------------------------+---------+--------+
| flarum-flags                             | v1.8.0  |        |
| flarum-suspend                           | v1.8.0  |        |
| askvortsov-auto-moderator                | v0.1.2  |        |
| flarum-tags                              | v1.8.0  |        |
| flarum-sticky                            | v1.8.0  |        |
| flarum-likes                             | v1.8.0  |        |
| flarum-approval                          | v1.8.0  |        |
| fof-spamblock                            | 1.1.0   |        |
| flarum-markdown                          | v1.8.0  |        |
| afrux-forum-widgets-core                 | v0.1.7  |        |
| zerosonesfun-featured-card               | 1.0.3   |        |
| v17development-user-badges               | v1.1.0  |        |
| v17development-seo                       | v1.8.0  |        |
| the-turk-stickiest                       | 3.0.1   |        |
| the-turk-diff                            | 1.1.2   |        |
| sycho-profile-cover                      | v1.3.5  |        |
| ramesh-dada-increase-title               | 1.0.0   |        |
| ramesh-dada-bbcode-alerts                | 6.21    |        |
| nearata-related-discussions              | 1.4.0   |        |
| nearata-no-self-likes                    | v1.2.1  |        |
| nearata-copy-code-to-clipboard           | v2.1.0  |        |
| justoverclock-guestengagement            | 1.0.3   |        |
| justoverclock-contactme                  | 0.2.3   |        |
| ianm-no-meta-title                       | 1.1.0   |        |
| ianm-html-head                           | 1.1.0   |        |
| fof-username-request                     | 1.1.2   |        |
| fof-user-directory                       | 1.2.3   |        |
| fof-user-bio                             | 1.1.1   |        |
| fof-upload                               | 1.2.3   |        |
| fof-terms                                | 1.2.1   |        |
| fof-subscribed                           | 1.1.3   |        |
| fof-stopforumspam                        | 1.2.3   |        |
| fof-sitemap                              | 2.2.0   |        |
| fof-share-social                         | 1.1.2   |        |
| fof-polls                                | 1.4.2   |        |
| fof-oauth                                | 1.4.4   |        |
| fof-nightmode                            | 1.5.2   |        |
| fof-links                                | 1.1.4   |        |
| fof-impersonate                          | 1.1.1   |        |
| fof-geoip                                | 1.1.0   |        |
| fof-formatting                           | 1.0.3   |        |
| fof-default-user-preferences             | 1.2.0   |        |
| fof-default-group                        | 1.1.1   |        |
| fof-byobu                                | 1.3.0   |        |
| fof-best-answer                          | 1.2.5   |        |
| fof-bbcode-details                       | 1.1.1   |        |
| fof-analytics                            | 1.1.0   |        |
| flarumtr-mobile-search                   | v1.2    |        |
| flarum-statistics                        | v1.8.0  |        |
| flarum-pusher                            | v1.8.0  |        |
| flarum-mentions                          | v1.8.0  |        |
| flarum-lock                              | v1.8.0  |        |
| flarum-lang-english                      | v1.8.0  |        |
| flarum-bbcode                            | v1.8.0  |        |
| extiverse-mercury                        | 0.2.0   |        |
| davwheat-custom-sidenav-links            | 1.0.1   |        |
| davwheat-ads                             | 1.2.0   |        |
| datlechin-traditional-rank-icons         | v0.1.1  |        |
| darkle-fancybox                          | 1.1.2   |        |
| clarkwinkelmann-post-permissions         | 1.0.0   |        |
| clarkwinkelmann-popular-discussion-badge | 1.1.1   |        |
| clarkwinkelmann-mass-actions             | 1.1.2   |        |
| clarkwinkelmann-emojionearea             | 1.0.0   |        |
| clarkwinkelmann-discussion-bookmarks     | 2.0.0   |        |
| clarkwinkelmann-author-change            | 1.0.3   |        |
| askvortsov-rich-text                     | v2.1.7  |        |
| askvortsov-moderator-warnings            | v0.6.1  |        |
| askvortsov-markdown-tables               | v1.2.1  |        |
| afrux-news-widget                        | v0.1.1  |        |
+------------------------------------------+---------+--------+
Base URL: https://xyz.com
Installation path: /home/hacksnat/flarum
Queue driver: sync
Session driver: file
Scheduler status: Never run
Mail driver: mail
Debug mode: off

GreXXL Are you using any sort of queue?

GreXXL Is this behavior reproducible in certain conditions. Like posting in the same tag?

It reproduces sometimes... I changed my hosting also to run the site fast .... but with 4 Cores and 6 GB RAM, it is still very slow, it takes around 40-60 seconds to register a user and takes around 20 - 40 seconds to post a discussion and takes 20 - 40 seconds to post a Post. And i have turned off the notifications for all users.
It uses only 40 - 60% of CPU and around 50-70% RAM on average

GreXXL

xasharma I guess that due to not using a queue and having a ton of extensions that you have some load issues. Can you try running DB queues to see if that helps? https://discuss.flarum.org/d/28151-database-queue-the-simplest-queue-even-for-shared-hosting/

xasharma

clarkwinkelmann

clarkwinkelmann Is the error message still the same ?

Yes, not always, i get this error 2-3 times a day and problems are still same.

xasharma It reproduces sometimes... I changed my hosting also to run the site fast .... but with 4 Cores and 6 GB RAM, it is still very slow, it takes around 40-60 seconds to register a user and takes around 20 - 40 seconds to post a discussion and takes 20 - 40 seconds to post a Post. And i have turned off the notifications for all users.
It uses only 40 - 60% of CPU and around 50-70% RAM on average

xasharma

GreXXL I tried but no that good improvement ... only a 2-5 seconds difference

And also after doing this new signup users are not giving a notification to admin that someone is registered and it takes the same time to register by Google (FOF Oauth) around 40-60 seconds

GreXXL

xasharma Something seriously wrong with your server's setup. The resources are way enough to host Flarum, and yet you struggle. This also goes beyond supporting Flarum as everything points to this not being related to Flarum. If you have trouble setting up the server, you might find someone you can hire to help you configure it in theServices tag.

xasharma

GreXXL @luceos Please help

xasharma

GreXXL

Hiii guys

clarkwinkelmann

Is the error message still the same ? If MySQL is denying connection, it's not a Flarum-specific issue.

If you are out of ideas you could try contacting your hosting support or if they have a community forum, maybe other users of that hosting experienced issues with MySQL as well.

If you really don't find anything, you should probably try provisioning a new server, either with the same host or with a different host and see if the issue appears there as well.

xasharma

clarkwinkelmann I use cpanel and @luceos helped me to migrate my site from old hosting to new one.

On cPanel, as we all know, the main site index is in the public_html directory, And on the home path (before public_html), I have my data folder named "flarum", in this folder the all data is stored.

Screenshot -

Screenshot of public_html data

Screenshot of the flarum directory -

Screenshot of the public directory under flarum directory - (but i checked the files both all are not working/not used and the main data is in public_html >> assests directory as shwon in the 2nd screenshot

May be there is an error

Wellwisher

xasharma who’s your hosting provider

xasharma

Wellwisher https://ultahost.com

Wellwisher

xasharma did the problem occur before or after migration? What’s the sites url?

xasharma

Wellwisher did the problem occur before or after migration?

After, First I tried the normal flarum, and after the database migration it was very slow

Wellwisher What’s the sites url?

hacksnation

Wellwisher

My small brain says there's two things you can possibly look into:

Make sure there are no firewall restrictions preventing the connection. E.g ModSecurity is known to cause issues.

ModSecurity is an Apache module which works as a web application firewall.

It blocks known exploits and provides protection from a range of attacks against web applications. However, sometimes, ModSecurity may incorrectly determine that a certain request is malicious, while it is actually legitimate. In such a situation we can white-list triggered mod_security rule on the server, so that you can bypass the block.

We have found and whitelisted a few triggered rules on the server. You can test your website updating once again now.

There's a small chance an extension could be causing the issue too. Try disabling all modifications and see if your new members are able register at normal speed.

xasharma

Wellwisher I tried no effect