Solved Korganizer and Kmail=Akonadi and Mysql don't start!!

grahamperrin

Son of Beastie

Reaction score: 1,043
Messages: 3,503


That's for packaged ports, which are separate from the FreeBSD operating system.

To update FreeBSD, in your case:
  1. sudo -u root csh
  2. setenv PAGER cat
  3. freebsd-update fetch install
  4. restart the OS
– then upgrade your packages.
 
OP
S

Saverik

Member

Reaction score: 8
Messages: 34

Nothing !!!!!!!!!!!!!I can try to move from quarterly to latest?
How I can?
 
OP
S

Saverik

Member

Reaction score: 8
Messages: 34

Eseguibile: akonadiserver PID: 2684 Segnale: Abort trap (6) Ora: 30 Aug 2021 21:32:26 CEST


saverik@Amd5600x:/usr/home/saverik $ service dbus start
dbus already running? (pid=1133).
saverik@Amd5600x:/usr/home/saverik $ su
Password:
root@Amd5600x:/usr/home/saverik # service dbus start
dbus already running? (pid=1133).
root@Amd5600x:/usr/home/saverik # exit
exit
saverik@Amd5600x:/usr/home/saverik $ akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin)
Available Agent Types: akonadi_akonotes_resource, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_ews_resource
, akonadi_ewsmta_resource, akonadi_google_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_
kalarm_dir_resource, akonadi_kalarm_resource, akonadi_knut_resource, akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi
_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_resource, akonadi_openxchange_resource,
akonadi_pop3_resource, akonadi_tomboynotes_resource, akonadi_vcard_resource, akonadi_vcarddir_resource
saverik@Amd5600x:/usr/home/saverik $ akonadictl start
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadicontrol: Service org.freedesktop.Akonadi.Control.lock already registered, terminating now.
Error: akonadi_control was started but didn't register at D-Bus session bus.
Make sure your system is set up correctly!
saverik@Amd5600x:/usr/home/saverik $
 

grahamperrin

Son of Beastie

Reaction score: 1,043
Messages: 3,503

Thanks.

Reading between the lines: did an OS update, plus switch to latest for packages, resolve the MySql start issue?
 

Vull

Aspiring Daemon

Reaction score: 565
Messages: 859

Thanks.

Reading between the lines: did an OS update, plus switch to latest for packages, resolve the MySql start issue?
Speaking only for myself, I upgraded to latest and everything is now working. For reference:
Code:
len@plasma:/usr/home/len $ akonadictl status
Akonadi Control: running
Akonadi Server: running
Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin)
Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource, akonadi_followupreminder_agent, akonadi_google_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_kalarm_dir_resource, akonadi_kalarm_resource, akonadi_knut_resource, akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi_mailfilter_agent, akonadi_mailmerge_agent, akonadi_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_resource, akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_sendlater_agent, akonadi_tomboynotes_resource, akonadi_unifiedmailbox_agent, akonadi_vcard_resource, akonadi_vcarddir_resource
len@plasma:/usr/home/len $ su -
Password:
root@plasma:~ # service mysql-server status
mysql is running as pid 2677.
root@plasma:~ # pkg info kde5 | head -n 1
kde5-5.22.4.21.08.0
root@plasma:~ # pkg info plasma5-plasma | head -n 1
plasma5-plasma-5.22.4
root@plasma:~ # pkg info akonadi | head -n 1
akonadi-21.08.0
root@plasma:~ # pkg info mysql57-server | head -n 1
mysql57-server-5.7.35
root@plasma:~ #
 
OP
S

Saverik

Member

Reaction score: 8
Messages: 34

Gentlemen ,(thanks much for your help)

i did upgrade and move to latest..
saverik@Amd5600x:/usr/home/saverik $ service dbus start
dbus already running? (pid=1133).
saverik@Amd5600x:/usr/home/saverik $ su
Password:
root@Amd5600x:/usr/home/saverik # service dbus start
dbus already running? (pid=1133).
root@Amd5600x:/usr/home/saverik # exit
exit
saverik@Amd5600x:/usr/home/saverik $ akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin)
Available Agent Types: akonadi_akonotes_resource, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_ews_resource
, akonadi_ewsmta_resource, akonadi_google_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_
kalarm_dir_resource, akonadi_kalarm_resource, akonadi_knut_resource, akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi
_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_resource, akonadi_openxchange_resource,
akonadi_pop3_resource, akonadi_tomboynotes_resource, akonadi_vcard_resource, akonadi_vcarddir_resource
saverik@Amd5600x:/usr/home/saverik $ akonadictl start
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadicontrol: Service org.freedesktop.Akonadi.Control.lock already registered, terminating now.
Error: akonadi_control was started but didn't register at D-Bus session bus.
Make sure your system is set up correctly!
saverik@Amd5600x:/usr/home/saverik $
 
