Home Blog Page 32

Identifying harmful activity on your captured traffic

0
Identifying harmful activity on your captured traffic

This Python script utilises Wireshark or TCPdump to analyse network traffic stored in a specified .pcap or .pcapng file. The objective is to detect potential malicious activities and attacks. The script covers a range of suspicious network behaviors, including:

DNS Tunneling
SSH Tunneling
TCP Session Hijacking
SMB Attack
SMTP or DNS Attack
IPv6 Fragmentation Attack
TCP RST Attack
SYN Flood Attack
UDP Flood Attack
Slowloris Attack

Additionally, the script attempts to identify packages containing specific suspicious keywords such as “password,” “login,” “admin,” etc. Detected activities and attacks are displayed in the console.
Usage Instructions:
1. Clone the repository:
git clone https://github.com/alperenugurlu/Network_Assessment.git
2. Install required dependencies:
pip3 install -r requirements.txt
3. Run the script:
python3 Network_Compromise_Assessment.py
4. Enter the path to the .pcap or .pcapng file when prompted.
Example:
Please enter the path to the .pcap or .pcapng file: /root/Desktop/TCP_RST_Attack.pcap
Script Structure:

get_user_input(): Retrieves the path of the .pcap file from the user.
get_all_ip_addresses(capture): Returns a set containing all source and destination IP addresses.
detect_* functions: Used to detect specific attacks and suspicious activities.
main(): Executes the primary operations of the script. It prompts the user for the file path and then analyses the file to identify specified attacks and suspicious activities.

Feel free to explore and enhance the capabilities of the script for a more comprehensive network assessment.
Download Link: Network_Assessment

Linus Torvalds Doesn’t Merge sched_ext For The Linux 6.11 Merge Window

0
Linus Torvalds Doesn't Merge sched_ext For The Linux 6.11 Merge Window

While Linus Torvalds stated in mid-June that he intended to merge sched_ext for Linux 6.11 as the exciting extensible scheduler code, it didn’t end up happening… The Linux 6.11-rc1 kernel was just released to close the Linux 6.11 merge window and the sched_ext code wasn’t pulled.
Many kernel developers have been excited about sched_ext as making it easier and quicker to iterate on kernel scheduler changes, prototype new scheduler behavior, etc. Linus Torvalds expressed last month he didn’t want to keep delaying it from merging and his plan was to merge it for Linux 6.11.
So as requested, back on 15 July as soon as the Linux 6.11 merge window opened, Tejun Heo submitted the sched_ext pull request. Sched_ext has evolved into nearly 14k lines of new code, including tests and related infrastructure.
But since then a few code problems were pointed out for improvement. Then a few days ago Qais Yousef raised some concernes:
I just reviewed this and I think you’re going in the wrong direction here. I don’t think the current level of review was sufficient and we’re rushing things to get them into 6.11.
We really shouldn’t change how schedutil works. The governor is supposed to behave in a certain way, and we need to ensure consistency. I think you should look on how you make your scheduler compatible with it. Adding hooks to say apply this perf value that I want is a recipe for randomness.
Generally I do have big concerns about sched_ext being loaded causing spurious bug report as it changes the behavior of the scheduler and the kernel is not trusted when sched_ext scheduler is loaded. Like out-of-tree modules, it should cause the kernel to be tainted. Something I asked for few years back when Gushchin sent the first proposal
How can we trust bug and regression report when out-of-tree code was loaded that intrusively changes the way the kernel behaves? This must be marked as a kernel TAINT otherwise we’re doomed trying to fix out of tree code.
And there’s another general problem of regression reports due to failure to load code due to changes to how the scheduler evolves. We need to continue to be able to change our code freely without worrying about breaking out-of-tree code. What is the regression rule? We don’t want to be limited to be able to make in-kernel changes because out-of-tree code will fail now; either to load or to run as intended. How is the current code designed to handle failsafe when the external scheduler is no longer compatible with existing kernel and *they* need to rewrite their code, pretty much the way it goes for out-of-tree modules now?
Now Linux 6.11-rc1 is out and the code wasn’t merged. Linus Torvalds didn’t comment on that pull request publicly at least not yet. Looks like some sched_ext refinements will ultimately be needed.
We’ll see if sched_ext is further baked in time for the Linux 6.12 kernel cycle to end out the year. Linux 6.12 is also likely to be this year’s Long Term Support (LTS) kernel version.

41 Must-Have Free Open Source Software for 2024

0
41 Must-Have Free Open Source Software for 2024

It is time to share a list of the best free and open-source software I found during the year 2023. Some of these programs may not be new in that they weren’t released for the first time in 2023, but they are new and have been helpful to me. It is in the spirit of sharing that I’m writing this article hoping you find some of these programs useful as well.
To begin, you may want to search for the program using your distribution’s package manager, like so:
The RHEL-based distribution users can use the yum or dnf package manager:
# yum search all package
Or
# dnf search all package

The Debian-based distribution users can use apt or aptitude package manager:
# apt search package
OR
# aptitude search package

OpenSUSE and derivatives can use the zypper command:
# zypper search package

Arch Linux and derivatives:
# pacman -Ss package

