New user's registration have been closed due to high spamming and low trafic on this forum. Please contact forum admins directly if you need an account. Thanks !

'dpkg-reconfigure bubba-album' - what to answer?

Got problems with your B2 or B3? Share and get helped!
Post Reply
ingo2
Posts: 81
Joined: 06 Feb 2012, 10:32

'dpkg-reconfigure bubba-album' - what to answer?

Post by ingo2 »

I did the upgrade to B3 version 2.6 by command line using 'apt-get dist-upgrade'.

This worked fine until it came to upgrade/configuration of "bubba-album" - which I had to skip because appearently apt was not able to delete/remove/convert the existing database. All other packages were upgraded and configured fine and all worked - except the photo-album.
apt-database is 100% ok, no complaints and all clean.
Web-interface of B3 for Photos/Album is dead (completely white page).

So I tried to reconfigure package "bubba-album" afterwards executing

Code: Select all

dpkg-reconfigure bubba-album
without creatring a new database.

But this command fails with following message:

Code: Select all

....
DBI connect('database=bubbaalbum;host=localhost;port=','bubba-album',...)
 failed: Access denied for user 'bubba-album'@'localhost'
 (using password: YES) at /usr/share/bubba-album/flush_thumbs.pl line 13
Checking the existing mysql-databases with:

Code: Select all

mysqlshow

+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| album              |
| horde              |
| mysql              |
| squeezecenter      |
+--------------------+
does not list any database named "bubbaalbum".

So I decided to run

Code: Select all

dpkg-reconfigure bubba-album
selecting to create a new database..

I selected defaults for all options as there are:
  • Connect to Mysql via: "Unix-socket"
    Mysql-admin: "root" (empty password)
    Album-admin: "bubbaalbum" (empty password)
This did successfully create a new database named "bubbaalbum":

Code: Select all

mysqlshow

+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| album              |
| bubbaalbum         |
| horde              |
| mysql              |
| squeezecenter      |
+--------------------+
and the error-messages are gone. The default album (9 slides from Excito) also shows in the web-interface.

My questions now:

a) was my configuration of "bubba-album" correct?
(connection via socket, user root and bubbaalbum without password)

b) is the "old" database named "album" now obsolete?
(if yes: how can I safely remove it including any of its users)

c) did I miss/forget anything?

Regards,
Ingo
UNIX is user friendly, it's just picky about who its friends are.
Gordon
Posts: 1461
Joined: 10 Aug 2011, 03:18

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by Gordon »

You're not the first to stumble on to this. It is weird however that my installation is perfectly happy with using the database 'album', where apparently yours expects the database name 'bubaalbum'.

Although... perfectly? I guess I must have disabled something from bubba-album some time before, because it only contained a number of really old photos where I loaded a shipload of photos almost directly after I put the B3 to use. I moved everything out, cleared the database and moved everything back in and it still only managed to load maybe 10% of all my photos. Also, I'm not sure what is supposed to happen when I click the thumbnails inside bubba-album, but the thumbnail is the biggest sized image it will show me. Not for me, this app...
ingo2
Posts: 81
Joined: 06 Feb 2012, 10:32

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by ingo2 »

My situation was just the contrary, I had not used that feature at all. So just that Symlink to some Excito-pictures which were installed by default and nothing else, no database created, nothing. I also did not set any password for mysql - all as it came from stock.

I think this issue should have been mentioned/described at least in the "release notes". To make an upgrade process dependent on a graphical interface ... A simple 'apt-get' should do the job under all circumstances.

EDIT: Gordon, it appears that besides the "mysql admin" (which has an empty password as I learned from your thread), there is another user for the album-database named 'bubba-album'@'localhost' for whom I also entered no password. We never considered that, I only got aware of that today when executing 'dpkg-reconfigure bubba-album' and let it create an new and empty database (which now is called "bubbaalbum").
UNIX is user friendly, it's just picky about who its friends are.
Gordon
Posts: 1461
Joined: 10 Aug 2011, 03:18

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by Gordon »

Oh, but I hadn't used it either before. I just happened to click on it once and saw some 20-30 of my photo's inside there and only from 2000 and 2001. When I dumped some new photos on the B3 it started rattling like never before (this was after having done the updates to 2.6) and when checking I saw that a process related to bubba-album was responsible for that activity. So then bubba-album showed me the photos from 2000 and 2001 and the new photos from 2013. Not knowing why it hadn't picked up on all the other photos I moved them around, only to find that it still wouldn't index all the photos in there.

I think that the database parameters are defined in a conf file. This would include the database name and I'm pretty sure that I saw a password in there (not at my B3 right now, so can't check).
ingo2
Posts: 81
Joined: 06 Feb 2012, 10:32

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by ingo2 »

Unfortunately there is no direct answer to my questions.
Therefore I would call for help from the community. Could anybody who successfully upgraded to 2.6 via the web-interface please post his mysql-databases?

Just login and be root, then issue the command

Code: Select all

mysqlshow
and post his output here. This at least will show whether I habe obsolete databases around. Here the output is:

Code: Select all