OP
S

Saverik

Member

Reaction score: 8
Messages: 34

When I installed the system I choose an option.
It ask me to ceck for erase the tmp at start... (if I remember good )..
Could be that option choose at Install?
 

Vull

Aspiring Daemon

Reaction score: 565
Messages: 859

i did upgrade and move to latest..
I actually ran the upgrade twice, once before moving to latest, and then again, afterwards. First, I ran pkg upgrade as root, to bring all the quarterly packages up to date. Then, created the file /usr/local/etc/pkg/repos/FreeBSD.conf to switch from quarterly to latest. Finally, I had to run pkg upgrade again, to upgrade everything from quarterly to latest.

Please post the output of cat /usr/local/etc/pkg/repos/FreeBSD.conf and pkg info akonadi | head -n 1 -- you should see something like this:
Code:
len@plasma:/usr/home/len $ cat /usr/local/etc/pkg/repos/FreeBSD.conf
FreeBSD: {
  url: "pkg+http://pkg.FreeBSD.org/${ABI}/latest"
}
len@plasma:/usr/home/len $ pkg info akonadi | head -n 1
akonadi-21.08.0
len@plasma:/usr/home/len $
 
OP
S

Saverik

Member

Reaction score: 8
Messages: 34

Goood evening,



saverik@Amd5600x:/usr/home/saverik $ service mysql-server status
eval: cannot open /var/db/mysql/Amd5600x.pid: Permission denied
mysql is not running.
saverik@Amd5600x:/usr/home/saverik $ service mysql-server start
eval: cannot open /var/db/mysql/Amd5600x.pid: Permission denied
/usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql
saverik@Amd5600x:/usr/home/saverik $ su
Password:
root@Amd5600x:/usr/home/saverik # service mysql-server status
mysql is running as pid 2428.
root@Amd5600x:/usr/home/saverik #

my /etc/rc.conf :
hostname="Amd5600x"
keymap="it.kbd"
wlans_run0="wlan0"
ifconfig_wlan0="WPA DHCP"
create_args_wlan0="country IT regdomain ETSI"
ifconfig_re0="DHCP"
ifconfig_re0_ipv6="inet6 accept_rtadv"
sshd_enable="YES"
moused_enable="YES"
ntpdate_enable="YES"
ntpd_enable="YES"
powerd_enable="YES"
# Set dumpdev to "AUTO" to enable crash dumps, "NO" to disable
dumpdev="AUTO"
kld_list="amdgpu"
dbus_enable="YES"
sddm_enable="YES"
mysql_enable="YES"

root@Amd5600x:/usr/home/saverik # grep -i mysql /etc/group && grep -i mysql /etc/master.passwd
mysql:*:88:
mysql:*:88:88::0:0:MySQL Daemon:/var/db/mysql:/usr/sbin/nologin
root@Amd5600x:/usr/home/saverik #

My /boot/loader.conf
if_re_load="YES"
if_re_name="/boot/modules/if_re.ko"
kern.vyt=vt



saverik@Amd5600x:/usr/home/saverik $ cat /usr/local/etc/pkg/repos/FreeBSD.conf
# $FreeBSD$
#
# To disable this repository, instead of modifying or removing this file,
# create a /usr/local/etc/pkg/repos/FreeBSD.conf file:
#
# mkdir -p /usr/local/etc/pkg/repos
# echo "FreeBSD: { enabled: no }" > /usr/local/etc/pkg/repos/FreeBSD.conf
#

FreeBSD: {
url: "pkg+http://pkg.FreeBSD.org/${ABI}/latest",
mirror_type: "srv",
signature_type: "fingerprints",
fingerprints: "/usr/share/keys/pkg",
enabled: yes
}
saverik@Amd5600x:/usr/home/saverik $

saverik@Amd5600x:/usr/home/saverik $ pkg info akonadi | head -n 1
akonadi-21.04.3
saverik@Amd5600x:/usr/home/saverik $


my /usr/local/etc/mysql/my.cnf

[client]
port = 3306
socket = /tmp/mysql.sock

[mysql]
prompt = \u@\h [\d]>\_
no_auto_rehash

