seduction
 Language:
Welcome, Guest. Please login or register.
Did you miss your activation email?
2018/01/19, 08:28:52


Help

Recent Posts

Pages: [1] 2 3 ... 10
1
The permission problems were no fun. It definitely helps to know the database name and password.  Looks like you've got good experience with that issue.   ;)
2
Glad you got things working :)

Quote from: vayu
mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'


Akonadi, Amarok, Mythtv, etc all the same, you had permission problems, hence the link I gave you :) it also helps to know the names of the databases.

I've never used phpMyadmin, looks nice, might try it, I do everything command line.

Mythtv uses mythconverge for database (or anything you name it)

Code: [Select]
mysql -u mythtv --password=mythtv -p -h 10.10.10.3 mythconverg

grant all privileges on *.* to 'mythtv'@'10.10.10.3' with grant option;

flush privileges;

Code: [Select]
select user,host from user where user='root';

select user,host from user where user='username';


+--------+------------+
| user   | host       |
+--------+------------+
| mythtv | %          |
| mythtv | 10.10.10.3 |
| mythtv | localhost  |
| root   | localhost  |
+--------+------------+
4 rows in set (0.00 sec)


Some packages/databases need to load time zones on systems that have a zoneinfo database to load the time zone tables

Code: [Select]
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
I usually bind an IP address in /etc/mysql/mariadb.conf.d/50-server.cnf makes this easier also.

If there is no database, you have to create one

Code: [Select]
create database nameofdatabase;       

You can erase an existing database and start fresh or just erase one you don't need anymore

Code: [Select]
DROP DATABASE IF EXISTS nameofdatabase;   

I don't know a whole lot, but mythtv forces you to learn a little ;)




3
I will prefer to keep glib, better for my eyes and it works as expected. :)

see you
4
Siduction News (DE) / Re: siduction Treff in Berlin
« Last post by devil on Yesterday at 21:25:33 »
Aus dem Doodle ergibt sich als einzig möglicher gemeinsamer Termin der 23.1. So soll es also sein: Pizzaessen am Dienstag, 23.1 ab 19:00. Ort des Geschehens ist wie immer Il Due Forni. Jeder, der gerade in Berlin ist, ist herzlich eingeladen.
5
Hardware Support (EN) / Re: Randomly rebooting
« Last post by effo on Yesterday at 21:19:58 »
Thanks, devil. Did a memtest and found nothing so I replaced my PSU with a spare one. The box has been running without problems since that. Once again, thanks!
6
Siduction News (EN) / Re: Release: siduction 2018.1.0
« Last post by effo on Yesterday at 21:16:41 »
You are the very best. Thank you!
7
> 2018-01-18  17:48:22 <_rene_> bts: https://bugs.debian.org/887404

^^ So just disable the GTK3 UI should solve the issue, setting this to solved at all - there will be no upload nor modification of LO 5.4.4 in debian, one could consider it as dead. LO 6 is comming soon 8)
8
jap danke sidlix!

Bei mir läuft Siduction stabil im täglichen Einsatz (2 Laptops & Heimserver) bis auf einmal (man(n) sollte lesen was entfernt wird beim dist-upgrade).

Ich darf jeden Tag in der Arbeit auf einem "tollen" Windows System arbeiten Windows + Citrix in einer großen Firma. Regelmäßige Abstürze etc alles dabei (ist toll wenn man an einem Tag 200+ Kunden direkt betreuen soll) + tolle nicht veränderbare Einstellungen der Admins (silberner Hintergrund + weiße Schrift ist eine super Kombination).

Da freut man sich dann zu Hause wie nur was über sein Linux.

Daher mal an dieser Stelle ein großes Danke an die tollen Entwickler von meiner Seite!
9

Ok finally got it working. Solution for future searchers:


To get Akonadi to use a global MariaDB database instead of its own local one I had two separate problems. 
MariaDB is what debian uses now and Akonadi has its own local one in use. First I installed mariadb-server, mariadb-client and phpmyadmin. akonadi-backend-mysql is needed but already installed. I didn't have to remove any packages.


The problem was that I couldn't get root access to the mariadb server. I believe because Akonadi but I don't know.  The countless articles I found on how to get in a lost password server didn't work. The link I posted above finally got me access.


My second issue was how to get Akonadi to use the global server rather than it's own separate local one.  (If I'm running a web server on my own local desktop machine that no one accesses I don't want two instances of a database server running)


In ~/.config/akonadi/akonadiserverrc I had to change some settings.


Code: [Select]


[QMYSQL]
##Options="UNIX_SOCKET=/tmp/akonadi-satyam.dgnFnR/mysql.socket"
##ServerPath=/usr/sbin/mysqld-akonadi
Host=
Name=akonadi
Options="UNIX_SOCKET=/var/run/mysqld/mysqld.sock"
ServerPath=/usr/sbin/mysqld


##StartServer=true


StartServer=false


"StartServer=false" stops Akonadi from using the local server


Change the path of the database server from the local "mysqld-akonadi" to the global server "mysqld"
Go to the file "/etc/mysql/mariadb.conf.d/50-client.cnf" to find the socket the global server is using. In my case it was "/var/run/mysqld/mysqld.sock".


Next I had to go to phpMyAdmin and create a user the same as my login user, set it to use no password. Then create a database named "akonadi" and associate it with that user and give it all permissions.


I started the whole affair with the terminal command (as normal user) "akonadictl stop", now it's time for "akonadictl start".


I started with an empty akonadi. I don't know what you'd do if you wanted to export and import your old data first.

10
Quote
have a look at https://userbase.kde.org/Akonadi, my be there are some more information ?
Thanks, that's a great article. For the first time I understand what has always been a big mystery for me.  That overview helps a lot. Maybe now I'll not be so confused when I dive into akonadiconsole.
Pages: [1] 2 3 ... 10