If your search returns no results, head over to the website of each tool where you will find the standalone package for download and installation instructions, along with information on dependencies.
1. SimpleScreenRecorder
You can use Simple Screen Recorder to make audio and video screencasts (entire screen or selected area). It is easy to install and use, but powerful at the same time.
We already covered Simple Screen Recorder in-depth, so just go through it and learn how to use it to capture and record the screen of your Linux computer.
Simple Screen Recorder
2. Jaspersoft Studio
Jaspersoft Studio is a report designer program that allows you to create simple and sophisticated reports as well with charts, tabs, tables (and everything you can expect to see in a world-class report) and export them to a wide variety of formats (with PDF perhaps being the most common).
With Q&A forums and User groups, plus several samples and examples, the community website is a great resource for help to master this versatile program.
Jaspersoft Studio
3. Visual Studio Code
Visual Studio Code is a free source code editor developed by Microsoft that has reached a significant level of popularity among web and cloud developers who are also Linux users since it provides a nice programming environment out of the box that supports extensions to add functionality.
Visual Studio Code
4. TuxGuitar
If you’re like me and music (especially the guitar) is one of your passions, you’ll love this TuxGuitar program, which will let you edit and play guitar tablatures like a pro.
TuxGuitar
5. Jitsi
Jitsi is a free and open-source audio/video conferencing and instant messaging platform for Windows, Linux, macOS, iOS, and Android.
It provides complete encryption with support for protocols such as SIP, XMPP/Jabber, AIM/ICQ, IRC, Windows Live Messenger, Yahoo!, Google Hangouts extensions, as well as OTR, ZRTP, etc.
Jitsi Video Conferencing
6. GCompris
GCompris is a cross-platform high-quality complete educational software collection for children aged between 2 to 10, and it comes with more than 140 entertaining activities.
That helps little children learn skills such as the identification of letters and numbers, the use of the mouse and keyboard, primary algebra training, reading time on an analog clock, vector drawing, language learning through games, and much more.
GCompris Kids Educational Software
7. GIMP
GIMP (GNU Image Manipulation Program) is a multi-platform, free, and open-source photo editing software used for image manipulation and image editing, free-form drawing, transcoding between different image file formats, and more specialized tasks.
GIMP – Image Editor for Linux
8. FreeCAD
FreeCAD is a general-purpose 3D Computer-Aided Design program fit for use in engineering and architecture. Given the fact that FreeCAD is FOSS, it is easily customizable and extensible through the use of Python scripts.
FreeCAD
9. Owncloud
Although not a new kid on the block in any way, I chose to include OwnCloud in this review due to its importance. As an alternative to commercial Dropbox, security, and privacy are achieved without much hassle and allow you to easily set up customized cloud storage and file-sharing solution.
We already covered installation about Owncloud in-depth here: Create Personal/Private Cloud Storage Solution in Linux
Owncloud Storage Solutions
10. MediaWiki
MediaWiki is a program for creating and managing a Wikipedia-like website (in fact, Wikipedia itself is based on MediaWiki) where a community can add, remove, update, and revert entries, and authors are notified of such changes.
MediaWiki
11. Bleachbit
You can think of Bleachbit as the CCleaner for Linux – but more powerful. It will not only recover disk space by deleting temporary or otherwise unnecessary files but will also improve Firefox’s performance and securely destroy unnecessary files to prevent recovery.
We already covered the installation of Bleachbit in-depth here: Disk Space Cleaner and Privacy Guard for Linux
Bleachbit
12. CodeMirror
CodeMirror is a very powerful Javascript-based text editor for the web browser. CodeMirror includes syntax highlighting for over 100 languages and a robust API. If you own a website or blog that provides programming tutorials, you will find CodeMirror to be a very useful tool.
CodeMirror Syntax Highlighting
13. GNU Health
GNU Health is a free, extremely scalable Health and Hospital Information Platform, which is used by health professionals across the world to enhance the lives of the underprivileged, offering a free technique that optimizes health promotion and disease prevention.
GNU Health – Freedom and Equity in Healthcare
14. OCS Inventory NG
Open Computer and Software Inventory Next Generation, or OCS Inventory NG for short, is a lightweight web application that can help network and system administrators to keep track of 1) all the devices connected to the network, and 2) machine configuration and software installed in them.
The project’s website (listed below) has a fully functional demo in case you want to check it out before attempting to actually install the program. In addition, OCS Inventory NG relies on well-known technologies like Apache and MySQL / MariaDB, making it a robust program.
OCS Inventory NG
15. GLPI
Often used in conjunction with OCS Inventory NG, GLPI is a multilingual, free IT asset management software that not only provides the tools to build up a database with an inventory of your network devices but also includes a job tracking system with mail notifications.
Other distinguishing features include, but are not limited to:

Interventions in history
Solution approval
Satisfaction survey
Exporting inventory to PDF, spreadsheet, or PNG formats

