Mysql troubles because of Akonadi?

[cerr]

Hi There,

I installed xampp to /opt and realized that mysql isn't reported to be running when launching lampp stop and it says it is already running when doing a lampp start...which is weird, if ilook for existing mysql processes i get following:

Code: Select all

root@reg-desktop:/opt/lampp# ps ax | grep mysqld
 1304 ?        Ssl    0:00 /usr/sbin/mysqld
 2619 ?        Sl     0:00 /usr/sbin/mysqld --defaults-file=/home/reg/.local/share/akonadi//mysql.conf --datadir=/home/reg/.local/share/akonadi/db_data/ --socket=/home/reg/.local/share/akonadi/socket-reg-desktop/mysql.socket
 3730 pts/3    S+     0:00 grep mysqld
root@reg-desktop:/opt/lampp# ls -l

This i get after a lampp start that reported XAMPP: Another MySQL daemon is already running.
What's going on here? Help is appreciated!

Thanks,
Ron

[JonB]

Did you ever actually read this page?

http://www.apachefriends.org/en/xampp-linux.html

down at the bottom -
START AND STOP PARAMETERS

- and -
What is where?

/me guesses not...

[cerr]

Did you ever actually read this page?

http://www.apachefriends.org/en/xampp-linux.html

down at the bottom -
START AND STOP PARAMETERS

- and -
What is where?

/me guesses not...

You are right, I actually haven't studied this yet however, can you explain the following:

Code: Select all

root@reg-desktop:/opt/lampp# /opt/lampp/lampp stopmysql
XAMPP: XAMPP-MySQL is not running.
root@reg-desktop:/opt/lampp# /opt/lampp/lampp startmysql
XAMPP: Another MySQL daemon is already running.


It didn't really help me and when I try to kill the mysqld manually, it gets immediately restarted but I'm not sure who is doing that. Hints are appreciated!
Thanks,
Ron

[JonB]

well - the box is right -

root@reg-desktop:/opt/lampp# /opt/lampp/lampp stopmysql
XAMPP: XAMPP-MySQL is not running.
root@reg-desktop:/opt/lampp# /opt/lampp/lampp startmysql
XAMPP: Another MySQL daemon is already running.

restart your box

Do NOT start XAMPP/LAMPP

in term
su
service mysqld status

you will probably get something like this -

[root@localhost jonb]# service mysqld status
mysqld.service - LSB: start and stop MySQL server
Loaded: loaded (/etc/rc.d/init.d/mysqld)
Active: active (running) since Mon, 10 Oct 2011 23:02:18 -0400; 9min ago
Process: 1003 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=0/SUCCESS)
Main PID: 1297 (mysqld)
CGroup: name=systemd:/system/mysqld.service
├ 1084 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/my...
└ 1297 /usr/libexec/mysqld --basedir=/usr --datadir=/var/...
[root@localhost jonb]#

This was done on a 'standard Fedora stack' not my LAMPP box - you can't run two MySQL servers simultaneously.

If Akonadi stores its data in MySQL, then just use that instance and don't start MySQL when you start XAMMP, that's why they have those other start options for LAMPP

MySQL and phpMyAdmin don't really care 'where or how' mySQL is instantiated - it just can't work with more than one configuration at a time (as its a SERVICE really)

Good Luck

[cerr]

I get

reg@reg-desktop:~$ service mysqld status
mysqld: unrecognized service

but "mysqld status" gives me this:
111011 19:18:09 [Warning] Can't create test file /var/lib/mysql/reg-desktop.lower-test
111011 19:18:09 [Warning] Can't create test file /var/lib/mysql/reg-desktop.lower-test
mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13)
111011 19:18:09 [ERROR] Aborting

[cerr]

I now figured out some details through the mysql shell console:
status told me:

Code: Select all

Current user:           reg@localhost

So good to know my user is my local username reg
So I went ahead and tried to configure /opt/lampp/phpmyadmin/config.inc.php
I set 'user' and 'controluser' both to reg, no password but I'm still getting

MySQL said:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

Connection for controluser as defined in your configuration failed.

Why is that? How do I get phpmyadmin working correctly?
Thank you!
Ron

[JonB]

K - (I know you are frustrated)

BUT you are learning about MySQL -

