Is a Single `role` Column Enough for User Roles in MySQL?

# Is a Single `role` Column Enough for User Roles in MySQL? Have you ever added a `role` column to your `users` table to manage access to your application, only to realise later that your users might need more than one role? This is a common starting point when building authentication and authorisation systems. You… Read More »

Unable to call mysql command line with credentials from mysql_clientdb.conf

Checking ISPConfig database .. mysqlcheck: Got error: 1698: Access denied for user ‘root’@’localhost’ when trying to connect OK ERROR 1698 (28000): Access denied for user ‘root’@’localhost’ Unable to call mysql command line with credentials from mysql_clientdb.conf Solution: cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf nano /usr/local/ispconfig/server/lib/mysql_clientdb.conf

How to configure cisco switch for pppoe connection

Configuring a Cisco device (typically a router or layer 3 switch acting as a CPE) for PPPoE involves creating a Dialer interface, setting authentication (CHAP/PAP), enabling encapsulation, and binding it to a physical WAN port. Key steps include defining pppoe-client dial-pool-number, setting mtu 1492, and using ip address negotiated.  Configuration Steps Configure the Physical Interface (e.g., Gig0/0) connected to the… Read More »

How to set Favicon Icon in Codeigniter 4

You can put the favicon.ico file in the web root…./public folder, so the URL would be yourdomain.com/favicon.ico Then you have to add the following line of code into your HTML: I have used this in my code layout.php and its working fine!

Class “MySQLi” not found: in

Class “MySQLi” not found: in /web/system/library/db/mysqli.php on line 29 How to solve “Fatal error: Class ‘MySQLi’ not found”: in? Solution: root@en-03:~# apt install php8.2-mysql

How to upgrade debian 11 to 12

Step-by-Step Guide to Upgrade to Debian 12 from Debian 11 Copy & Paste as below: sed -i ‘s/bullseye/bookworm/g’ /etc/apt/sources.list sed -i ‘s/bullseye/bookworm/g’ /etc/apt/sources.list.d/*.list apt-get update -y && apt-get upgrade –without-new-pkgs -y && apt-get full-upgrade -y reboot lsb_release -a

Whoops! We seem to have hit a snag. Please try again later

After installing CodeIgniter 4 when you run the app then you will get an error like this: Whoops! We seem to have hit a snag. Please try again later And in cmd line when run composer update you see something similar to this output below: Problem 1 – codeigniter4/framework[4.0.0, …, v4.4.4] require ext-intl * ->… Read More »

Debian 12 The system will suspend now!

You have just installed Debian 12. However SSH session receive this unexpected message: Broadcast message from Debian-gdm@en-03 on tty1 (Mon 2024-01-08 09:34:01 SAST): The system will suspend now! The solution: This method works better to prevent SSH disconnecting from client side. Create /etc/systemd/sleep.conf.d/nosuspend.conf as follows: root@en-03:~# mkdir -p /etc/systemd/sleep.conf.d/ root@en-03:~# vi /etc/systemd/sleep.conf.d/nosuspend.conf [Sleep] AllowSuspend=no AllowHibernation=no… Read More »

How to check codeigniter 4 version

If you don’t know what version of CodeIgniter you are currently running, and assuming that Composer was used to install CodeIgniter: you can get it by running the following command line: genie@en-03:/var/www/busylines.co.za/web$composer show | grep codeigniter codeigniter4/framework v4.4.3 The CodeIgniter framework v4 The current version is v4.4.3. All the best of luck.