We already covered the installation of the GLPI IT Asset Management tool in-depth here: Install GLPI IT and Asset Management Tool in Linux
GLPI IT Asset Management
16. Ampache
With Ampache, you can set up your own home media center or online audio and video streaming application and access it from anywhere with an Internet connection.
Although it is designed as a personal application, Ampache allows for public registration if an administrator chooses to enable that feature.
Ampache MP3 Steaming
17. Master PDF Editor (Paid)
Master PDF Editor is an easy-to-use pdf editing tool for working with PDF documents that comes with powerful multi-purpose functionality.
It helps you to easily add text, create and modify pdf, add images, and encrypt files. Master PDF also allows you to merge files into one or split documents into multiple files.
Master PDF Editor
18. LibreOffice Draw
LibreOffice Draw is an application that is inbuilt into the LibreOffice suite that enables you to create anything from an easy sketch to a complex one and provides you the means to communicate with graphics and diagrams. With Draw, you can easily open and edit basic PDF files.
LibreOffice Draw
19. uniCenta oPOS
If you own a small or medium business you will undoubtedly need a Point Of Sale program. As such, uniCenta oPOS may be a lifesaver for you. It uses a MySQL / MariaDB database for data storage, and thus a single database can be used with multiple active terminals at the same time.
On top of all that, uniCenta oPOS also includes a search panel, a price-checker utility, and a tool to create printed reports.
uniCenta – Point Of Sale
20. OpenShot
OpenShot is a FOSS video editor for Linux that can help you create “the film you have always dreamed of” (in the words of its developers) with your home videos, pictures, and music files.
It also allows you to add subtitles, and transition effects, and export the resulting video file to DVD and many other common formats.
OpenShot Video Editor
21. LAN Messenger
LAN Messenger is a multilingual (a language pack is needed) and cross-platform (works in Linux, Windows, and Mac) IM program for communication over a LAN. It provides file transfers, message logging, and event notifications – all without the need to set up a server!
LAN Messenger
22. Cherrytree
Cherrytree is a free and open-source hierarchical note-taking program that comes with rich text formatting, syntax highlighting, and advanced customization options. Its advanced search feature enables you to search files across the file tree irrespective of their path.
It comes with keyboard shortcuts, importing and exporting notes, syncing with cloud platforms like Dropbox, and password security to keep your notes secure.
Cherrytree – Note-Taking App
23. FlightGear
FlightGear is an awesome open-source flight simulator tool, that is used to create a knowledgeable and open flight simulator system for use in experiments or academic environments, pilot training, an industrial engineering program, for DIY-ers to chase their chosen exciting flight simulation design, and last but surely not least as a fun, practical, and demanding desktop flight simulator for Linux.
FlightGear Flight Simulator
24. MuseScore
MuseScore is an open-source and free professional music notation application that is used to create, play and print beautiful sheet music using easy to use, yet powerful interface.
MuseScore – Music Notation Software
25. Tmux
Tmux is an open-source Linux terminal multiplexer that allows you to run multiple terminal sessions in a single window.
It is useful for running several programs in one terminal, detaching them (they keep running in the background), and reattaching them to a different terminal.
tmux- Terminal Multiplexer
26. qBittorrent
qBittorrent is a free and open-source BitTorrent client that helps users to download and share files over the network in a decentralized manner.
It allows users to connect to peers and seeders to download and upload files efficiently by connecting to a swarm of other users who are sharing the same file. It uses the BitTorrent protocol, which breaks files into smaller parts and allows users to download those parts from multiple sources simultaneously.
qBittorrent BitTorrent Client
27. NextCloud
Described as “a safe home for all your data”, NextCloud was started as a separate project by one of its ownCloud’s first collaborators.
Although it raised a few sparks between him and the ownCloud community, NextCloud seems to be here to stay and compete with ownCloud as a private cloud solution to access and share your files, calendars, contacts, and office documents.
Using dozens of third-party apps available on the official App Store, you can equip your Nexcloud instance with new features and turn it into a powerful collaborative environment that cares with respect to your personal data.
Nextcloud
28. Celestia
Because even system administrators and developers need a little distraction, you can use Celestia (a free 3D astronomy program) to navigate the universe.
Celestia serves as a 3D planetarium that seamlessly simulates various celestial objects whose position and movement are calculated accurately in real-time. It also comes with a large database of stars, galaxies, planets, asteroids, comets, and other celestial bodies.
As opposed to other planetarium software, Celestia allows you to travel throughout the solar system and the galaxy, not just the surface of the Earth. To infinity and beyond!
Celestia – Explore Our Universe
29. FreeRDP
If your system administration tasks include managing Windows servers via Remote Desktop Protocol (RDP), FreeRDP is a tool that you will want to try out.
It is described by its developers as an RDP client for Windows Terminal Services. The project is hosted on GitHub and released under the Apache license, so you are welcome to collaborate with it if you wish.
FreeRDP – Remote Desktop Protocol (RDP)
30. Flyspray
Again, I may be a little biased on this one. If you are searching for a bug-tracking and project management solution, don’t look any further Flyspray, a web-based tool powered by Apache has exactly what you need. And don’t just take my word for it: even ArchLinux uses Flyspray for bug-tracking.
Flyspray is a lightweight bug-tracking system written in PHP that runs on any OS and focuses on a very intuitive design allowing you to handle multiple projects at once.
It supports MySQL or PostgreSQL as database servers and provides voting functionality, email notifications (requires a separate mail server to be installed and configured), and optional Single-Sign-On (SSO) using a Facebook or Google account.
Flyspray – Bug Tracking System
31. GNUCash
If you have been using a spreadsheet to keep track of your personal, family, or business finances, it may be time to try a more suitable solution such as GNUCash.
This FOSS accounting software allows you to keep an eye on your bank accounts, expenses, and income and to create custom, complete reports with this data. Its user-friendly interface is a plus to the solid accounting principles GNUCash uses under the hood.
The official website includes an exhaustive FAQ section, the application Manual, and a Tutorial guide. With these materials, learning how to use GNUCash will be a play in the park. On top of that, you can subscribe to the mailing lists in case you need help or run into any problems with GNUCash.
Like many other open-source projects, GnuCash is entirely developed, maintained, and translated entirely by volunteers and enthusiasts.
GnuCash – Financial Accounting Software
31. LogicalDOC
Both available as Enterprise (paid) and Community editions, LogicalDOC is an award-winning, web-based Document Management System (DMS). As such, it aims to provide a high-quality method for sharing business documents and records in a low-cost and secure way.
Additionally, LogicalDOC allows you to control access to these resources via security roles, and to easily track changes through version control. LogicalDOC can be installed both on a single computer in standalone mode, on a dedicated server as a shared service, or as a Software as a Service (SaaS) solution.
LogicalDOC comes with features for content processing and information management that are more suitable for enterprises and businesses but it’s also great for personal use.
LogicalDoc Document Management System
33. Blender
If you are into game development, video editing, or 3D modeling, I am sure you must have already heard about this tool. If you are considering any of these activities either as a hobby or a career change and haven’t heard about Blender, it is definitely time to check it out.
As a FOSS solution, it does not come short when compared to commercial tools. On top of it, Blender is cross-platform which means you can not only run it on Linux but also on macOS and Windows.
Among the standard Blender features, you can find rendering, 3D modeling, digital sculpting, video editing, and simulation tools.
Blender – 3D Creation Suite
34. DVDStyler
DVDStyler is a cross-platform, FOSS DVD authoring tool that allows you to create nice-looking and professional DVDs with your video and image files.
As such, DVDStyler allows you to create your own interactive menus or choose from the built-in ones, add subtitle and audio files, and use video files in different formats. Additionally, you can create photo slideshows and place graphic objects like buttons, text, images, and so on.
In addition, this awesome tool integrates with your DVD burner to burn the disk from within the same application.
DVDStyler – DVD Authoring Tool
35. OSQuery
As its name suggests, OSQuery provides access to real-time system information in the form of tables and events that can be queried using SQL-like syntax via an interactive query console.
With osquery, you can explore your system to perform intrusion detection, diagnose a problem, or just produce a report of its operation – all at your fingertips using a single tool.
If you have at least a basic understanding of SQL, getting details about the operating system using the built-in tables in OSQuery will be a piece of cake.
OSQuery runs flawlessly on Windows, macOS, CentOS, and all other Linux OS released since 2011 and requires no dependencies.
OSQuery – Shows Real-Time System Information
Need yet another reason to convince you to give OSQuery a try? It was developed and maintained by the folks at Facebook.
36. KeePass
I have to deal with so many programs, websites, and services that I often forget my passwords. There is no doubt that this also happens to other Linux users, so here is the solution – KeePass. It’s a free open-source password manager that allows you to manage and keep your passwords in a secure way.
KeePass stores all of your passwords in a single database locked with a master key. That’s why you need to remember one single master key to access the database.
All passwords are encrypted using the most secure encryption algorithms. In fact, KeePass is compatible with the Advanced Encryption Standard (AES, Rijndael) and the Twofish algorithm.
Alternatively, KeePass allows you to use key files instead of master keys. You just need to always have the key file with you. For example, you can carry it on a floppy disk or USB stick.
KeePass Password Manager for Linux
37. PDF Mix Tool
I don’t often edit PDF files but when I do, I usually use PDF Mix Tool, which is a simple and lightweight open-source program that makes it possible to perform common PDF editing operations, such as file merging and page rotation.
Apart from that, you can also use PDF Mix Tool to generate booklets, delete and add pages to a PDF file, extract pages and even edit the PDF document information.
This tool is good for basic editing operations. If you need a more complex and powerful program, take a look at the best pdf editors for Linux.
PDF Mix Tool
38. Mailspring
When it comes to email management, one of my favorite tools is Mailspring, which is an open-source and cross-platform email client that allows you to create a single inbox for all your email accounts.
Mailspring is compatible with all popular email providers, including Gmail, Outlook, iCloud, Office 365, Yahoo!, etc., and supports IMAP/SMTP.
The Mailspring user interface is visually pleasing and there are a few beautiful themes. It also comes with a signature editor that allows you to create custom signatures, even with images and links to social media, which looks great.
Mailspring – Linux Email Client
39. OpenTodoList
If you work on several projects and have a lot of tasks to do at a time, you definitely need to try OpenTodoList, which is a simple note-taking application that allows you to stay organized.
With this tool, your information is organized in libraries. A library can contain to-do lists, notes, and images that are stored locally.
More importantly, you can synchronize your information with NextCloud, ownCloud, other WebDAV services, or any third-party synchronization tool of your choice. OpenTodoList lets you keep track of your tasks and enhance your productivity in a simple way.
OpenTodoList
40. ONLYOFFICE
Many Linux users have been lacking a decent Microsoft Office alternative for years. From my point of view, one of the best replacements for the MS Office suite is ONLYOFFICE, an open-source project that revolves around office software and productivity tools.
ONLYOFFICE offers a self-hosted office suite called Docs and a free desktop editor for Linux, Windows, and macOS. Both online and desktop editors are based on the same engine and allow you to create and collaborate on documents, presentations, spreadsheets, and fillable forms in real-time.
The ONLYOFFICE suite is fully compatible with DOCX, XLXS, and PPTX files and also makes it possible to open and view PDF and DjVu files. Conversion to DOCX is available, too.
ONLYOFFICE comes with integration apps for the most popular file-sharing and document management platforms, so you can embed the online editors to enable document editing and real-time co-authoring within Nextcloud, ownCloud, Moodle, WordPress, Seafile, etc.
ONLYOFFICE Docs
41. Internxt – Secure Cloud Storage
Internxt is a secure cloud storage solution built using open-source software. Internxt Drive is a free and private cloud storage platform allowing users to share and collaborate on files securely.
Internxt guarantees file security with end-to-end encryption. For maximum security, it encrypts your files directly on your device before they are transmitted to the internet, and you can share and collaborate with teams using advanced file-sharing features.
All tecmint readers can get 70% off on all Internxt lifetime plans. However, the company often has higher sales onsite that you can keep an eye on.
Internxt – Secure Cloud Storage
Summary
In this article, I have described free and open-source applications that I have found during the year 2023, and hope that it sparks your interest in one or more of them.
Would you like us to cover any of them in greater detail on this site? Have you found another great FOSS application that you would like to share with the rest of the community? Just let us know using the comment form below. Questions, comments, and suggestions are also welcome.

