Hello there, It looks like that your root password is not good.
Can you try the pf account? mysql -upf -p -e "show variables where Variable_name='version’;" Thanks, Ludovic Zammit Product Support Engineer Principal Cell: +1.613.670.8432 Akamai Technologies - Inverse 145 Broadway Cambridge, MA 02142 Connect with Us: <https://community.akamai.com/> <http://blogs.akamai.com/> <https://twitter.com/akamai> <http://www.facebook.com/AkamaiTechnologies> <http://www.linkedin.com/company/akamai-technologies> <http://www.youtube.com/user/akamaitechnologies?feature=results_main> > On Mar 22, 2022, at 3:47 PM, Martijn Langendoen <mlangend...@dezb.nl> wrote: > > Hi, > > Yes there is a problem with mariadb > Here my upgrade log: > > [root@PacketFence-ZEN ~]# ps ax | grep mariadb > 1919 ? Ss 0:00 pf-mariadb > 2155 ? S 0:00 /bin/sh /usr/bin/mysqld_safe > --defaults-file=/usr/local/pf/var/conf/mariadb.conf > 2300 ? Sl 0:02 /usr/sbin/mysqld > --defaults-file=/usr/local/pf/var/conf/mariadb.conf --basedir=/usr > --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin > --pid-file=PacketFence-ZEN.pid --socket=/var/lib/mysql/mysql.sock --port=3306 > > [root@PacketFence-ZEN ~]# ps ax | grep mysql > 2155 ? S 0:00 /bin/sh /usr/bin/mysqld_safe > --defaults-file=/usr/local/pf/var/conf/mariadb.conf > 2300 ? Sl 0:02 /usr/sbin/mysqld > --defaults-file=/usr/local/pf/var/conf/mariadb.conf --basedir=/usr > --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin > --pid-file=PacketFence-ZEN.pid --socket=/var/lib/mysql/mysql.soc > 2301 ? S 0:00 logger -t mysqld -p daemon.error > > > # Start update with written in the upgrade guide: > > [root@PacketFence-ZEN ~]# /usr/local/pf/bin/pfcmd service pf stop > Service Status PID > packetfence-api-frontend.service stopped 0 > packetfence-config.service started 0 > packetfence-fingerbank-collector.service stopped 0 > packetfence-galera-autofix.service disabled 0 > packetfence-haproxy-admin.service stopped 0 > packetfence-haproxy-db.service disabled 0 > packetfence-haproxy-portal.service stopped 0 > packetfence-httpd.aaa.service stopped 0 > packetfence-httpd.admin.service disabled 0 > packetfence-httpd.admin_dispatcher.service stopped 0 > packetfence-httpd.collector.service disabled 0 > packetfence-httpd.dispatcher.service stopped 0 > packetfence-httpd.portal.service stopped 0 > packetfence-httpd.proxy.service disabled 0 > packetfence-httpd.webservices.service stopped 0 > packetfence-iptables.service stopped 0 > packetfence-keepalived.service stopped 0 > packetfence-mariadb.service started 1919 > packetfence-netdata.service stopped 0 > packetfence-pfacct.service stopped 0 > packetfence-pfcertmanager.service stopped 0 > packetfence-pfcron.service stopped 0 > packetfence-pfdetect.service stopped 0 > packetfence-pfdhcp.service stopped 0 > packetfence-pfdhcplistener.service stopped 0 > packetfence-pfdns.service stopped 0 > packetfence-pffilter.service stopped 0 > packetfence-pfipset.service stopped 0 > packetfence-pfperl-api.service stopped 0 > packetfence-pfpki.service stopped 0 > packetfence-pfqueue.service stopped 0 > packetfence-pfsso.service stopped 0 > packetfence-pfstats.service stopped 0 > packetfence-radiusd-acct.service disabled 0 > packetfence-radiusd-auth.service stopped 0 > packetfence-radiusd-cli.service stopped 0 > packetfence-radiusd-eduroam.service stopped 0 > packetfence-radiusd-load_balancer.service disabled 0 > packetfence-radsniff.service stopped 0 > packetfence-redis-cache.service started 1554 > packetfence-redis_ntlm_cache.service disabled 0 > packetfence-redis_queue.service stopped 0 > packetfence-snmptrapd.service stopped 0 > packetfence-tc.service disabled 0 > packetfence-tracking-config.service disabled 1 > packetfence-winbindd.service stopped 0 > > [root@PacketFence-ZEN ~]# systemctl stop packetfence-config > > [root@PacketFence-ZEN ~]# ps ax | grep mysql > 2155 ? S 0:00 /bin/sh /usr/bin/mysqld_safe > --defaults-file=/usr/local/pf/var/conf/mariadb.conf > 2300 ? Sl 0:05 /usr/sbin/mysqld > --defaults-file=/usr/local/pf/var/conf/mariadb.conf --basedir=/usr > --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin > --pid-file=PacketFence-ZEN.pid --socket=/var/lib/mysql/mysql.sock --port=3306 > 2301 ? S 0:00 logger -t mysqld -p daemon.error > > mysql stil running.... > > backup tu upgrade manual 18.1.1 > [root@PacketFence-ZEN ~]# systemctl stop packetfence-mariadb > [root@PacketFence-ZEN ~]# ps ax | grep mysql > > mysql stopped. > > [root@PacketFence-ZEN ~]# rpm -e --nodeps MariaDB-client MariaDB-common > MariaDB-server MariaDB-shared > Warning: mysql.service changed on disk. Run 'systemctl daemon-reload' to > reload units. > [root@PacketFence-ZEN ~]# yum install --enablerepo=packetfence MariaDB-server > . > . > Installed: > MariaDB-server.x86_64 0:10.2.37-1.el7.centos > > Dependency Installed: > MariaDB-client.x86_64 0:10.2.37-1.el7.centos > MariaDB-common.x86_64 0:10.2.37-1.el7.centos > MariaDB-compat.x86_64 0:10.2.37-1.el7.centos > > Complete! > > > [root@PacketFence-ZEN ~]# systemctl unmask mariadb > Removed symlink /etc/systemd/system/mariadb.service. > [root@PacketFence-ZEN ~]# systemctl start mariadb > [root@PacketFence-ZEN ~]# ps ax | grep maria > 5352 pts/0 R+ 0:00 grep --color=auto maria > [root@PacketFence-ZEN ~]# ps ax | grep musql > 5354 pts/0 S+ 0:00 grep --color=auto musql > [root@PacketFence-ZEN ~]# journalctl -u mariadb > -- Logs begin at Mon 2022-03-21 21:23:13 CET, end at Tue 2022-03-22 20:27:01 > CET. -- > Mar 22 20:14:23 PacketFence-ZEN systemd[1]: Cannot add dependency job for > unit mariadb.service, ignoring: Unit is masked. > Mar 22 20:19:24 PacketFence-ZEN systemd[1]: Cannot add dependency job for > unit mariadb.service, ignoring: Unit is masked. > Mar 22 20:26:31 PacketFence-ZEN systemd[1]: Starting MariaDB 10.2.37 database > server... > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] /usr/sbin/mysqld (mysqld 10.2.37-MariaDB) starting as > process 5315 ... > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Warning] Could not increase number of max_open_files to more > than 16384 (request: 32186) > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Uses event mutexes > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Compressed tables use zlib 1.2.7 > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Using Linux native AIO > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Number of pools: 1 > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Using SSE2 crc32 instructions > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Initializing buffer pool, total size = 128M, > instances = 1, chunk size = 128M > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Completed initialization of buffer pool > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666427152128 [Note] InnoDB: If the mysqld execution user is authorized, > page cleaner thread priority can be changed. See the man page of > setpriority(). > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Highest supported file format is Barracuda. > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Upgrading redo log: 2*50331648 bytes; > LSN=196300299912 > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Starting to delete and rewrite log files. > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Setting log file ./ib_logfile101 size to > 50331648 bytes > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Setting log file ./ib_logfile1 size to > 50331648 bytes > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Renaming log file ./ib_logfile101 to > ./ib_logfile0 > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: New log files created, LSN=196300299912 > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: 128 out of 128 rollback segments are active. > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Creating sys_virtual system tables. > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Creating shared tablespace for temporary tables > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. > Physically writing the file full; Please wait ... > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: File './ibtmp1' size is now 12 MB. > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: Waiting for purge to start > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] InnoDB: 5.7.33 started; log sequence number > 196300299912 > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666128877312 [Note] InnoDB: Loading buffer pool(s) from > /var/lib/mysql/ib_buffer_pool > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666128877312 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' > for reading: No such file or directory > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] Plugin 'FEEDBACK' is disabled. > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] Server socket created on IP: '::'. > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666862376704 [Warning] InnoDB: Table mysql/innodb_table_stats has length > mismatch in the column name table_name. Please run mysql_upgrade > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666862376704 [Warning] InnoDB: Table mysql/innodb_index_stats has length > mismatch in the column name table_name. Please run mysql_upgrade > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] Reading of all Master_info entries succeeded > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] Added new Master_info '' to hash table > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: 2022-03-22 20:26:31 > 139666985912512 [Note] /usr/sbin/mysqld: ready for connections. > Mar 22 20:26:31 PacketFence-ZEN mysqld[5315]: Version: '10.2.37-MariaDB' > socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server > Mar 22 20:26:31 PacketFence-ZEN systemd[1]: Started MariaDB 10.2.37 database > server. > > [root@PacketFence-ZEN ~]# ps ax | grep mysql > 5315 ? Ssl 0:00 /usr/sbin/mysqld --basedir=/usr > > > [root@PacketFence-ZEN ~]# mysql -u root -p -e "show variables where > Variable_name='version';" > Enter password: > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES) > > > > <image001.jpg> > <image007.png> > Martijn Langendoen > netwerkbeheerder > mlangend...@dezb.nl <mailto:mlangend...@dezb.nl> > <image007.png> > 0118 654307 > > <image003.jpg> > <https://urldefense.com/v3/__https://www.facebook.com/dezbnl__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUIqA5xXhA$><image004.jpg> > > <https://urldefense.com/v3/__https://www.twitter.com/dezbnl__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUJxRU6pTQ$><image005.jpg> > > <https://urldefense.com/v3/__https://www.linkedin.com/company/dezbnl__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUK61vCdgw$><image006.jpg> > > <https://urldefense.com/v3/__https://www.instagram.com/dezbnl__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUIuId-0Mg$>/dezbnl > www.dezb.nl > <https://urldefense.com/v3/__http://www.dezb.nl/__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUIq1GKq5w$> > > <image007.png> > Kousteensedijk 7 > 4331 JE Middelburg > Postbus 8004 > 4330 EA Middelburg > > > Van: Zammit, Ludovic via PacketFence-users > <packetfence-users@lists.sourceforge.net> > Verzonden: 21 March 2022 15:54 > Aan: packetfence-users@lists.sourceforge.net > CC: Zammit, Ludovic <luza...@akamai.com> > Onderwerp: Re: [PacketFence-users] Problem with maridb root user > > Your Mariadb database does not work. > > Check why in the logs: > > journalctl -u mariadb > > Show me the logs. You need the db started to do the mysql_upgrade before > upgrading. > > Thanks, > > Ludovic Zammit > Product Support Engineer Principal > > Cell: +1.613.670.8432 > Akamai Technologies - Inverse > 145 Broadway > Cambridge, MA 02142 > Connect with Us: > <https://community.akamai.com/> <http://blogs.akamai.com/> > <https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUL2DFL3Hg$> > > <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUJeCFFGGA$> > > <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUILYUNaaQ$> > > <https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUJlDWzo0g$> > > > > On Mar 21, 2022, at 8:44 AM, Zammit, Ludovic via PacketFence-users > <packetfence-users@lists.sourceforge.net > <mailto:packetfence-users@lists.sourceforge.net>> wrote: > > Hello Martijn, > > Please list all the steps done and also the state and version of PF and > Mariadb. > > Thanks, > > Ludovic Zammit > Product Support Engineer Principal > > Cell: +1.613.670.8432 > Akamai Technologies - Inverse > 145 Broadway > Cambridge, MA 02142 > Connect with Us: > <https://community.akamai.com/> <http://blogs.akamai.com/> > <https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUL2DFL3Hg$> > > <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUJeCFFGGA$> > > <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUILYUNaaQ$> > > <https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUJlDWzo0g$> > > > > On Mar 20, 2022, at 10:36 AM, Martijn Langendoen via PacketFence-users > <packetfence-users@lists.sourceforge.net > <mailto:packetfence-users@lists.sourceforge.net>> wrote: > > Hi all, > > I want to upgrade from 10.2 to 10.3 then a fresh 11.2 install with > export/import config. > > I run the ZEN appliance always upgraded with the upgrade manual and went fine > but now with the first step the upgrade to a newer version of mariadb I run > into a problem. > I cant login with root in de the database. After resetting it still I can’t > login. > > Before the update so after the update to 10.2 and running month’s I even > can’t login also after resetting root’s passwd I still can’t login. I get > always the same error: > > [root@PacketFence-ZEN ~]# mysql -u root -p > Enter password: > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES) > > This was never a problem with with any database update scripts. > > Has anyone a clue? > > > > <image001.jpg> > <image006.png> > Martijn Langendoen > netwerkbeheerder > mlangend...@dezb.nl <mailto:mlangend...@dezb.nl> > <image006.png> > 0118 654307 > > <image002.jpg> > <https://urldefense.com/v3/__https:/www.facebook.com/dezbnl__;!!GjvTz_vk!FOzNo03-CWuNUfzTsDYS9hcCw-PIor524JoY7Ni5JZmKS6dRLVAEGGplIeHX3lAn$><image003.jpg> > > <https://urldefense.com/v3/__https:/www.twitter.com/dezbnl__;!!GjvTz_vk!FOzNo03-CWuNUfzTsDYS9hcCw-PIor524JoY7Ni5JZmKS6dRLVAEGGplIXzsfAKA$><image004.jpg> > > <https://urldefense.com/v3/__https:/www.linkedin.com/company/dezbnl__;!!GjvTz_vk!FOzNo03-CWuNUfzTsDYS9hcCw-PIor524JoY7Ni5JZmKS6dRLVAEGGplIV3QAFWl$><image005.jpg> > > <https://urldefense.com/v3/__https:/www.instagram.com/dezbnl__;!!GjvTz_vk!FOzNo03-CWuNUfzTsDYS9hcCw-PIor524JoY7Ni5JZmKS6dRLVAEGGplIQdb5S5F$>/dezbnl > www.dezb.nl > <https://urldefense.com/v3/__http:/www.dezb.nl/__;!!GjvTz_vk!FOzNo03-CWuNUfzTsDYS9hcCw-PIor524JoY7Ni5JZmKS6dRLVAEGGplIa6-iET0$> > > <image006.png> > Kousteensedijk 7 > 4331 JE Middelburg > Postbus 8004 > 4330 EA Middelburg > > > _______________________________________________ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > <mailto:PacketFence-users@lists.sourceforge.net> > https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!FOzNo03-CWuNUfzTsDYS9hcCw-PIor524JoY7Ni5JZmKS6dRLVAEGGplIe7rWwAz$ > > <https://urldefense.com/v3/__https:/lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!FOzNo03-CWuNUfzTsDYS9hcCw-PIor524JoY7Ni5JZmKS6dRLVAEGGplIe7rWwAz$> > > _______________________________________________ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > <mailto:PacketFence-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/packetfence-users > <https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!FrJ19TgzfIjLPz7C4-2X4KZ7Ajjx6POmebZ7DI39x2isF31XXbRyxUL5bnn0QA$>
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
