Resolved Uncaught syntaxerror: unexpected token

[zepelin57]

Server operating system version

AlmaLinux 8.8

Plesk version and microupdate number

18.0.56

Hi,
Yesterday I upgraded MariaDB from 10.3.9 to 10.6.15 and it went well.
But since when I want to install a CMS like Joomla, Prestashop or WP I have errors on js files (See attachment
Did the upgrade cause these errors? If yes, how to correct them?
Thanks for your help.

 

[Peter Debik]

It is unlikely that this is linked to MariaDB, but it cannot be totally ruled out. Do you have directives in /etc/my.cnf or include files that set specific collations or default character sets?

 

[zepelin57]

Thank you for your answer. In the my.cnf file I have:

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[mysqld]
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
bind-address = 127.0.0.1
local-infile=0

For include files that set specific collations or default character sets, I don't understand what you mean.

 

[Kaspar]

@zepelin57 in your my.cnf file change the line bind-address = 127.0.0.1 to bind-address = ::. Afterwards restart mariaDB with systemctl restart mariadb.

 

[zepelin57]

@zepelin57 in your my.cnf file change the line bind-address = 127.0.0.1 to bind-address = ::. Afterwards restart mariaDB with systemctl restart mariadb.

Worse all websites and Plesk are down., After restart i have :
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

 

[zepelin57]

Rapport systemctl :

[root@xxxxxxxxxxxxxxxx ~]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.6.15 database server
   Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; disabled; vendor >
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Wed 2023-10-25 20:27:02 CEST; 1min >
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 1118283 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_>
  Process: 1125687 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTE>
  Process: 1125664 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] &&>
  Process: 1125661 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_S>
 Main PID: 1125687 (code=exited, status=7)
   Status: "MariaDB server is down"