How to Install Multiple Python Versions on Ubuntu Using Pyenv

0
Linux Mint 22 XFCE Edition: New Features and Installation

In this tutorial, learn how to install multiple Python versions on Ubuntu using Pyenv without any conflict issues, and then create a separate virtual environment.
The post How to Install Multiple Python Versions on Ubuntu Using Pyenv appeared first on Linux Today.

Linux Scoop — Make Your Cinnamon Look Fresh and Elegant with…

0
image

Hey there, fellow Linux enthusiasts! Are you ready to elevate your desktop experience to a whole new level of sophistication? If you’re using Linux Mint 21.3 with Cinnamon 6.0, then you’re in for a treat. Today, we’re diving into the world of customization with the Orchis theme, featuring the Tela Circle icon pack. Get ready to transform your desktop into a sleek and stylish workspace that reflects your personality.Introduction to Orchis Theme and Tela Circle Icon PackFirst things first, let’s talk about what makes Orchis Theme and Tela Circle icon pack stand out. Orchis brings a modern touch to your desktop with its clean lines and elegant design. Combined with the Tela Circle icon pack, your icons will have a consistent and polished look, enhancing the overall aesthetic of your desktop.Customization SetupNow, let’s get into the nitty-gritty of how to set up this stunning desktop customization. We’re talking real-time clock and weather updates, current music playback information, unique Material Design-inspired wallpapers, and more. With just a few tweaks to the theme and main panel, you’ll have a desktop that’s both functional and visually pleasing.Real-Time Information WidgetsSay goodbye to boring static desktops. With Conky widgets, you can display real-time information right on your desktop. From the current time and weather conditions to what song is playing, you’ll always be in the know without having to open any additional apps. It’s like having your own personal assistant right on your desktop!Final Result and Additional ResourcesCurious to see the final result of this customization in action? Check out this video tutorial for a step-by-step guide: https://youtu.be/ja2ZAQqEwk0. And if you’re looking for even more customization options, be sure to explore these additional setups: https://youtu.be/JS_-BdXUMkY.Ready to get started? Download the necessary resources, documentation, and even a script for automatic customization:DOWNLOAD RESOURCESDOWNLOAD DOCUMENTATIONDOWNLOAD SCRIPT AUTO CUSTOMIZATIONConclusionAnd there you have it, folks! With the Orchis Theme and Tela Circle icon pack, along with some handy customization tweaks, your Linux Mint Cinnamon desktop will look fresher and more elegant than ever. So why wait? Dive in, unleash your creativity, and let us know in the comments below how you’ve customized your desktop. We can’t wait to see your unique creations!

