bubba-album error

[GNOE Inc..]

When I login and I select 'photo album' the following error is displayed:

A Database Error Occurred

Unable to connect to your database server using the provided settings.

I tried

Code: Select all

aptitude reinstall bubba-album

without success.

Can you please help me out?

[carl]

When I login and I select 'photo album' the following error is displayed:

A Database Error Occurred

Unable to connect to your database server using the provided settings.

I tried

Code: Select all

aptitude reinstall bubba-album

without success.

Can you please help me out?

Did you get any errors when trying to reinstall?
Have you by any chance changed the default mysql password? If so, try issuing following command, and insert the password when prompted:

Code: Select all

dpkg-reconfigure -phigh bubba-album

If not, have you had problem upgrading before? if so ,could you give the output of:

Code: Select all

dpkg -l | grep -v ^ii

[GNOE Inc..]

what is the default password for mysql?

EDIT: The output is:

Code: Select all

Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name                         Version                              Description
+++-============================-====================================-============================================
rc  horde3                       3.2.1+debian0-1ex6                   horde web application framework

[carl]

what is the default password for mysql?

EDIT: The output is:

Code: Select all

Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name                         Version                              Description
+++-============================-====================================-============================================
rc  horde3                       3.2.1+debian0-1ex6                   horde web application framework

Default there is no password for root from localhost, if you change it, noninteractive install isn't directly functional sadly.

[GNOE Inc..]

How can I reset my root password? I don't know my root password anymore.

EDIT: Nevermind, I found it....

[GNOE Inc..]

BTW What is the command to restart the webserver?

I made a Mysql database 'album' with an user granted with all privileges. Then I reinstalled bubba-album with

Code: Select all

aptitude reinstall bubba-album

When I select the photo album in bubba-frontend I get this message:

A Database Error Occurred

Error Number: 1146

Table 'album.image' doesn't exist

SELECT `id`, `name` FROM (`image`) WHERE `album` IS NULL

My /etc/dbconfig-common/bubb-album.conf contains:

Code: Select all

# automatically generated by the maintainer scripts of bubba-album
# any changes you make will be preserved, though your comments    
# will be lost!  to change your settings you should edit this     
# file and then run "dpkg-reconfigure bubba-album"                

# dbc_install: configure database with dbconfig-common?
#              set to anything but "true" to opt out of assistance
dbc_install="true"                                                

# dbc_upgrade: upgrade database with dbconfig-common?
#              set to anything but "true" to opt out of assistance
dbc_upgrade="true"                                                

# dbc_remove: deconfigure database with dbconfig-common?
#             set to anything but "true" to opt out of assistance
dbc_remove=""                                                    

# dbc_dbtype: type of underlying database to use
#       this exists primarily to let dbconfig-common know what database
#       type to use when a package supports multiple database types.
#       don't change this value unless you know for certain that this
#       package supports multiple database types
dbc_dbtype="mysql"

# dbc_dbuser: database user
#       the name of the user who we will use to connect to the database.
dbc_dbuser="album"

# dbc_dbpass: database user password
#       the password to use with the above username when connecting
#       to a database, if one is required
dbc_dbpass="(MyAlbumPassword)"

# dbc_dbserver: database host.
#       leave unset to use localhost (or a more efficient local method
#       if it exists).
dbc_dbserver=""

# dbc_dbport: remote database port
#       leave unset to use the default.  only applicable if you are
#       using a remote database.
dbc_dbport=""

# dbc_dbname: name of database
#       this is the name of your application's database.
dbc_dbname="album"

# dbc_dbadmin: name of the administrative user
#       this is the administrative user that is used to create all of the above
dbc_dbadmin="root"

# dbc_basepath: base directory to hold database files
#       leave unset to use the default.  only applicable if you are
#       using a local (filesystem based) database.
dbc_basepath=""

##
## postgresql specific settings.  if you don't use postgresql,
## you can safely ignore all of these
##

# dbc_ssl: should we require ssl?
#       set to "true" to require that connections use ssl
dbc_ssl=""

# dbc_authmethod_admin: authentication method for admin
# dbc_authmethod_user: authentication method for dbuser
#       see the section titled "AUTHENTICATION METHODS" in
#       /usr/share/doc/dbconfig-common/README.pgsql for more info
dbc_authmethod_admin=""
dbc_authmethod_user=""

##
## end postgresql specific settings
##

When I do 'dpkg-reconfigure bubba-album', I'm not asked for my root password, so the process is ended with an

Code: Select all

dpkg-reconfigure bubba-album
dbconfig-common: writing config to /etc/dbconfig-common/bubba-album.conf
error encountered creating user:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
dbconfig-common: bubba-album configure: trying again.
dbconfig-common: writing config to /etc/dbconfig-common/bubba-album.conf
dbconfig-common: flushing administrative password
Replacing config file /etc/album/debian-db.php with new version
Reloading web server config...7106

What can I do to get this working?

[carl]

BTW What is the command to restart the webserver?

I made a Mysql database 'album' with an user granted with all privileges. Then I reinstalled bubba-album with

Code: Select all

aptitude reinstall bubba-album

When I select the photo album in bubba-frontend I get this message:

A Database Error Occurred

Error Number: 1146

Table 'album.image' doesn't exist

SELECT `id`, `name` FROM (`image`) WHERE `album` IS NULL

My /etc/dbconfig-common/bubb-album.conf contains:

Code: Select all

# automatically generated by the maintainer scripts of bubba-album
# any changes you make will be preserved, though your comments    
# will be lost!  to change your settings you should edit this     
# file and then run "dpkg-reconfigure bubba-album"                

