mariadb service not starting on Fedora 22

Today I was trying to install natika on my apache server. My server is a Fedora 22 machine. I know, it’s an old system, but if it works, why to change it? It’s a rhetorical question, of course. I know if I keep it like this for a longer time, nothing will run on it anymore. Anyway, here I am that I try to install natika via composer, and I don’t happen to have composer. You can easily fix that easily by dfn (or yum) install composer. This, in my case, installed on my server like 20 php packages and updates, so I’m not surprise the installation fails when I try

composer create-project asika/natika natika *

The interesting part is why it fails, and how to fix it. The error is on the interaction between the installer and the local mysql installation. More specifically, the error reads something similar to this one:

ERROR 1045 (28000): Access denied for user 
'root'@'localhost' (using password: NO)

Now, this is one of the typical errors of mysql, when you do a careless install. Hell, I don’t remember when I did the install. It could be I did it 4 years ago. Am I careless? I could always log in on my local phpMyAdmin, so I didn’t care so much. Also

mysql -u root -p

seemed to work. Provided you give the right password. Since I installed just above a lot of new packages I decide to reset the root password using mysqld_safe:

systemctl stop mariadb.service
mysqld_safe --skip-grant-tables

and now in a new terminal

mysql
> update user set password=password('newpassword') 
where user='root'

Now I closed the first terminal and I try to restart mariadb. You can read the result by yourself.

systemctl start mariadb.service
Job for mariadb.service failed. 
See "systemctl status mariadb.service" and
"journalctl -xe" for details.
## > systemctl status mariadb.service
● mariadb.service - MariaDB 10.0 database server
 Loaded: loaded (/usr/lib/systemd/system/mariadb.service; 
enabled; vendor preset: disabled)
 Active: failed (Result: exit-code) since 11s ago
 Process: 9031 ExecStopPost=/usr/libexec/mysql-wait-stop 
(code=exited, status=3)
 Process: 8915 ExecStart=/usr/bin/mysqld_safe --basedir=/usr 
(code=exited, status=1/FAILURE)
 Main PID: 8915 (code=exited, status=1/FAILURE)

 systemd[1]: Starting MariaDB 10.0 database server...
 mysql-check-socket[8855]: Socket file /var/lib/mysql/mysql.....
 mysqld_safe[8915]: 170921 13:02:09 mysqld_safe Logging to 
 mysqld_safe[8915]: 170921 13:02:09 mysqld_safe A mysqld ...

What is wrong here? Simple, the mysql_safe process didn’t stop when I closed the first terminal. Unfortunately, a PID kill doesn’t seem to be enough. We need to stop it using mysql commands. Again Stackoverflow provide us with the solution:

mysqladmin -u root -p shutdown

And now mariadb starts cleanly. Also, composer runs flawlessly. If I find something else interesting on that field, I will let you know as usual 🙂

Advertisements

Not advancing

I’m not getting anywhere. My muse is gone, or on a sick leave.

I’m blocked trying to do something like google spreadsheets without google. I’d like to have it for the intranet, and I’d like to control it all. I know it’s not simple, but I can’t simply get over it. My next project is to have a working snapshot system, and for that, I also don’t have the mood. Don’t worry, if I start it, I will post my adventures here. On the literary side, I don’t want to compile my web pieces to make an ebook. I know I need a lot of time to rewrite them, to give them some continuity and clean up the edges. Hell, I don’t even want to migrate my data from my (old) MacBook Pro to my new, dark one, with a fancy touchbar. I cleaned up my office, threw away like 50 CDs of (now) useless drivers and documentation, reorganized my documents…but still, I can’t find her. Maybe she left me because I’ve not been diligent the last week. I’ve been easy-posting, and that is wrong. I need to remember to force myself to write a little each day, regarding of the quality, to keep on going.  Later I can decide what to post. Dear muse, where are thou?

100 Billion days & 100 Billion nights

“Orionae?”

The cyborg philosopher tilted his head, frowning, then began hesitantly.  “A long time ago,  I heard of a civilization that believed in an evil supreme being who existed in opposition to their good god. I have visited the village where they believed in a god of night in opposition to the god of day. The good god is the sun god, and the sun itself, and eventually the god who is in heaven – the heavenly father. I always thought that the evil god, the night god, was a purely allegorical being.”

