Failed to create secure directory (/run/user/1000/pulse): Permission denied, external mysql difficulties

[Alan Ezust]

I want to work on a ticket that has long annoyed me.
https://bugs.kde.org/show_bug.cgi?id=188074

I ran into a couple of difficulties with getting my test environment set up.

First question. I have a separate user account "kde" set up for amarok
development.
I am on kubuntu and I use pulse audio.

When I try to start the git master build of amarok as user "kde" (instead
of my regular user)
I get this at startup, and the main window never appears:

Failed to create secure directory (/run/user/1000/pulse): Permission denied

How do i resolve that?

Second, I have my regular user running amarok with an external mysql
database.
The database it uses is "amarok3".

I wanted to use a copy of that database instead of the same one.
So I did "rsync /var/lib/mysql/amarok3/ /var/lib/mysql/amarok/" as root.
The two directories are identical.

I thought I'd test the new db by just telling my regular version of amarok
to use that db.
settings - configure amarok - database - database - change "amarok3" to
"amarok"

I would expect to be able to exit and start amarok and see the same
playlists and collection.
Alas, that is not the case. Instead I get a lot of errors like this on
startup:

The amarok database reported the following errors:
GREPME MySQL-server query failed! (1054) Unknown column 'version' in 'field
list' on SELECT version FROM admin WHERE component = 'DB_VERSION';
GREPME MySQL-server query failed! (1054) Unknown column 'version' in 'field
list' on SELECT version FROM admin WHERE component = 'DB_VERSION';
GREPME MySQL-server query failed! (1054) Unknown column 'version' in 'field
list' on SELECT version FROM admin WHERE component = 'DB_VERSION';
GREPME MySQL-server query failed! (1050) Table 'admin' already exists on
CREATE TABLE admin (component VARCHAR(255), version INTEGER) COLLATE =
utf8_bin ENGINE = MyISAM;
GREPME MySQL-server query failed! (1050) Table 'devices' already exists on
CREATE TABLE devices (id INTEGER PRIMARY KEY AUTO_INCREMENT,type
VARCHAR(255),label VARCHAR(255),lastmountpoint VARCHAR(255),uuid
VARCHAR(255),servername VARCHAR(80),sharename VARCHAR(240)) COLLATE =
utf8_bin ENGINE = MyISAM;
GREPME MySQL-server query failed! (1061) Duplicate key name 'devices_type'
on CREATE INDEX devices_type ON devices( type );
GREPME MySQL-server query failed! (1061) Duplicate key name 'devices_uuid'
on CREATE UNIQUE INDEX devices_uuid ON devices( uuid );
GREPME MySQL-server query failed! (1061) Duplicate key name
'devices_rshare' on CREATE INDEX devices_rshare ON devices( servername,
sharename );
GREPME MySQL-server query failed! (1050) Table 'urls' already exists on
CREATE TABLE urls (id INTEGER PRIMARY KEY AUTO_INCREMENT,deviceid
INTEGER,rpath VARCHAR(324) NOT NULL,directory INTEGER,uniqueid VARCHAR(128)
UNIQUE) COLLATE = utf8_bin ENGINE = MyISAM;

My collection is empty, and i can't find any of my database playlists
either.

What did I do wrong? How does one copy an existing external amarok mysql
database and use that instead of the original?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/amarok-devel/attachments/20131206/a3926ceb/attachment.html>