# dbc_install: configure database with dbconfig-common?
#              set to anything but "true" to opt out of assistance
dbc_install="true"                                                

# dbc_upgrade: upgrade database with dbconfig-common?
#              set to anything but "true" to opt out of assistance
dbc_upgrade="true"                                                

# dbc_remove: deconfigure database with dbconfig-common?
#             set to anything but "true" to opt out of assistance
dbc_remove=""                                                    

# dbc_dbtype: type of underlying database to use
#       this exists primarily to let dbconfig-common know what database
#       type to use when a package supports multiple database types.
#       don't change this value unless you know for certain that this
#       package supports multiple database types
dbc_dbtype="mysql"

# dbc_dbuser: database user
#       the name of the user who we will use to connect to the database.
dbc_dbuser="album"

# dbc_dbpass: database user password
#       the password to use with the above username when connecting
#       to a database, if one is required
dbc_dbpass="(MyAlbumPassword)"

# dbc_dbserver: database host.
#       leave unset to use localhost (or a more efficient local method
#       if it exists).
dbc_dbserver=""

# dbc_dbport: remote database port
#       leave unset to use the default.  only applicable if you are
#       using a remote database.
dbc_dbport=""

# dbc_dbname: name of database
#       this is the name of your application's database.
dbc_dbname="album"

# dbc_dbadmin: name of the administrative user
#       this is the administrative user that is used to create all of the above
dbc_dbadmin="root"

# dbc_basepath: base directory to hold database files
#       leave unset to use the default.  only applicable if you are
#       using a local (filesystem based) database.
dbc_basepath=""

##
## postgresql specific settings.  if you don't use postgresql,
## you can safely ignore all of these
##

# dbc_ssl: should we require ssl?
#       set to "true" to require that connections use ssl
dbc_ssl=""

# dbc_authmethod_admin: authentication method for admin
# dbc_authmethod_user: authentication method for dbuser
#       see the section titled "AUTHENTICATION METHODS" in
#       /usr/share/doc/dbconfig-common/README.pgsql for more info
dbc_authmethod_admin=""
dbc_authmethod_user=""

##
## end postgresql specific settings
##

When I do 'dpkg-reconfigure bubba-album', I'm not asked for my root password, so the process is ended with an

Code: Select all

dpkg-reconfigure bubba-album
dbconfig-common: writing config to /etc/dbconfig-common/bubba-album.conf
error encountered creating user:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
dbconfig-common: bubba-album configure: trying again.
dbconfig-common: writing config to /etc/dbconfig-common/bubba-album.conf
dbconfig-common: flushing administrative password
Replacing config file /etc/album/debian-db.php with new version
Reloading web server config...7106

What can I do to get this working?

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" indicates that the default password for root has been changed, try:

Code: Select all

dpkg-reconfigure -phigh bubba-album

Hopefully you should be able to insert your root password there.

[GNOE Inc..]

Problem Solved!
With

Code: Select all

dpkg-reconfigure -phigh bubba-album

the MySQL root-password is not asked, so I removed the root password temporarily (I have phpmyadmin installed to manage my SQL-databases). After that I removed the bubba-album package with

Code: Select all

aptitude remove bubba-album

( which also removes bubba-frontend)
Next, I removed the directory /etc/album en deleted the file /etc/dbconfig-common/bubba-album.conf.
Then I re-installed the bubba-frontend package (which also installs bubba-album) with the command

Code: Select all

apt-get install bubba-frontend

and configured the album with the

Code: Select all

dpkg-reconfigure -phigh bubba-album

. No errors where shown and the album works.
As last I changed the empty MySQL root-password back to what it was before.

Thanx for the assistance, Carl!

[carl]

Problem Solved!
With

Code: Select all

dpkg-reconfigure -phigh bubba-album

the MySQL root-password is not asked, so I removed the root password temporarily (I have phpmyadmin installed to manage my SQL-databases). After that I removed the bubba-album package with

Code: Select all

aptitude remove bubba-album

( which also removes bubba-frontend)
Next, I removed the directory /etc/album en deleted the file /etc/dbconfig-common/bubba-album.conf.
Then I re-installed the bubba-frontend package (which also installs bubba-album) with the command

Code: Select all

apt-get install bubba-frontend

and configured the album with the

Code: Select all

dpkg-reconfigure -phigh bubba-album

. No errors where shown and the album works.
As last I changed the empty MySQL root-password back to what it was before.

Thanx for the assistance, Carl!

I'm happy it worked for you. The problem with mysql password is a problematic issue, and we are working on a solution to avoid this kind of problems. In next upgrade a change will be made so that any further upgrades will not be possible via the admin interface if the root password has been changed.

[GNOE Inc..]

Is it not possible to store a mysql root password in a kind of .conf file which would be used when upgrading?

I use a root password, for security reasons because I have phpmyadmin installed.

[carl]

Is it not possible to store a mysql root password in a kind of .conf file which would be used when upgrading?

I use a root password, for security reasons because I have phpmyadmin installed.

You would need to modify /var/cache/debconf/passwords.dat, and for all "package/mysql/admin-pass" set "Value" to the admin password, and add a value for "dbconfig-common/mysql/admin-pass"

[HeSitated]

Thanks to Gnoe Inc.. i've got phpMyAdmin installed...

But now if i try to do something with it: HTTP 404 ... (http://bubba/phpmyadmin)

I've installed cacti too and that works perfectly.

Somebody ideas?