Linux

Linux

Application and Data / Languages & Frameworks / Operating Systems
Needs advice
on
JavaScriptJavaScript
and
LinuxLinux

Issue Monitoring Database on Linux Laptop!

Hello everyone,

I'm having trouble monitoring my database on my Linux laptop. Whenever I try to access the database, I'm unable to view the data and I get error messages.

I've checked that the database is running properly, but that hasn't helped. I've also tried accessing the database from a different device, but the same issue occurs.

Has anyone else experienced this issue? Any suggestions on how to successfully monitor a database on a Linux laptop?

Thanks in advance.

READ MORE
6 upvotes·30.5K views
IT Specialist ·

I am a Microsoft SQL Server programmer who is a bit out of practice. I have been asked to assist on a new project. The overall purpose is to organize a large number of recordings so that they can be searched. I have an enormous music library but my songs are several hours long. I need to include things like time, date and location of the recording. I don't have a problem with the general database design. I have two primary questions:

  1. I need to use either MySQL or PostgreSQL on a Linux based OS. Which would be better for this application?
  2. I have not dealt with a sound based data type before. How do I store that and put it in a table? Thank you.
READ MORE
7 upvotes·577.3K views
Replies (6)

Hi Erin,

Honestly both databases will do the job just fine. I personally prefer Postgres.

Much more important is how you store the audio. While you could technically use a blob type column, it's really not ideal to be storing audio files which are "several hours long" in a database row. Instead consider storing the audio files in an object store (hosted options include backblaze b2 or aws s3) and persisting the key (which references that object) in your database column.

READ MORE
7 upvotes·426.3K views
Recommends
on
PostgreSQL

Hi Erin, Chances are you would want to store the files in a blob type. Both MySQL and Postgres support this. Can you explain a little more about your need to store the files in the database? I may be more effective to store the files on a file system or something like S3. To answer your qustion based on what you are descibing I would slighly lean towards PostgreSQL since it tends to be a little better on the data warehousing side.

READ MORE
5 upvotes·426.2K views
View all (6)
Team Lead at XYZ·
Needs advice
on
MetricbeatMetricbeat
and
PrometheusPrometheus

Hi, We have a situation, where we are using Prometheus to get system metrics from PCF (Pivotal Cloud Foundry) platform. We send that as time-series data to Cortex via a Prometheus server and built a dashboard using Grafana. There is another pipeline where we need to read metrics from a Linux server using Metricbeat, CPU, memory, and Disk. That will be sent to Elasticsearch and Grafana will pull and show the data in a dashboard.

Is it OK to use Metricbeat for Linux server or can we use Prometheus?

What is the difference in system metrics sent by Metricbeat and Prometheus node exporters?

Regards, Sunil.

READ MORE
2 upvotes·531.9K views
Replies (2)
Recommends
on
Prometheus

If you're already using Prometheus for your system metrics, then it seems like standing up Elasticsearch just for Linux host monitoring is excessive. The node_exporter is probably sufficient if you'e looking for standard system metrics.

Another thing to consider is that Metricbeat / ELK use a push model for metrics delivery, whereas Prometheus pulls metrics from each node it is monitoring. Depending on how you manage your network security, opting for one solution over two may make things simpler.

READ MORE
5 upvotes·1 comment·325.7K views
Manish Sharma
Manish Sharma
·
July 23rd 2021 at 9:41AM

This is perfect answer.

·
Reply
Needs advice
on
FedoraFedoraLinux MintLinux Mint
and
UbuntuUbuntu
in

I want to learn hacking. which Linux best for me.

READ MORE
1 upvote·7.7K views
Replies (2)
Recommends
on
Kali Linux

most people would recommend kali linux .. it's a debian based distro designed for cybersecurity needs .. so it's useful for hacking/ penetration testing

READ MORE
1 upvote·48 views
Internet creator. at Space Babies·

Here you go: Vulnhub

It is a list of Linux virtual machine you can use, to complete challenges. Like, "it's your goal to hack this machine in 3 hours!". Also, you're not hacking actual servers. It's all safe and you cannot cause damage.

Good luck!

READ MORE
1 upvote·94 views
Data Manager at The Garrett Group·
Needs advice
on
LinuxLinuxpgAdminpgAdmin
and
PostgreSQLPostgreSQL