[mysqld]
user = mysql
port = 3306
socket = /tmp/mysql.sock
bind-address = 127.0.0.1
basedir = /usr/local
datadir = /var/db/mysql
tmpdir = /var/db/mysql_tmpdir
slave-load-tmpdir = /var/db/mysql_tmpdir
secure-file-priv = /var/db/mysql_secure
log-bin = mysql-bin
log-output = TABLE
master-info-repository = TABLE
relay-log-info-repository = TABLE
relay-log-recovery = 1
slow-query-log = 1
server-id = 1
sync_binlog = 1
sync_relay_log = 1
file "

Gentleman, tanks for your patience
 

Vull

Aspiring Daemon

Reaction score: 565
Messages: 859

saverik@Amd5600x:/usr/home/saverik $ pkg info akonadi | head -n 1
akonadi-21.04.3
saverik@Amd5600x:/usr/home/saverik $
This should be akonadi-21.08.0 which is the "latest" version. You still have the "quarterly" version, which means you need to run pkg upgrade again.

When pkg upgrade runs, if it doesn't offer to upgrade akonadi then your /usr/local/etc/pkg/repos/FreeBSD.conf is probably wrong. Please refer to the examples above for the recommended text that should be in that file.
 
OP
S

Saverik

Member

Reaction score: 8
Messages: 34

Runnn!!

to resolve my problem Ihave to move from quarterlty to latest.
saverik@Amd5600x:/usr/home/saverik $ akonadictl start
Akonadi is already running.
saverik@Amd5600x:/usr/home/saverik $
The problem was akonadi!!!!

Thank you at all gentlemen for support.
 
Last edited:

Vull

Aspiring Daemon

Reaction score: 565
Messages: 859

Hm so the following is mildly interesting, and related to this topic.

I have another kde5 install which is still using quarterly packages only. Earlier today, this install was showing the same akonadi crash which is the topic of this thread, but, after running pkg upgrade, the problem seems to have gone away completely. Today's upgrade included the following packages (which were not included in Tuesday's upgrade of the same install):
Code:
The following 11 package(s) will be affected (of 0 checked):

Installed packages to be UPGRADED:
        gnupg: 2.3.1 -> 2.3.2
        mod_php74: 7.4.22 -> 7.4.23
        php74: 7.4.22 -> 7.4.23
        php74-ctype: 7.4.22 -> 7.4.23
        php74-ftp: 7.4.22 -> 7.4.23
        php74-mbstring: 7.4.22 -> 7.4.23
        php74-pgsql: 7.4.22 -> 7.4.23
        php74-session: 7.4.22 -> 7.4.23
        php74-xml: 7.4.22 -> 7.4.23
        plasma5-plasma-workspace: 5.22.4 -> 5.22.4_1
        qt5-sqldrivers-mysql: 5.15.2 -> 5.15.2_1

Number of packages to be upgraded: 11
It seems reasonable to conclude that php was probably NOT involved in this problem, so the real culprit was more likely to have been one or more of gnupg, plasma5-plasma-workspace, and/or qt5-sqldrivers-mysql.

Also worth noting, this system does not have mysql_enable="YES" in /etc/rc.conf, so it appears that the quarterly version of mysql57-server itself was NOT involved in this problem, nor does it seem to be required for the quarterly version akonadi to run successfully:
Code:
len@kde5:/usr/home/len $ akonadictl status
Akonadi Control: running
Akonadi Server: running
Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin)
Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent, akona
di_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, a
konadi_ews_resource, akonadi_ewsmta_resource, akonadi_followupreminder_agent, akon
adi_google_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap
_resource, akonadi_indexing_agent, akonadi_kalarm_dir_resource, akonadi_kalarm_res
ource, akonadi_knut_resource, akonadi_kolab_resource, akonadi_maildir_resource, ak
onadi_maildispatcher_agent, akonadi_mailfilter_agent, akonadi_mailmerge_agent, ako
nadi_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonad
i_newmailnotifier_agent, akonadi_notes_resource, akonadi_openxchange_resource, ako
nadi_pop3_resource, akonadi_sendlater_agent, akonadi_tomboynotes_resource, akonadi
_unifiedmailbox_agent, akonadi_vcard_resource, akonadi_vcarddir_resource
len@kde5:/usr/home/len $ su -
Password:
root@kde5:~ # service mysql-server status
Cannot 'status' mysql. Set mysql_enable to YES in /etc/rc.conf or use 'onestatus'
instead of 'status'.
root@kde5:~ #
In my opinion, this topic could very reasonably be marked "Solved" at this point, as it's not likely to come up again, either for quarterly or for latest.
 
Top