+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| album              |
| bubbaalbum         |
| horde              |
| mysql              |
| squeezecenter      |
+--------------------+
Many thanks in advance,
Ingo
UNIX is user friendly, it's just picky about who its friends are.
Gordon
Posts: 1461
Joined: 10 Aug 2011, 03:18

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by Gordon »

I am at 2.6. I do have 'album', I do not have 'bubbaalbum'. Album works as described above, meaning it does but is not satisfactory.
ingo2
Posts: 81
Joined: 06 Feb 2012, 10:32

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by ingo2 »

Please help me!


Just post the output of

Code: Select all

mysqlshow
(executed as user=root) and your version of bubba-album as shown in the web-interface - that's all.

/Ingo
UNIX is user friendly, it's just picky about who its friends are.
Gordon
Posts: 1461
Joined: 10 Aug 2011, 03:18

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by Gordon »

My old B3

Code: Select all

root@babaorum:~# mysqlshow
+---------------------+
|      Databases      |
+---------------------+
| information_schema  |
| album               |
| horde               |
| logitechmediaserver |
| mysql               |
| roundcubemail       |
+---------------------+
root@babaorum:~# aptitude show bubba-album
Package: bubba-album
State: installed
Automatically installed: yes
Version: 2.6
Priority: standard
Section: web
Maintainer: Carl F??rstenberg <carl@excito.com>
Uncompressed Size: 7799 k
Depends: debconf (>= 0.5) | debconf-2.0, libphp-codeigniter (>= 2.1.3-1),
         dbconfig-common, epeg, mysql-server (>= 5.0) | mysql-server-5.0 |
         mysql-server-5.1, libimage-exiftool-perl, perlmagick,
         libfile-mimeinfo-perl, libproc-daemon-perl (>= 0.14), python-psutil,
         python-pyinotify (>= 0.9.3), python-pyexiv2, libtimedate-perl
Description: The codeigniter based album public interface
 An public album interface for the Bubba album suite
Homepage: http://www.excito.com

root@babaorum:~#
And the new one from the summer campaign

Code: Select all

root@b3:~# mysqlshow
+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| album              |
| horde              |
| mysql              |
+--------------------+
root@b3:~# aptitude show bubba-album
Package: bubba-album
State: installed
Automatically installed: yes
Version: 2.6
Priority: standard
Section: web
Maintainer: Carl F??rstenberg <carl@excito.com>
Uncompressed Size: 7799 k
Depends: debconf (>= 0.5) | debconf-2.0, libphp-codeigniter (>= 2.1.3-1),
         dbconfig-common, epeg, mysql-server (>= 5.0) | mysql-server-5.0 |
         mysql-server-5.1, libimage-exiftool-perl, perlmagick,
         libfile-mimeinfo-perl, libproc-daemon-perl (>= 0.14), python-psutil,
         python-pyinotify (>= 0.9.3), python-pyexiv2, libtimedate-perl
Description: The codeigniter based album public interface
 An public album interface for the Bubba album suite
Homepage: http://www.excito.com

root@b3:~#
Like I said: no 'bubbaalbum' - neither on the system that was upgraded from an older version nor on a fresh install.
lelle
Posts: 69
Joined: 02 Jan 2007, 20:25
Location: Stockholm, Sweden

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by lelle »

root@b3:~# mysqlshow
+--------------------+
| Databases |
+--------------------+
| information_schema |
| album |
| horde |
| mysql |
| phpmyadmin |
+--------------------+
root@b3:~# aptitude show bubba-album
Package: bubba-album
State: installed
Automatically installed: yes
Version: 2.6
Priority: standard
Section: web
Maintainer: Carl F??rstenberg <carl@excito.com>
Uncompressed Size: 7799 k
Depends: debconf (>= 0.5) | debconf-2.0, libphp-codeigniter (>= 2.1.3-1), dbconfig-common, epeg,
mysql-server (>= 5.0) | mysql-server-5.0 | mysql-server-5.1, libimage-exiftool-perl,
perlmagick, libfile-mimeinfo-perl, libproc-daemon-perl (>= 0.14), python-psutil,
python-pyinotify (>= 0.9.3), python-pyexiv2, libtimedate-perl
Description: The codeigniter based album public interface
An public album interface for the Bubba album suite
Homepage: http://www.excito.com

root@b3:~#
ingo2
Posts: 81
Joined: 06 Feb 2012, 10:32

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by ingo2 »

Thanks lelle,

it appears that the database album is what ist really needed.
' bubbaalbum' in my installation/upgrade is probably the album created of a few 10 slides in my "pictures folder" which Excito had installed in my B3 when it was shipped - with firmware version 2.4 at that time.
UNIX is user friendly, it's just picky about who its friends are.
Gerti
Posts: 11
Joined: 15 Feb 2014, 06:20

Re: 'dpkg-reconfigure bubba-album' - what to answer?

Post by Gerti »

Hi!

Even if it is an old thread, I experienced same issue.
After adding the bubbaalbum Database, the album on the Webinterface is working.
So I also make a DROP DATABASE album in mysql to delete the album Database.
It is still working fine.

Best
Michael
Post Reply