forum.excito.org

A Database Error Occurred

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

aptitude reinstall bubba-album

GNOE Inc.. wrote: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?

dpkg-reconfigure -phigh bubba-album

dpkg -l | grep -v ^ii

GNOE Inc.. wrote: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

aptitude reinstall bubba-album

A Database Error Occurred

Error Number: 1146

Table 'album.image' doesn't exist

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

# 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
##

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

GNOE Inc.. wrote: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?

dpkg-reconfigure -phigh bubba-album

GNOE Inc.. wrote: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!

GNOE Inc.. wrote: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.