Fragment from the book of Ryu Mitsuse, with the title above. Translated by Alexander O. Smith.  Ed. Haikasuru “The future is Japanese”

Fedora 22 sssd failed with status 3

Oh, this is a good one. I updated my apache server from Fedora 21 to Fedora 22 and I gave up on sssd because I didn’t need it at that moment. I’m the only one accessing to it, and I do it as root. Now I need it to have my AD authentication plugin working. If the machine doesn’t know who you are, how is the apache server supposed to know it? Symptoms:

> service sssd start
Redirecting to /bin/systemctl start sssd.service
Job for sssd.service failed. See "systemctl 
status sssd.service" and "journalctl -xe" for details.
> service sssd status
Redirecting to /bin/systemctl status sssd.service
● sssd.service - System Security Services Daemon
 Loaded: loaded (/usr/lib/systemd/system/sssd.service; 
disabled; vendor preset: disabled)
 Drop-In: /etc/systemd/system/sssd.service.d
 └─journal.conf
 Active: failed (Result: exit-code) since "date"; 3s ago
 Process: 15032 ExecStart=/usr/sbin/sssd -D -f 
(code=exited, status=3)

(date) systemd[1]: Starting System Security Services Daemon...
(date) sssd[15034]: Starting up
(date) systemd[1]: sssd.service: 
control process exited, code=exited status=3
(date) systemd[1]: Failed to start System Security 
Services Daemon.
(date) systemd[1]: Unit sssd.service entered failed state.
(date) systemd[1]: sssd.service failed.

First let’s understand the error level. Fedora people has a SSSD troubleshooting page. They give me hope, since status=3 means:

3	Minor failures. These are the errors that would percolate down to cause the operation failure of 2

So what to do? This is what I did that didn’t work:

• I start and stop the sssd service
• I checked the /etc/sssd/ and /etc/krb5* permissions against a working machine
• I removed and copy sssd.conf from another client, adapt it and restart the ssd

The answer to my problem was on the logs. Which ones? On the entry of today for more /var/log/sssd/sssd.log I see the next:

(date) [sssd] [commence_upgrade] 
(0x0020): UPGRADING DB TO VERSION 0.16
(date) [sssd] [ldb] (0x0010): 
ltdb: tdb(/var/lib/sss/db/cache*): 
tdb_rec_read bad magic 0xd9fee666 at offset=1421676

Now if you google it you can get to this support page from novell that suggest to remove the database entry. Therefore I do:

1. Stop the sssd service
2. delete the local cache files: rm /var/lib/sss/db/*
3. Restart the service

And… problem solved! Now to work on my plugin 😦

Install Kodi on a Raspberry Raspbian

I was really tired of fighting with the Samsung Smart TV, that sometimes plays something, sometimes not. Basically it only plays dm4, that I can get by conversion, but I don’t want to waste my time converting. Lately I was even connecting my laptop to it, with the inconvenient annoyance that represent to have two screens one close to each other and to go to select the file each time I want to play something else. So I decided to make me my own media center, based on a Raspberry Pi 3 Model B v1.2. I need to remark that after trying some card-readers around, finally I gave up and I buy a pre-installed Raspbian system. But that’s my choice, as it is my choice to write about it.

Anyway, once I have changed the default name, enabled root and these kind of things I like, I start to follow what is written on the raspberrypi forum HOWTO install kodi on raspbian. The procedure takes like 15 minutes once you have the page, it’s basically cut and paste. But of course, it doesn’t work once I’m done. After starting kodi via command line, the screen goes black for 30 seconds, only to come back to this error:

error while loading shared libraries: libbrcmGLESv2.so

Fortunately, and as I said before, there are millions of raspberries out there, therefore probably thousands with a similar problem. I find once more one solution on the raspberry pi forum. But of course, it doesn’t work, despite of the upgrade and the update. Otherwise I don’t write a post about it. What to do now? Maybe go ahead? I upgrade the distro, despite it is not recommended:

sudo apt-get dist-upgrade

and try again after a reboot. Halleluja! Kodi works. The problem is now to read my USB disk! To fix that, as explained in the raspberry forum, one needs to enable some exFat utils. This is what I did:

sudo apt-get update
sudo apt-get install exfat-fuse exfat-utils

After a reboot, my pi sees happily my 8 TB USB hard disk (yes, 8 TB, I have a lot of photos and videos, you don’t?). Now I need simply maybe to buy a nice case for my pi, and a remote controller. Total project time: 2 hours, but working in parallel on something else. Conclusion: do not desperate and do not trust everything you read on a forum (trust more like 66% of it). See you around.

Let’s do it

“Let’s go somewhere else.” Ea is still hanging on my neck, after the kiss, that was one of the sweetest ones I ever experienced. I look around, looking for support. “It’s OK, Blue, we’ll take care of the fucker.” Yellow starts the phrase that Red ends. I wonder if they’re telepaths. I have a last look to Adam, that is being accommodated in a sitting position by Pit and Angel. The effect of the cone I ate seems to be fading, since he looks again like a person, and everything is moving at a normal speed.

“What are you going to do with him?” I manage to mutter.

“We will cover him on wine, wait until he wakes up, then tell him he was very drunken when he collided with a stone and fell on a floor.” Zap shouts. “Then we will find out a way to dismiss him. Don’t worry, it’s not the first time that someone tries to attack our girls.” The girls laugh. Ea laughs. “We’re like a family. We protect each other, help each other. We’re not all the time together, but we know about the other.” Lana said. Her voice is very soft, but somehow, easy to distinguish from the noise, due to the tone. A monotone, free of emotions. She seems to remove something from her maiden dress. Then, she adjust her white hairdress. From the distance, one could think she’s a toy, not an human. She does a slow bow to me, just to add afterwards: “You are very welcomed to join us, if you like us.” I nod, she smiles and waves her hand, the way a toy does. Left-right, left-right. Clearly a performance. I laugh a little, people relax, and start filling their glasses again. The party goes on.

I then follow Ea, that seems to know where to go.

Tonk

“Who’s this?” Ea is with us. He or she shines peace and darkness on this light. The hair is perfectly surrounding the face, half blonde, half brunette. The eyes are big, and they’re on fire. Red, or brown, but with very small pupils, and a lot of reflections. Hypnotizing. The lips are gorgeous, and I suddenly feel the impulse to kiss them. Ea seems to realize and smiles, while freeing me completely from Adam. Adam, on the other hand, looks strange. When I try to focus, he becomes a little flat, like smashed inside a book, like a drawing of a knight escaped from my childhood. When he turns his waist, I barely see him: he becomes 2D.

Probably it’s the cone I ate. We’re back close to the stone. Presentations start, done by Ea. Again I hear the song, and I mutter the names also: Lana, Yomick, Bru and Alea, the boys are Pit, Angel, Ber, and Zap. The twins are Yellow and Red. A good band! Adam in the meantime seems to be slowly dissolving in front of my eyes, transforming himself into the sketch of a person, then into a group of clothes that float in the air. I’m asked things, and I answer them like in a dream. “Since when do you know him?” Since today, or yesterday, to be more precise. I don’t know who’s asking what. My new friends move around me and the point where sometimes I see Adam, sometimes something else, a red monster, that seems to be trying to escape. “Do you like him?” Well, I liked him before he started to stalk me. Yellow and Red are fluctuating. Now Red is Yellow, now Yellow is Red. It reminds me the Schroedinger’s cat. No, Bru is the cat. A big black human-sized feline. Miau, I say her. She smiles, a smile so shiny that I close my eyes for a second. “Do you want him to disappear?” Somebody asked. Now that you ask, I can’t really focus him very well, so I will say yes. Then I hear it.

“Tonk!” My blurry group view is suddenly fixed. Adam lies on the floor, head down in the mud, hands and legs spread also. Petrified, to his right, stays Zap, with what is looking like the remnants of a broken jar in his hand. Around him, the other boys, Pit and Angel smile to each other, while Ber is down to examine the body. He takes his pulse, and shows up a thumb up. Around me, the girls. Yellow and Red claps their hands, but I don’t hear a sound. Lana, Yomick, Bru and Alea are simply staring, like trying to evaluate the situation and give it a mark. Ea is grabbing my waist, coming closer to my ear. He or she whispers to me. “Problem solved. He will wake up with a big headache. I hate stalkers!” I look to Ea, I nod, and then Ea kisses me in my lips.