There is a question coming... I am using Oracle VirtualBox to spawn 3 Ubuntu Linux virtual machines (VM). VM1 is being used as a data lake - just a place to store flat files. VM2 hosts Apache NiFi. VM3 hosts PostgreSQL. I have built a NiFi pipeline that reads flat files on VM1 and then pipes the data over to and inserts it into the Postgresql database. I left this setup alone for a while, and then something hiccupped on VM3, and I had to rebuild it. Now I cannot make a remote connection to Postgresql on VM3. I was using pgAdmin3 on VM3, but it kept throwing errors - I found out it went end-of-life in 2018 and uninstalled it. pgAdmin4 is out, but for some reason, I cannot get the APT utility to find/install it. I am trying to figure out the pgAdmin4 install problem and looking for a good alternative for pgAdmin4 that I can use to diagnose the remote database connection problem. Does anyone have any suggestions? Thanks in advance.

READ MORE
8 upvotes·354.5K views
Replies (1)
Recommends
on
phpPgAdmin

If you want an alternative to pgAdmin there is phpPgAdmin and it's also Open Source like pgAdmin, which is just like phpmyadmin which works for MariaDB and MySQL. I have not used it as I run pgAdmin4 in a Docker container.

Difference here is if you like to SQL edit, then pgAdmin is the best solution as it provides syntax highlighting whereas phpPgAdmin does not. Hope this is useful enough.

EDIT: Otherwise a good idea is to read on the differences between the two. Though I believe it as a personal preference.

READ MORE
5 upvotes·291 views

Hello, we have a bunch of local hosts (Linux and Windows) where Docker containers are running with bamboo agents on them. Currently, each container is installed as a system service. Each host is set up manually. I want to improve the system by adding some sort of orchestration software that should install, update and check for consistency in my docker containers. I don't need any clouds, all hosts are local. I'd prefer simple solutions. What orchestration system should I choose?

READ MORE
4 upvotes·163.6K views
Replies (1)
DevOps Architect ·
Recommends
on
Docker Swarm

If you just want the basic orchestration between a set of defined hosts, go with Docker Swarm. If you want more advanced orchestration + flexibility in terms of resource management and load balancing go with Kubernetes. In both cases, you can make it even more complex while making the whole architecture more understandable and replicable by using Terraform.

READ MORE
7 upvotes·149.6K views
Needs advice
on
AnsibleAnsibleChefChef
and
Puppet LabsPuppet Labs
in

Personal Dotfiles management

Given that they are all “configuration management” tools - meaning they are designed to deploy, configure and manage servers - what would be the simplest - and yet robust - solution to manage personal dotfiles - for n00bs.

Ideally, I reckon, it should:

  • be containerized (Docker?)
  • be versionable (Git)
  • ensure idempotency
  • allow full automation (tests, CI/CD, etc.)
  • be fully recoverable (Linux/ macOS)
  • be easier to setup/manage (as much as possible)

Does it make sense?

READ MORE
Chef vs Puppet vs Ansible vs Saltstack: Which One to Choose | Edureka (edureka.co)
10 upvotes·250.1K views
Replies (3)
Principal Engineer at RaiseMe·
Recommends
on
Ansible

I recommend whatever you are most comfortable with/whatever might already be installed in the system. Note that, for personal dotfiles, it does not need to be containerized or have full automation/testing. It just needs to handle multiple OS and platform and be idempotent. Git will handle the heavy lifting. Note that you'll have to separate out certain files like the private SSH keys and write your CM so that it will pull it from another store or assist in manually importing them.

I personally use Ansible since it is a serverless design and is in Python, which I prefer to Ruby. Saltstack was too new when I started to port my dotfile management scripts from shell into a configuration management tool. I think any of the above is fine.

READ MORE
9 upvotes·59.3K views
Recommends
on
Salt

You should check out SaltStack. It's a lot more powerful than Puppet, Chef, & Ansible. If not Salt, then I would go Ansible. But stay away from Puppet & Chef. 10+ year user of Puppet, and 2+ year user of Chef.

READ MORE
6 upvotes·60.6K views
View all (3)
Needs advice
on
Arch LinuxArch Linux
and
Kali LinuxKali Linux
in

I do find Linux-based systems to be cool! However, I am confused when it comes to which Linux operating system to use. I cannot make my mind between Arch Linux and Kali Linux. Guys, give me some advice if you would be so kind.

READ MORE
4 upvotes·51.8K views
Replies (10)
Recommends
on
Kali Linux

I've been using arch linux for the past 3 years, but I don't recommend Arch Linux if you just jumped into Linux System, a debian based linux like kali, ubuntu or debian itself is more beginner friendly and kali can be used to learn security and pentesting. if you want to learn in a hard way, arch linux is a good option.

READ MORE
7 upvotes·1 comment·254 views
Hi-Angel
Hi-Angel
·
April 21st 2023 at 7:05AM