Oct 25 20:27:02 xxxxxxxxxxxxxxxx.fr mariadbd[1125687]: 2023-10-25 20:27:02 0 [Note]>
Oct 25 20:27:02 xxxxxxxxxxxxxxxx.fr mariadbd[1125687]: 2023-10-25 20:27:02 0 [Note]>
Oct 25 20:27:02 xxxxxxxxxxxxxxxx.fr mariadbd[1125687]: 2023-10-25 20:27:02 0 [Note]>
Oct 25 20:27:02 xxxxxxxxxxxxxxxx.fr mariadbd[1125687]: 2023-10-25 20:27:02 0 [Note]>
Oct 25 20:27:02 xxxxxxxxxxxxxxxx.fr mariadbd[1125687]: 2023-10-25 20:27:02 0 [Note]>
Oct 25 20:27:02 xxxxxxxxxxxxxxxx.fr mariadbd[1125687]: 2023-10-25 20:27:02 0 [ERROR>
Oct 25 20:27:02 xxxxxxxxxxxxxxxx.fr mariadbd[1125687]: 2023-10-25 20:27:02 0 [ERROR>
Oct 25 20:27:02 xxxxxxxxxxxxxxxx.fr systemd[1]: mariadb.service: Main process exite>
Oct 25 20:27:02 xxxxxxxxxxxxxxxx.fr systemd[1]: mariadb.service: Failed with result>
lines 1-23/24 95%

Rapport journalctl -xe :

-- for starting have been started. Note that other services might still be star>
-- up or be started at any later time.
--
-- Startup of the manager took 51896 microseconds.
Oct 25 20:34:37 xxxxxxxxxxxxxxxx.fr systemd[1]: Started User Manager for UID 10016.
-- Subject: Unit [email protected] has finished start-up
-- Defined-By: systemd
-- Support: https://access.redhat.com/support
--
-- Unit [email protected] has finished starting up.
--
-- The start-up result is done.
Oct 25 20:34:37 xxxxxxxxxxxxxxxx.fr systemd[1]: Started Session c955775 of user ser>
-- Subject: Unit session-c955775.scope has finished start-up
-- Defined-By: systemd
-- Support: https://access.redhat.com/support
--
-- Unit session-c955775.scope has finished starting up.
--
-- The start-up result is done.
Oct 25 20:34:37 xxxxxxxxxxxxxxxx.fr sshd[1127933]: pam_unix(sshd:auth): authenticat>
Oct 25 20:34:37 xxxxxxxxxxxxxxxx.fr sshd[1127933]: Unable to connect to Plesk Datab>
Oct 25 20:34:37 xxxxxxxxxxxxxxxx.fr sshd[1127933]: pam_succeed_if(sshd:auth): requi>
lines 5570-5592/5592 (END)

 

[Kaspar]

My mistake. The line bind-address = 127.0.0.1 is actually fine. Sorry about that.

Not sure what causes your initial issue tho.

 

[zepelin57]

I reset 127.0.0.1, but since then mariadb no longer starts and all my websites and Plesk are down, help!

 

[Kaspar]

Sorry to heat that. The previous output you posted from systemctl status mariadb.service seems truncated. Can you post full the output again?

 

[zepelin57]

[root@xxxxxxxxxxxxxxxx ~]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.6.15 database server
   Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Wed 2023-10-25 22:03:29 CEST; 3s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 31528 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=7)
  Process: 31506 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, statu>
  Process: 31504 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 31528 (code=exited, status=7)
   Status: "MariaDB server is down"

Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr mariadbd[31528]: 2023-10-25 22:03:29 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr mariadbd[31528]: 2023-10-25 22:03:29 0 [Note] InnoDB: 10.6.15 started; log sequence number 320579906720; transaction id 292517367
Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr mariadbd[31528]: 2023-10-25 22:03:29 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr mariadbd[31528]: 2023-10-25 22:03:29 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr mariadbd[31528]: 2023-10-25 22:03:29 0 [Note] InnoDB: Buffer pool(s) load completed at 231025 22:03:29
Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr mariadbd[31528]: 2023-10-25 22:03:29 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'ocal-infile=0'
Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr mariadbd[31528]: 2023-10-25 22:03:29 0 [ERROR] Aborting
Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr systemd[1]: mariadb.service: Main process exited, code=exited, status=7/NOTRUNNING
Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr systemd[1]: mariadb.service: Failed with result 'exit-code'.
Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr systemd[1]: Failed to start MariaDB 10.6.15 database server.
lines 1-23/23 (END)

 

[Peter Debik]

Oct 25 22:03:29 xxxxxxxxxxxxxxxx.fr mariadbd[31528]: 2023-10-25 22:03:29 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'ocal-infile=0'

You have a syntax error in your my.cnf file. Please update "ocal-infile" to "local-infile".

 

[zepelin57]

Peter You are my savior !
It's time for me to retire.

 

[zepelin57]

But I still have this problem with js files, I just tried to install Joomla5 and lots of errors. I don't understand, because before the MariaDB upgrade I didn't have a problem. Now it might be something else, but what?

 

[Kaspar]

Are there any errors in the error log of the domain?

 

[zepelin57]

Yes, but I don't know if that has anything to do with it :

HEAD / HTTP/1.0        Mozilla/5.0 (compatible; monitoring360bot/1.1; +http://www.monitoring360.io/bot.html)    775    Accès SSL/TLS Apache

Error ip AH01276: Cannot serve directory /var/www/vhosts/xxxxxxxxxx.net/httpdocs/: No matching DirectoryIndex (index.html,index.cgi,index.pl,index.php,index.xhtml,index.htm,index.shtml) found, and server-generated directory index forbidden by Options directive"

 

[Peter Debik]

Looks as if files are missing.

 

[zepelin57]

Hello Peter,
Thank you for your help.
I didn't find any missing files, but I no longer have yesterday's error in the logs but just this one:

 

[zepelin57]

Problem solved, I added a directive in the Nginx field! Thank you all for your help.