The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can’t find any matching row in the user table)

One of my proactive management customers came up to me today with an issue he’s been having on one of his cPanel/WHM servers: he has been trying to add a user to a database he created and he received this error:

The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can’t find any matching row in the user table)

Apparently commenting out skip-name-resolve in /etc/my.cnf fixed it.

then run a MySQL server restart with: /scripts/restartsrv_ mysql and you should be good to go.

How to fix -> npm ERR! cb() never called!

npm install
npm ERR! cb() never called!

npm ERR! This is an error with npm itself. Please report this error at:
npm ERR! <https://npm.community>

I got this error today on a cPanel server where i am running a node.js app that’s reversed proxy to, by Nginx. The error happens when trying to run “npm install” on a large project where roughly 1200 modules should be installed. What happens is that not all of them got installed and some were missing the binaries.

After doing a ton of googling, i found that the ulimit might be an issue, so i went ahead and disabled “Shell and fork bomb protection” that limits the ulimit to 100.

Restart the shell and npm install worked without issues due to having ulimit set to 4096.

Good luck!

De prin 2013

Acum am stat si ma uitam la articolele din urma sa imi dau seama cam pe cand am oprit firul povestii. Geez, nu am mai scris nimic personal de prin 2012-2013. Oricum am devenit un pic mai senil ca nu mai imi aduc aminte bine de tot ce faceam pe atunci, asa ca o sa condensez un pic lucrurile intr-un sumar:

  • Cateva vacante interesante
  • Schimbat de vreo 2 ori job dar eventually am gravitat tot spre a lucra pt mine, freelancing and stuff
  • Am adunat mai multa experienta in materie de: network architecting, Security, DevOps, Docker, AWS, cloud infrastructure.
  • Am participat la un accelerator cu un start-up la care inca lucrez, si am facut demo in New York, am iesit pe locul 9 din vreo 5500 participanti. (au acceptat pe primii 8 – life sucks)
  • Am lucrat cam 1 an si jumatate sa fac un joc in VR dar l-am inchis dupa o vreme pt ca nu ne indreptam spre directia buna si era destul de inceata treaba, dar am invatat o tona de chestii faine. Poate cand o sa am timp/partenerii potriviti si fonduri o sa reiau lucrul la Sjoc dar momentan it’s on ice. Ce am lucrat se poate vedea aici: https://www.spinningboxvr.com/
  • Start-upul la care lucrez momentan – am reusit sa achizitionam primii 2 clienti si suntem in productie. Se pare ca o sa fie bine, dar mai trebuie efort.
  • Nu mai stau in chirie. Got own home now.
  • Got a baby boy!
  • Am cumparat prima mea masina noua.
  • Am cunoscut o tona de oameni interesanti.
  • Am devenit foarte implicat in crytocurrencies.
  • I became unlocked 🙂
  • Am slabit, m-am ingrasat, sunt in proces de slabire din nou.
  • Sper ca am devenit un pic mai destept si sper sa nu repet greselile din trecut.

Cam asta e sumarul la chestiile care s-au intamplat. Nu cred ca am stat degeaba si sper sa fac si mai multe in viitor. Trebuie doar sa imi modific programul bine si sa power through things.

Life is good.

Voi cum mai sunteti?

Ubuntu how to right click and scroll

I have not been using my Ubuntu laptop touchpad for ages, but recently i have been traveling and i am taking my laptop out every day, so i have to use the touchpad way more frequently.

A wrench got thrown in my thinking process when i saw i cannot right click or edge scroll but it looks like this behavior was just changed. If it’s simpler or not it’s for you to judge:

Right clicking in Ubuntu is now achieved by using 2 fingers to click on the touchpad.

Edge scroll seem to not be working anymore, however you can scroll by using 2 fingers instead of one, anywhere on the touchpad.

Happy Ubuntu-ing!

Ubuntu – close Discord but notifications still come

So i am using Discord a lot and i have encountered this problem more than once: you close Discord but the notifications still come even though the icon in the systray is not there. Pretty annoying right?

I found 2 cool things to deal with this:

1 – https://extensions.gnome.org/extension/1031/topicons/ – install topIcons Plus – this will show you the systray at the top and if you close any program from there, it really stays closed.

2 – press “control+q” while having Discord opened. – same result.

Enjoy!

Atat de multe

Iar incep asa cum incepeam odata sa spun 🙂 S-au intamplat multe, atat de multe schimbari si atat de multe lucruri noi. O sa dureze ceva sa impartasesc tot.

Era un obicei fain sa scriu pe blog din chestiile interesante care mi se intampla. Cred ca ajuta un pic si sa revizitez actiunile din trecut, si sa constientizez mai bine si daca se poate, sa invat mai mult din experientele avute, fie ele bune sau rele. It’s all part of the game!

Nu stiu daca mai citeste cineva, dar as vrea sa fac asta in primul rand pentru mine. E un proces bun si imi pare rau ca am uitat sa il folosesc in viata de zi cu zi.

Am mai citit din postarile din trecut si am zambit. Multe chestii au fost distractive. Cred ca am evoluat, si cred ca mai sunt povesti care merita spuse, asa ca am inceput cu o mica curatenie, am schimbat tema sa fie foarte minimal si … nowhere to go but up.

In continuare o sa mai existe posturile in engleza despre tech si chestii care le pastrez in jurnal pentru ca sunt chestii de care ma lovesc sau am nevoie mai frecvent. Pe langa ele, o sa fie postari despre ultimii … ani in care a fost tacere.

A fost o aventura decenta si o sa incerc sa aduc incetisor totul la zi.

Daca mai e cineva care ma citeste – salutare si imi pare bine sa va revad. Daca nu – salutare viitorilor cititori 😉

Create MySQL Admin user

If you want to create a MySQL admin user that can connect from anywhere, feel free to tweak the string below:

#create SQL Admin user
CREATE USER ‘clusterAdmin’@’%’ IDENTIFIED BY ‘YOUR_cool_password_here’;
GRANT ALL PRIVILEGES ON *.* TO ‘clusterAdmin’@’%’;
FLUSH PRIVILEGES;

If you want to limit connections to localhost, switch the “%” to “localhost”

Productivity tip – Session Buddy

If you’re like me, you probably have groups of tabs opened in your browser, for instance this is how my taskbar looks like:

So i usually split up my tabs into: work, education, reading and so on.

The problem is that sometimes when Chrome crashes and i don’t get the “restore tabs” option, i have to redo everything aaaaalll over again and it’s quite a pain.

Enter “Session buddy” – an extension from the Play Store. Install it and your sessions get saved quite nicely:

Hope this boosts your productivity!

Google Cloud Platform – FTP

So if you’re getting an error similar to this: “500 I won’t open a connection to 10.142.0.9 (only to…” if you’re trying to use FTP on a VM on Google Cloud, fear not, it’s an easy fix.

You can do this 2 ways:

1 – FTP -p remote-host

or

2 – FTP remote-host -> log in -> then type “passive” without quotes, and everything should be just fine.

Enjoy!