You clearly don't know what Kali is about. It's even worse for beginners, see https://unix.meta.stackexchange.com/questions/5360/why-is-kali-linux-so-hard-to-set-up-why-wont-people-help-me

·
Reply
Owner / Head of Tech Dev at dotVIBE Digital Alchemy / Alchemyst.io·
Recommends
on
Arch Linux
Manjaro

Hey there,

I have been a huge fan of Linux ever since I was as kid, about 13, or 14 years old. I started off toying around with Ubuntu and even then I found it to just be, well, pretty inconvenient. The good news is, this is really no longer the case - there is a much much great amount of widespread support for Linux as well as program alternatives to your typical Windows or macOS suites, and i think it was about a year, almost a year and a half ago that I made the full switch to Arch. Now, I wanted to recommend one particular flavor of Arch Linux that I think you will really enjoy, and there is truly something for everybody. You'll notice I marked both Arch Linux & Manjaro, and while those are both going to be good experiences - albeit, Arch is going to be much more, well, as they say, "the Arch Way" (don't let that intimidate you - you will need to read the wiki, the forums, don't be afraid to ask questions etc, but as long as you do those things, it's honestly just a matter of following instructions) - And with Manjaro, you're going to have a lot more stability.

What I would much rather recommend and I honestly can't stress how great these guys are in particular enough! That would be Arco Linux - they are a project that will walk you from Point A - your very first Arch-flavored install - to point Z and beyond, where you will learn the skills to even build your own Arch ISO images and essentially make your own custom Arch flavors! It's a great deal of fun and I can't even tell you how helpful the whole community is.

I didn't see them listed on the drop-down selections, but please don't hesitate to look them up. Second to that, I would suggest Manjaro. Then Arch would be third, but I would still recommend that, if you find it challenging, you go with a project that isn't really "traditional" Arch, but perhaps an Arch installer such as Arch Labs, or Anarchy Installer. Manjaro also has Manjaro "Architect" and it's a good tool for have "TUI" (terminal user interface, go not quite 'graphical') guiding you through the process, but it's also not going to stop you from breaking stuff lol. That's really meant to be the experience - you go through trial and error and learn and quite frankly will continue to make mistakes but it's ALWAYS rewarding to learn new things, even years later! Even stuff you may think "crap, why did I not realize this!?" after 2 years of daily use haha. It's a wonderful experience and offers a lot of opportunity for growth and understanding of *nix operating systems in general.

I think a great learning path would be to start with Arco Linux - just go to their website, and it will seriously walk you right on through it and hold your hand the whole way - if you want!! - you can also jump as far ahead as you feel comfortable! And then, once you start to get the hang out things and really feel like you understand it, I would recommend trying out some of the more modern and complex filesystem architectures. The most common would be something like LVM or LVM on LUKS (Luks is a disk-encryption, and LVM is Logical Volume Management, and enables you to take atomic "snapshots" for quick data recovery among other neat things), and there is also BTRFS, and ZFS, and all sorts of combinations and configurations.

The second option of Manjaro is going to be just as enjoyable as well I am sure, and you can even get acquainted with a more familiar interface that way if you prefer, and then work your way toward the more complex stuff. I promise it will only be complicated to others when you are explaining it with excitement ;) It truly is a lot of fun, especially if you like troubleshooting.

Now, as far as Kali is concerned, you should understand that it's not going to offer you much if you're really considering Arch vs Kali like you say. I say this because, the tools which Kali comes equipped with, are very intentionally and specifically designed for sophisticated penetration testing (hacking, if you like). If you are looking to get into hacking some stuff, and I will just assume for good reason ;) Then even still... I think Arch is your better bet. You need to have an understanding of what it is you are trying to break into before you will even begin to become proficient at it. Just imagine if I handed you a full soldering it, complete with micro-electronic bread-boards and circuitry blueprints, and I told you it was all in front of you for you to assemble a component, that you had no idea what would even be doing in the bigger machinery it was destined for. Well. I think it's kind of like that. Now, there are certainly discrepancies between bones that make up both Arch and Kali, but they are very similar with the exception of their package management systems, which are mostly what you will be learning to deal with first. Both of these systems (unless you chose an even more alternate route, such ad Void Linux, which is well, Arch, but lacking a very key .... uhm... You know, that is where it gets tricky! But interesting) My Point is, there are enough similarities betwen t the two systems at a core level, but at the same time, they are radically different.