Top 5 Best Bootable USB Creators For Linux

0
Top 5 Best Bootable USB Creators For Linux

We will go over all the major imaging software that this author has used to image multiple USB thumb drives and even a few disks. Like copying a hardware driver installation disk. This does not need to be hard. We will cover software that will help you image your USB on Windows, Mac and Linux. We will cover the use of dd, Rufus, Etcher, USBImager, and YUMI. Without further a due, let’s image some USB drives.

How To Check And Repair MyISAM Tables In MySQL

0
How To Repair MyISAM tables in mysql

MySQL tables can become corrupt for a variety for reasons such as incomplete writes, running out of space, the MySQL daemon  being killed or crashing, power failures.  If MySQL detects a crashed or corrupt table it will need to be repaired before it can be used again. This guide will walk you through detecting crashed tables and how to repair MyISAM tables.Find Crashed MyISAM Tables In MySQLUsually a table will show as corrupt in the mysql log, to locate the location of the log, you will be able to find it in my.cnf or you can view it directly in mysql by the following:MariaDB [(none)]> show variables like ‘%log_error%’;
+—————+——————————–+
| Variable_name | Value |
+—————+——————————–+
| log_error | /var/lib/mysql/centos7-vm2.err |
+—————+——————————–+
1 row in set (0.01 sec)You can then cat that logcat /var/lib/mysql/centos7-vm2.err|grep -i crashedThis will return any crashed tables that have been logged. Another way to check all of the tables is to used the mysqlcheck binarymysqlcheck -Awill check for all crashed tables# mysqlcheck -A
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
test.Persons OK
test.tablename OK
test.testtable OKLastly you can check a table directly through MySQL as well:MariaDB [test]> check table testtable;
+—————-+——-+———-+———-+
| Table | Op | Msg_type | Msg_text |
+—————-+——-+———-+———-+
| test.testtable | check | status | OK |
+—————-+——-+———-+———-+
1 row in set (0.00 sec)Repair a single MyISAM tableOnce you have located the table in need of repair you can repair it directly through MySQL. Once connected  type ‘use databasename’ substituting the real database name that contains the crashed table:MariaDB [(none)]> use test
Database changedAfter that all you need to do is type ‘repair table tablename’  substituting ‘tablename’ with the name of the crashed table:MariaDB [test]> repair table tablename
-> ;
+—————-+——–+———-+———-+
| Table | Op | Msg_type | Msg_text |
+—————-+——–+———-+———-+
| test.tablename | repair | status | OK |
+—————-+——–+———-+———-+
1 row in set (0.00 sec) Check And Repair All MyISAM TablesYou can do this quickly by using mysqlcheck with the following commandmysqlcheck -A –auto-repairYou will see each table followed by a status# mysqlcheck -A –auto-repair
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
test.Persons OK
test.tablename OK
test.testtable OKThis command will attempt to check and repair all MySQL tables  in every database on the server. That is it for repairing MyISAM tables in MySQL.Nov 9, 2017LinuxAdmin.io