1st thing- 'system users' (whatever the OS) have NOTHING to do with MySQL users. ALL new MySQL installs, everywhere in the known Universe, arrive with ONE user 'root' an with no password set. (if you had a cup of coffee, tea, a beer and gave it a thought, or just meditated on that, you would see why - the Zen of MySQL)

SO - user 'reg' will have only rights in MySQL someone (or script) defined. Until YOU create new users, (with MySQL itself) - the user you want to work with is 'root'. (this has nothing to do with your current Linux username) So - 'reg' was probably defined by Akonadi (or some other app).

2nd. - The 'Control user' is another matter, its a special entity used by phpMyAdmin.
http://wiki.phpmyadmin.net/pma/control_user

Part of the thing here is you have to learn about MySQL (we all do at some point if we want to be able to fix things when they go BOOM!). Real Life Example --Yesterday, I had a brand spanking new Database I had just uploaded onto a production server go POOF! (and disappeared without a trace) Hours of work getting everything settled in - GONE!

Something I did with a development tool, have not deciphered what yet - must have triggered a 'DROP DATABASE' command (and one without a "ARE YOU FREAKING SURE?" moment...) Fortunately I know that every time I do something major to a database, I export it to a SQL file. (saves the head-smashing on the desk part)

SO I just ''created'' the empty database all over again and used the 207.xx.xx.xx-principal-20101011092045.sql file (made in phpyAdmin) to pour all that back onto the server... ~tada~ you have database!

Some time ago, I decided I 'had' to really learn MySQL - I plunked down (after some searching) for the LinuxCBT MySQL DVD's (was beau coup bucks then) - they offer it online, cheap, now on a monthly subscription basis. The guy is a bit dry, but the man knows him some MySQL. Books are also good, and I have a batch of them too

It looks like your instance of MySQL may need a fixup. If Akonadi created that profile, they probably did a minimal job and it may have been optimized for their purposes. You will need to track down the 'my.cnf' (default name) file from that install (its probably somewhere in /var/) and take a look at it.

Good Luck

[cerr]

Hey Jon,

Great, Thanks for your reply. Okay so now I - as suggested - have set $cfg['Servers'][$i]['user'] = 'root'; and left $cfg['Servers'][$i]['controluser'] = 'reg'; as it's got to be a user "with limited permissions" as it says on http://wiki.phpmyadmin.net/pma/control_user.

I however am still getting the same error# 2002 when trying to open phpmyadmin in my browser.

I got a bunch of 'my.cnf's on my box:

Code: Select all

reg@reg-desktop:~$ locate my.cnf
/etc/mysql/my.cnf
/home/reg/.kde/share/apps/amarok/my.cnf
/home/reg/.kde.bak/kdebackup/share/apps/amarok/my.cnf
/home/reg/.kde.bak/kdebackup/share/apps/amarok~09-06-04/my.cnf
/home/reg/.kde.bak/kdebackup/share/apps/amarok~10-01-02/my.cnf
/home/reg/.kde.bak/share/apps/amarok/my.cnf
/home/reg/.kde4~09-02-01/share/apps/amarok/my.cnf
/home/reg/.kde4~empty/share/apps/amarok/my.cnf
/home/reg/usr/mysql-test/include/default_my.cnf
/home/reg/usr/mysql-test/suite/federated/my.cnf
/home/reg/usr/mysql-test/suite/ndb/my.cnf
/home/reg/usr/mysql-test/suite/rpl/my.cnf
/home/reg/usr/mysql-test/suite/rpl_ndb/my.cnf
/opt/lampp/etc/my.cnf

Not exactly sure which one i shoudl be looking at...?

Thanks for the support! The help is greatly appreciated!

[Altrea]

and left $cfg['Servers'][$i]['controluser'] = 'reg'; as it's got to be a user "with limited permissions" as it says on http://wiki.phpmyadmin.net/pma/control_user.

Please reread that page again. It says limited permissions, but that is not related to system permissions but to mysql permissions. In most cases this control-user isn't needed for phpMyAdmin but in the three cases listed there it is very important to have it.

XAMPP makes it very easy for you, it already configured phpMyAdmin for you. So unless you have really really good reasons to change that phpMyAdmin control-users (in all of my years of webdeveloping there was never such a situation) please leave it as it was

Code: Select all

$cfg['Servers'][$i]['controluser'] = 'pma;