Here's how you should weigh it, in my humble opinion: 1) Do you want to learn intricacies of the underlying systems? 2) Do you want to be presented with an easy to use interface, but with a bunch of tools you don't maybe have use for, or at the least, will have to learn and all of which have different purposes that are very specific? 3) Do you want to have the freedom to expand and build in any direction you please? 4) Do you want to specifically go down the "hacker" path?

Well, 1 and 3 are explicitly Arch I am referring to, and as you probably guessed, 2 and 4 are Kali... but also Arch!!! You can form it into ANYTHING you want. There is even (I would argue) MUCH more radical, fully equipped "hacker" suite called Black Arch that you can just ... install on your Arch System that you already have running, if you wanted to one day. Or install it outright from the beginning!

Hope this helps! Here are some links :) ARCO Linux Manjaro Linux GitHub - Various Arch Install Scripts/Guides Anarchy Linux - Arch Linux Installer ARCHFI - ArchLinux Fast Installer ALIS - Yet another ArchLinux Installer/Helper!

These are just what I have come up with very quickly. There are many more! I encourage you to go to DistroWatch and look at some of the Arch derivatives there as well!!

DistroWatch - Arch-based Distributions

Among the top listed there you will find Manjaro and ArcoLinux, as well as another fantastic derivative called EndeavourOS

Honestly, I hope you have a ton of fun!! I know it's brought me lots of joy and I am happy to be able to share just a bit of it with you if only the resources to get you started!!!

Cheers!

READ MORE
5 upvotes·4 comments·218 views
Dmitry Golub
Dmitry Golub
·
September 1st 2021 at 6:55PM

Personally I am a long-time Arch user and now I use Manjaro on (almost) all my hardware machines. Virtual machines (VMs) are another matter, the distribution depends of VM role.

Manjaro is more stable version of Arch.

·
Reply
Alchemyst
Alchemyst
·
September 5th 2021 at 2:47AM

Certainly, a lot of that is definitely attributed to their vetting of updates as opposed to the classical rolling-release approach, not to suggest they aren't rolling AFAIK nowadays, of course.

Ironically... I am using Ubuntu for some VM's hah. For a server, I actually found it's really handy to keep a really minimal installation of vanilla Arch, locked down pretty hard of course, but on a small partition to boot into just in case you have to do some odd repairs that were server-breaking - which for me, heh... Well I like having that installation :)

Recently I've just begun using Artix Linux and was looking at Obarun and Parabola. I have to say ... the transition is only really noticed when I am dealing with any other systemd OS - things do feel a bit more natural, for instance even though it's a totally different beast, I've got Rocky Linux up and running on a bare metal testing rig right now & I love it because everything comes naturally hah. But aside from that... I would actually highly recommend, if you ever feel up to some disro-hopping, like if that's you're thing lol - definitely give an OpenRC init OS a try. I even played with Gentoo which was ... fun, and took quite a while haha.

Cheers.

·
Reply
Rohith Duraiswamy
Rohith Duraiswamy
·
September 25th 2021 at 8:03AM

I wouldn't recommend manjaro, if you install packages from the AUR, and you most probably will. They hold back the AUR updates for a week. And since arch is a rolling distro, this breaks the system. Quite often.

·
Reply
Alchemyst
Alchemyst
·
September 25th 2021 at 6:04PM

I agree with you here, hadn't necessarily factored in how they handled the AUR packages ... actually that is surprising to me only because it would seem as though yay, paru, trizen, whatever it is you're using as you're AUR helper, would normally be point directly to https://aur.archlinux.org/ no? I have never looked into it so far. Now, I definitely have had issues with stuff that they, or likewise other Arch-based distros, have chosen to include from the AUR a packaged version in their own repos. Good example would be a lot of the minor changes in pacman.conf - seems like recently when this happened, a lot of those packages just busted lol. Well really I am complaining too much. It was just yay and easily remedied at that heh.

EndeavourOS seems to be taking the charts now from what I have heard in terms of the more popular "easy" Arch. Kind of interesting how they have grown pretty nicely and I feel they do have a stable product. Plus much less .... hmmm... not sure of the word I want to use here. Let's just say, the minor frustrations of trying to something like, for example, build some packages in a cleean-chroot with devtools. Oh, what is that you said? No no no... we have a manjaro-specific version in fact lol. Then you end up not building a custom install or whatever you set out to achieve, but you get all of that damn branding and stuff too.

·
Reply
View all (10)
CEO at Stealth Startup·
Needs advice
on
PyQtPyQtReact NativeReact Native
and
XamarinXamarin