A Look at the Best New Features

0
A Look at the Best New Features

Learn about the best new features of Linux Mint 22, “Wilma”.

Linux Mint 22 (code named “Wilma”), the latest long-term support (LTS) release, has arrived, bringing updated software, refinements, and a plethora of new features to enhance your desktop experience. This release will be supported until 2029 and features a Linux kernel 6.8 and an Ubuntu 24.04 package base.

Let’s dive into the details and explore what’s new in Linux Mint 22.

Linux Mint 22 Wilma Cinnamon Desktop

Linux Mint 22 Wilma: New Features

Core modules

At the core, you get the stable Ubuntu 24.04 LTS base, which will be supported until 2029. Those who want to upgrade from Linux Mint 21.3, wait for a few days until the Linux Mint team activates the upgrade process.

The new Ubuntu 24.04 package base, ensures better compatibility with modern hardware. Linux Kernel 6.8 and all the point releases of 22.x series will follow the HWE patches.

Moreover, a few more core updates as follows:

The default sound server has been switched to Pipewire.

The Software Sources now support the new Debian DEB822 format.

Themes have been updated to support GTK4.

JXL support has been added to Pix with a new thumb nailer implemented for it.

All software using libsoup2 has been migrated to libsoup3, and HiDPI support has been improved in the boot sequence, Plymouth, and Slick-Greeter.

Improved Language Support

The ISO of Linux Mint 22 is of 2.9 GB, same as the prior 21.3 release. This is specifically significant because, Ubuntu’s ISO size is in increasing in every release (desktop ISO). It’s wonderful to see the Mint team managed to keep the ISO size in check, while providing you all these features.

Linux Mint 22 installations now offer better localization and use less disk space, thanks to the removal of preinstalled packages for languages other than English and the one you select. This optimization saves a significant amount of disk space post-installation. Language packs for your selected language are downloaded if you’re connected to the Internet during the installation. Additionally, English, German, Spanish, French, Russian, Portuguese, Dutch, and Italian languages do not require an Internet connection since their language packs are present on the ISO image.

Preserving features for user’s benefit

An updated package base with Ubuntu does bring some issues for downstream distributions. For example, the forcing of Snap packages by removing native deb options for Thunderbird, Firefox etc.

Thunderbird, for example, continues to be available as a native .deb package, bypassing Ubuntu’s move to Snap. In earlier releases, the Linux Mint team followed the same process for the Firefox package.

The GNOME Online Accounts feature, previously affected by GTK4 migration, has been reintroduced via the XApp project, ensuring its availability in Cinnamon, Budgie, Unity, MATE, and Xfce.

Additionally, several GNOME applications have been downgraded back to GTK3 versions to maintain theme support, a core part of the Linux Mint desktop environments.

Improved Software Manager

The mintinstall Software Manager has received significant performance improvements. It now loads faster, with the main window appearing instantly. The application features enhanced multi-threading, a new preferences page, and a banner slideshow, making software management more efficient and user-friendly.

Linux Mint 22 introduces several measures to enhance the Flatpak package security to protect you and users. Verified Flatpaks now display their maintainer names, while unverified Flatpaks are disabled by default, with clear warnings about the associated security risks. This ensures you are well-informed and can make safer choices when installing software. By default, the option is turned off to hide all unverified apps from Flathub.

Unverified Flatpak apps from Flathub is now marked

Transition to Matrix

Following the discontinuation of Hexchat, Linux Mint has moved to the Matrix chat network, providing a more modern and feature-rich communication platform. Matrix offers persistent discussions, support for common chat features, and multimedia files, similar to platforms like Slack or Discord.

