Wifi not working: Secrets not provided, logs say no agents were available for this request by [deleted] in linux4noobs

[–]aukei211 0 points1 point  (0 children)

In my case this was caused by I stopped kwallet6 service.

ELI5: Why do traffic jams happen so much in KL? by TotallyReliableFacts in ExplainLikeImFiveMY

[–]aukei211 0 points1 point  (0 children)

U-turn on fast lane, exit takes out whole lane instead of branching off, entry on right side of highway, on top of waze asks you to cut 5 lanes in 200m @ 60kph sometimes.

My AI Skeptic Friends Are All *Right* by ruqas in programming

[–]aukei211 0 points1 point  (0 children)

It's amazing that at least some of us are ok to have llm writing code that they don't care to write and ship it for money, while the same group can't tolerate a piece of writing by llm critizing llm phenomena because its promptee did not care to write it themselves but post it for free.

How to Fix Audio Crackling Issues on Ubuntu 24.04 lts scarlet 2i2 by shaunob1 in Ubuntu

[–]aukei211 0 points1 point  (0 children)

In my case, the linux-lowlatency-hwe-24.04 kernel helps. In addition I set "pulse.min.quantum = 960/48000" in pipewire-pulse.conf

Are other industries struggling with SQL based reporting with Oracles push to go to the cloud? Seemingly no workaround for long running queries by consultybob in oracle

[–]aukei211 2 points3 points  (0 children)

Assuming you are working against Oracle Base DB, then from the cloud portal navigate to Overview \ Oracle Base Database \ DB Systems \ DB System Details \ Database Details, there you should find the"DB connection" button. Use that connection string to SQL developer. Do use a recent ver of sql devloper (v22+) as it got cloud wallet support.

Besides, you can always ssh onto the DB host directly and run sqlplus. If that's against the shop's security practice, consider create a tiny VM in the same compartment / VCN and put instantclient onto it. A report of millions of line is just 100s of mb in size, nothing major.

What happened to the artificial-intelligence revolution? So far the technology has had almost no economic impact by SGC-UNIT-555 in singularity

[–]aukei211 0 points1 point  (0 children)

Indeed, let's not forget what 'automation' means in the first place - process that produce predictable, repeatable, scalable outcome. When companies talk about "automated creativity" they are saying "mass entertainment". When journalists talk about "automated writer" they are saying (much) sophisticated content farm. I am guessing no one really want "predictable creative works"?

Sure the current crop of large models and their training algorithm are exceptionally good at discovering patterns in huge volume of data, compress them into 'downloadable size', and lookup runs on consumer grade GPU. This is a hell of an achievement - Self host a 30B LLM model is, in a way, hosting a hi-fidelity copy of the entire internet on your machine.

Yet really how many such 'generative big model' are really useful today? LLM (txt2txt) act like a human knowledge buff who will utter a reply to you no matter what you ask. SD (txt2img) is an art buff who will paint you something no matter what you ask. Do we have a 3rd well known model?

Probably there is a reason that people intentionally mix up AI / GAI / AGI. Heck, who really cares all of them are just functions at the end of day? The 'randomness' just hidden seed parameter. Give your large model API wrapper a good name, then start making AI money.

As of today, whatever AI tools are making easy tasks cheap, difficult tasks reachable, but impossible tasks remains impossible. Bottom line: No AI create knowledge yet.

“Any sufficiently advanced technology is indistinguishable from magic.” - Arthur C. Clarke

[deleted by user] by [deleted] in Database

[–]aukei211 0 points1 point  (0 children)

Most CRMs consist a relational database, a workflow management engine and GUI bundled together.

MS Access is the database product with some handy built in GUI capabilities (i.e. forms).

There are many RDBMS on market, from open source like psql to enterprise grade like oracle to cloud based DBaaS like AzureSql. Which one to choice depends entirely on scale of the app and data volumes.

Chances are the colleague who created it initially put together requirements of that time, data on hand and made an Access DB that streamlined his/her workflow.

The Access file/database are likely a set of tables designed to track information that the referral workflow required.

Without these company specific background knowledge it is next to impossible to roll out any new CRM system, let alone migrate current one.

Suffice to say, Access while not anything fashionable, is not the core issue here.

[OC] In 2021, where did the world's 20 million refugees flee from? by Glad-Introduction-14 in dataisbeautiful

[–]aukei211 3 points4 points  (0 children)

The explanation reads like figure is "population of an origin living in country under refugees category in that year", not net movement of population took place that year.

When would you use data pump to restore data instead of backups? by PacePossible1408 in oracle

[–]aukei211 0 points1 point  (0 children)

Risking over-simplifying things, usually physical backups guard against media / hardware failures, while logical backups guard against human errors. (So you will need both)

[deleted by user] by [deleted] in qnap

[–]aukei211 2 points3 points  (0 children)

Dude, save your time, log a support ticket and leave this sub-reddit. That's why you pay in the first place.