We are developing an AWS IoT app for large boats. The IoT devices have sensors all over the boat for engine oil pressure, position, water depth, fuel level, crew location, etc. When the boat has internet, we interact with AWS cloud using lambda and Amazon DynamoDB. When the boat is offshore, the captain and crew still need normal and emergency alerts and real-time sensor information. The crew might have an Android or IoS phone or a Windows or macOS PC to receive alerts and interact with sensors. We may use the AWS GreenGrasss edge computing solution and either MQTT or HTML for that function.

Question: We want to develop a cross-platform client to run on Windows, Mac, Android, IOS, and possibly Linux. We are primarily Python programmers, so PyQt or Kivy are options for us, but we have heard good things about React Native, Flutter, Xamarin, and others. We think an AWS Greengrass core on an RPI4 could communicate to the client with MQTT or a local webserver with a client web interface.

Any thoughts would be much appreciated.

READ MORE
7 upvotes·433.2K views
Replies (2)
Recommends
on
React Native

I don't know much about Xamarin but I know about PyQt and React Native.

However, I don't recommend PyQt because the apps made using PyQt are not that suitable for mobile apps. If you take a look at the PyQt interface, you will be able to see that the features are more of a desktop apps kind.

React Native uses JavaScript. React Native is immensely flexible in upgrading your apps because it allows you to formulate your app code into independent blocks.

In Xamarin, you have to write the code in .NET . The best thing about Xamarin is, that it extends the.NET developer platform with tools and libraries specifically for building apps for Android, iOS, tvOS, watchOS, macOS, and Windows

While the best choice for you depends on various factors but React Native app development is a promising overall choice. In today’s scenario, React Native has steady growth, flawless code structure, and brilliant and large community support. We suggest you go for React Native for your next project owing to its outstanding support from developers, easy availability, and cost-effectiveness.

READ MORE
5 upvotes·65.8K views
Founder at The First Prototype·

It seems like your app is not really using any native functionality on the phone. I have experience with cross platform iOS & Android development. They are all really good tools! Xamarin (all the project on the website portfolio I attached) is awesome for accessing native functionality (NFC, Sensors, Bluetooth, etc), and I have built apps that have millions of downloads, some that hit Top 5 on Utilities, another that hit Top 50 in Finances. You just have to look at what your application intent is, it seems like it's just to read and post data. For that they are all pretty good, but you should also look into Ionic which may serve the same purpose

READ MORE
The First Prototype (thefirstprototype.com)
4 upvotes·45.4K views

Out of curiosity, when my coding instructor for Python did some commands on his computer, he told me learning any sort of terminal command interface (e.g. GNU Bash, PowerShell, Zsh ) will make me understand systems and how computers work and would make me know the basics of systems programming (although I am more into web development). I immediately went curious, out of my time, and looked up some command line interfaces to learn. It gave me bash, shell, zsh, powershell, etc. All these are really confusing, and they all seem the same. I want to be a terminal dweller, so which of the terminal related things should I learn? I think Bash, since it can replace Powershell on Windows, and has all the Linux/macOS systems.

READ MORE
5 upvotes·28.5K views
Replies (2)
Astrophysicist / Principal SOE at ESA / ESOC / OPS-OAX, Telespazio VEGA Deutschland·

Well, it is alway a matter of taste.

But to share my own experience, using Unix Shells ever since 1988, and also PowerShell for some period of time. If you want to script Windows OS as an Administrator, PowerShell is a good option. If you want to administer all different kinds of UNIX OS, bash will be available on almost all of them. If you want to develop software and have the freedom to choose, I recommend zsh, better yet oh-my-zsh.

READ MORE
4 upvotes·1 comment·510 views
Yoram Kornatzky
Yoram Kornatzky
·
June 4th 2022 at 3:16PM

Try the Linux kind of shells. Best zsh but bash is also good. They are for Linux and MacOSX. The Windows PowerShell has no use outside Windows. It will expand your understanding of programming. As you will learn the concepts of pipes, input and output redirection, and the general use of command-line tools. It is a must for any serious student of programming and more importantly for programmers in general.

·
Reply
Escaped Notions·
Recommends
on
GNU Bash

I use GNU bash - the latest version, currently 5.2 - as my daily driver, on macOS, Linux, and Windows regularly.

I do this because modern bash has features comparable to zsh with the largest community.

On Windows, I use git-for-windows bash which is GNU bash compiled via the msys2 project, which also bundles various GNU/Linux core utilities. If you're using Windows, you should get to know the https://msys2.org/ and https://gitforwindows.org/ projects, which themselves rely on cygwin. Mainly keep in mind the helper cygpath to convert paths back and forth - some things will need Windows style paths.

You can also easily call powershell from bash.

READ MORE
4 upvotes·55 views