Linux Mint 22 includes a preinstalled Web App called Matrix, which connects users to the Linux Mint space on Matrix via the Element Web client. You need to create an account in Matrix for first time login.

New Matrix Client

Cinnamon 6.2 and other desktops

The Cinnamon 6.2 desktop environment in Linux Mint 22 brings several enhancements. The new Layout Editor allows users to organize Nemo actions neatly, with options to add separators and submenus. Bug fixes, performance improvements, and new features, such as better avatar support and workspace switcher improvements, enhance the overall desktop experience.

While the Cinnamon flavour gets the new update, the Xfce 4.18 and MATE 1.26 continue to see minor updates since the Mint 21.3.

Additional Improvements

In addition to the above, a considerable set of minor updates that added in this release, improving your experience for all flavours. Here’s a quick list:

Sticky notes app now available via command line and customized default position at startup.

Xed now features duplicate selected text

Improved Timeshift utility, enabling you not to delete snapshot accidentally.

xfce4-xapp-status-plugin tray applet in Xfce now supports configurable icon sizes.

Firefox Web applications created with the WebApp Manager feature a smarter menubar and toolbar

Download and Upgrade

If you are running Linux Mint 21.3, wait for a week to get official guideline to upgrade to this version. The Mint team will enable mintinstall for this version.

For fresh installation, you can visit the following page to download the ISO for Cinnamon, Xfce and MATE desktop.

The Edge ISO (with latest Kernel) will arrive later this year for this release.

Conclusion

The Linux Mint 22 team did an outstanding work to ensure to address user’s concerns and provide a solid desktop experience. This release ensures that Linux Mint always remains a top choice for all users, from beginners to advanced.

Overall, it’s a great release, with its long-term support mode, Xapps, native deb packages, great flatpak support, and under the hood updates.

Via Linux Mint blog.

RESOLVED. Temporary Suspension of CL Elevate Process on cPanel Systems

0
RESOLVED. Temporary Suspension of CL Elevate Process on cPanel Systems

The CL Elevate process on systems with cPanel has been temporarily disabled due to an issue with retrieving packages from CLN channels. This problem, if encountered, would halt the upgrade process, leaving the system in a half-functional state unless reverted to a pre-upgrade state.
To prevent users from unexpectedly damaging their systems, we have disabled the process for the time being. We apologize for any inconvenience caused.
Our team is focused on resolving this issue, and the upgrade process will be re-enabled once it has been resolved.
The approximate ETA is 05.07.2024
 
UPDATE Jul 11, 2024 
The previously encountered issues with retrieving packages from CLN channels have been resolved, and the CL Elevate process on cPanel systems is no longer blocked. CloudLinux packages providing Elevate functionality have been updated. Ensure the following versions are installed on systems intended for upgrade:

leapp-data-cloudlinux-0.2-9

leapp-upgrade-el7toel8-0.16.0-10

leapp-upgrade-el7toel8-deps-0.16.0-10

 
The Elevate-cPanel script should automatically update to version 46 upon initiation.
This resolves the temporary suspension announced previously.
 
 
 
 
 
 
 
 
 
 
 
 

Best Open Source LLMs for Coding

0
Best Open Source LLMs for Coding