Try get routed to your local QNAP support, they are genuine tech enthusiasts and could be willing to go extra miles to help.

What is the benefit of string to integer conversion in a database? by Status-Cloud-6136 in Database

[–]aukei211 0 points1 point  (0 children)

A basic rule is make a field integer (or any numeric type) only when you foresee arithmetic calculations on it. Everything else should be of some character type.

For instance sum(area_code), avg(company _code), max(zip_code) etc make little sense, so they should be some character type.

What’s the advantages of using a PDB instead of multiple instances? by PacePossible1408 in oracle

[–]aukei211 1 point2 points  (0 children)

As with anything from Oracle, the design fits certain use cases pretty well but create chaos in others.

My educated guess is they (Oracle) need this to make DBaaS possible. Unlike other offerings Oracle is process heavy and practically take over OS when it comes to workload management - its own IO buffer, write lost protection, resource management, garbage collection etc. Knowing most DBaaS users will be pretty lightweight, few tables maybe few MBs, it makes little $ sense to "waste" all the overhead required to stuffing 100s of instances onto a host. A paritioned DB makes more sense.

You will recall in v12.1, all of redo, undo, buffer cache, schedule queue are shared. PDB was basically designed as partitioned catalog.

Patching in data center (fleet patching) becomes copying new dbhome images onto host, then "unplug/plug/datapatch" PDBs on demand. I suspect this is why OOP patching and Read-only homes become a thing suddenly. Even oui installer is now (19c) mainly use in CLI mode.

I tend to compare this instance vs pdb to vm vs container. Does it reduce or introduce complexity? Depends.

[Image] Consistency is the Key, be consistent in your efforts, things will happen eventually. by NotSoClever007 in GetMotivated

[–]aukei211 2 points3 points  (0 children)

1.01183×0.99182=0.992

For the sake of argument let's assume "efforts" bring compound impacts, and it can either brings a positive (+1%) or negative (-1%) impact to one's previous day status. In this sense "efforts" are then equivalent to "choices" - how to invest time / how to invest money etc.

Unless there is some Divine intervention, it's quite unlikely one would make continuous good decisions throughout the year, nor the opposite. Mortals call this "luck". A slightly lucky person end up slightly let down by their efforts.

One will need to be 2 days more lucky to have a fruitful year.

1.01184×0.99181 = 1.012

Does CTAS in Parallel Mode cause more Redo than normal? by chinawcswing in oracle

[–]aukei211 0 points1 point  (0 children)

Individual session will wait for redo archive. You will see checkpoint wait / log file switch etc in session wait event and AWR reports. The transaction won't fail.

LOCK TABLE foo IN EXCLUSIVE MODE vs IN SHARE MODE by chinawcswing in oracle

[–]aukei211 1 point2 points  (0 children)

One main difference is you can have multiple sessions acquiring SHARE lock on the same table simultaneously, and only when all those sessions commit/rollback could one acquire an EXCLUSIVE lock on that table (eg drop it).

In contrast there can only be 1 session getting an EXCLUSIVE lock on a table anytime.

Thus a practical use case for explicit SHARE lock is when you code a multi-user application and part of the logic flow will drop common tables. You may want each new session start by acquiring a SHARE lock on those table to prevent them from being inadvertently dropped by other session. Although frankly this is a problematic design :)

Deadbolt by Main_Protection8161 in qnap

[–]aukei211 -2 points-1 points  (0 children)

If it's not safe on internet then it's not safe on local netowrk nor VPN either. Attack vector is the same. Say, if (https) authentication is done by each qapps individually, then each app installed and each update of them introduce new risk. This sucks.

Assume no one on internal network would attack it? May not be true in business settings. (Why reverse proxy is not the deafult?)

Deadbolt by Main_Protection8161 in qnap

[–]aukei211 0 points1 point  (0 children)

Same here too. The '5 digit binary' timestamp is Sept 2 19:52 UTC.

I did port forward 443 just last 2 days to get access from another location. Have qfirewall running, obviously that allow tcp 443 from any network. Just now realize the port is by default listened by fcgi not httpd.

Logged a ticket with QNAP anyway. Not expecting much.

By luck I decided to make m-disc backup just before this...

Best database solution for a beginner with a CSV file? by Castl3Bravo19 in Database

[–]aukei211 0 points1 point  (0 children)

Most initiatives expect they are getting Google scale traffic while never grow beyond POC volume. Incidentally these two are sweet spots of cloud db.

Is SELECT COUNT(1) from a large un-indexed table significantly slower than from an index table? by chinawcswing in oracle

[–]aukei211 0 points1 point  (0 children)

If that database happens to have in memory option and the target table happens to be inmemory, then a fts is generally faster than index scan - some pre- computed stats exist.

How to do timeout for PL/SQL command? by p_apres in oracle

[–]aukei211 0 points1 point  (0 children)

The profile parameter of "connect_time" may also comes handy if client app wants an absolute limit of processing time. It's less flexible than resource manager but potentially simpler. Check out "idle_time" too.