AI is everywhere. One of the most important types of AI models is Large Language Models (LLMs). Of course, we are talking about the open-source LLMs (not the proprietary ones). While these LLMs help a great deal with generating text, helping you brainstorm with ideas, unleashing your creativity with images, they are also capable of helping you in the coding process. So, you can write code faster.For that, you need LLMs that are fine-tuned and trained with programming languages for you to get results geared towards coding. Here, I shall mention some useful open-source LLMs for coding, along with a couple of open GitHub Copilot alternatives.📋You can find all the open source LLMs on Ollama and get it installed locally without much hassle.1. WizardCoderWizardCoder is an open-source code Large Language Model (LLM) optimized on Llama 2. It can handle complex instructions well and has been fine-tuned accordingly.The Evol-Instruct algorithm used ensures that the model is fine-tuned with more complete and rich instructions, making the WizardCoder model shine for coding tasks. The model claims that it outperforms Gemini Pro, ChatGPT 3.5, and more, thanks to this algorithm. So, a pretty good LLM for an AI coding assistant.The latest release at the time, WizardCoder-33B-V1.1 is trained from deepseek-coder-33b-base. You can also use their variants like WizardCoder-Python-34B-V1.0. It is available in the Ollama library if you want to try it out.Suggested Read 📖Running AI Locally Using Ollama on Ubuntu LinuxRunning AI locally on Linux because open source empowers us to do so.2. Phind CodeLlamaPhind is one of the best AI search engines, but their code LLM is just as good. Phind CodeLlama is a code generation model based on CodeLlama 34B fine-tuned for instruct use cases. The model is trained on a dataset that includes high-quality programming problems and solutions. It was also trained using DeepSpeed ZeRO 3 and Flash Attention 2 in three hours on 32 A100-80 GB GPUs. To guarantee the accuracy of their findings, Phind utilized OpenAI’s decontamination technique on their dataset by extracting portions of text from each assessment case and verifying if there were corresponding matches in the trained examples.Two variations of the model exist: v1 and v2. v1 is built on CodeLlama 34B and CodeLlama-Python 34B. The v2 variant is just an iteration of v1, trained on an additional 1.5B tokens of high-quality programming-related data.3. Mistral7B and Mixtral-8x7BDeveloped by Mistral AI, both Mistral7B and Mixtral 8x7B hail themselves as the best models of their respective sizes. Mistral 7B has a 7.3B parameter and outperforms Llama 2 13B on benchmarks.I did find it running faster when using Ollama on my Ubuntu system.Some technical details: greater in size, Mixtral 8x7B is a Sparse Mixture-of-Experts (SMoE) model with 46.7B parameters. Although it has a large number of parameters, it only requires 12.9B parameters for each token.Both models can be fine-tuned according to the task you need to accomplish. However, it also works for coding.4. CodeBoogaCodebooga is a superb open-source code LLM, mainly because it is a merge of Phind-Codellama 34B v2 and WizardCoder-Python-34B-V1.0. It seems it is one of the best models to use for Python and JavaScript coding tasks.It features 33.4 billion parameters in total and could be better than the models merged when you evaluate it for your use-case.CodeBooga may not be as popular, but it is also available in the Ollama library for you to try.5. Code LlamaDeveloped by Meta AI, Code Llama is a specialized version of Llama 2. This model is trained on a code-specific dataset; hence, it can generate code and understand natural language about code from any prompts. There are four sizes of Code Llama, namely 7B, 13B, 34B, and 70B parameters respectively. All the different models serve different purposes and require various levels of resources. The 7B model can run on a single GPU. Comparatively, the 34B and 70B offer better results, requiring more resources. Overall, if you do not have much resources to spare, the 7B and 13B models can be a good pick.6. CodeGeeXCodeGeeX is one of the best GitHub Copilot alternatives, the first of its type on the list. It is a code-generation LLM with over 13 billion parameters, trained on more than 850 billion tokens.CodeGeeX offers some special features, such as Crosslingual Code Translation which allows you to translate code into different languages. It is also available for Visual Studio Code and other IDEs (Integrated Development Environment) for free as a customizable programming assistant. The integrations available for all kinds of IDEs make it a perfect Copilot alternative for many.With AI coding assistants like this on top of Ollama, you don’t have to rely on Google search queries, but just the LLM to help you out locally. Of course, you can replace GitHub Copilot with these solutions.7. TabbyTabby is one of the most feature-rich open-source GitHub Copilot alternatives actively being developed by the community. It can be used through many IDEs as an extension, such as Visual Code.One of the most impressive open-source self-hosted replacement to Microsoft’s Copilot AI.It can create code snippets from comments and contextual code and unlike some other copilot alternatives, it runs on your infrastructure. Written in Rust, Tabby is designed with performance in mind. You also have a live demo to test it out before installing it.Customization is straightforward with it. You have a number of open-source LLMs, like StarCoder, CodeLlama, and DeepseekCode, to choose from. You can also provide access to your repository model, so Tabby has more context. It can be a nice AI coding companion.8. StarCoderStarCoder is a code-focused LLM trained in over 80 programming languages, Git commits, GitHub issues, and Jupyter notebooks. It is trained on over 15 billion parameters with over 1 trillion tokens. The StarCoder models can analyze more input than any other open LLM, with a context length of over 8,000 tokens. While it may not be a popular option, it can be a good fit for an AI coding assistant.There also exists another version called Starcoder2 which consists of a dataset 4 times that of Starcoder. It also comes in three sizes, 3B, 7B, and 15B trained on 3.3 to 4.3 trillion tokens.9. Deepseek CoderThe Deepseek coder series offers models of size 1B all the way to 33B. Trained from scratch on over 2T tokens, it is a high-performance code LLM. It also showed exceptional performance when compared to proprietary LLMs such as GPT 4.Considering the origin team for the model is based in China, it has also been trained with Chinese language along with English.Deepseek coder’s 1.3B version offers lightning-fast task completion, while its 33B version can do the most complex of tasks with a 16K window size. You can utilize it as one of the most lightweight copilot alternatives.10. DolphinMixtralThe Dolphin Model is based on Mixtral 8x7B with additional datasets of Synthia, OpenHermes, PureDove, New Dolphin-Coder, and MagiCoder, making it a tab bit more efficient than Mixtral. Well, that’s an interesting mixture indeed.A point to note is the fact that this model is completely uncensored. DolphineMixtral is just a more fine-tuned version of the normal Mixtral without bias. You can tweak it for your use-case.Even with all the AI coding companions mentioned, you can utilize any open-source AI-powered chatbot as per your use-cases. I try to pick some of the best, but you have an endless list of choices that you can explore. Some of them can be found here:14 Top Open Source LLMs For Research and Commercial UseThere are hundreds of open-source LLMs, here, we handpick some of the best ones for you to check out.Wrapping UpThere are many open LLMs for coding, and some of them tailored to be utilized as open-source alternatives to Copilot. All of these LLMs are extremely capable and help you with almost all of your programming problems.Almost every LLM here delivers different-sized models for all kinds of usage. So, make your pick and get started!

Author Info

Swayam Sai Das is a student exploring the realms of Linux as an Intern Writer at It’s FOSS. He is dedicated, when trying to push ranks in FPS games and enjoys reading literature classics in an attempt of putting on an academic facade.