Problems with Update

[matse]

Hi,

I hit the "Update" button on the Bubba Admin UI primarily ot have the SqueezeCenter upgrade to latest version, however, at 82.44% of the upgrade process, there seems to be a problem:

Upgrade: Upgrading packages - Preparing to configure libaprutil1
Error, couldn't connect to server; This is probably due to temporary shutdown of the webserver during upgrade. Please be patient. Will retry communication in 5/4/3/2/1 seconds...

Maybe this wasn't the wisest thing to do given that I have been doing some custom configuration of my Bubba, including tweaking with apache, firewall etc. But that was long time ago, and I had forgotten about it. Is there some way to undo the update process or to fix it?

Thanks,
Mats

[DanielM]

First thing I'd test would be to ssh into your Bubba and run

Code: Select all

apt-get update && apt-get dist-upgrade

and see what it says, might give some clues.

/Daniel

[matse]

Ok, the first command seemed to work ok (only a few complaints). The second one said:

4 not fully installed or removed... you want to continue? Yes

and then I had problems configuring bubba-album. It needed a password for mysql which I don't have.

After a number of retries, I chose the ignore option, but this lead to problems:

subprocess post-installation script returned error... dependency problems prevent configuration of bubba-frontend: bubba-frontend depends on bubba-album.

Any ideas?

Mats

[DanielM]

Well, ignoring dependencies is generally a bad idea. If it complains about dependencies it often has reason to complain. The reason in this case seems to be you having broken bubba-album in some way. What happens if you simply run an "apt-get install bubba-album"? As for the mysql password, I think it's blank by default (not sure here). You sure you didn't change it?

/Daniel

[Ubi]

<<this post is removed by Ubi because of enhanced stupidity by ubi himselfs>>

[matse]

Hmm...

For some reason I managed to complete the update (corrected some errors in some apache config files).

I can browse the squeezecenter website at http://bubba:9000/, but http://bubba/ doesn't respond.

Mats

[DanielM]

<<this post is removed by Ubi because of enhanced stupidity by ubi himselfs>>

Laughing out loud here! I'm sorry Ubi. You are in your fully right to blame me for this

For some reason I managed to complete the update (corrected some errors in some apache config files).

I can browse the squeezecenter website at http://bubba:9000/, but http://bubba/ doesn't respond.

Well, then it seems that the apache config files are still not error free. Check in /var/log/apache2 if the log files there gives any clues...

/Daniel

[matse]

Hi again,

Ok, got most stuff working again. The Album is not however. When I click to view it from the new Bubba UI, I get the following error message:

A Database Error Occurred
Error Number: 1046
No database selected
INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('2d6d6e35f1322e11fdf570e351f34c05', '188.22.160.221', 'Opera/9.80 (Windows NT 5.1; U; en) Presto/2.7.62 V', 1302450774)

I ran the command "dpkg-reconfigure -phigh bubba-album" recommended in another thread w/o success.

Any clues, someone?

Mats

[Ubi]

You'd almost say the database was no longer present. Could you go into mysql as root and type

Code: Select all

show databases

?

[matse]

Thanks. It's there! I mean 'album' is listed as one of the databases. What is also interesting is that when running the mysql -u root command I wasn't asked for any password. Fact is, I cannot recall I have ever changed the mysql root password. In spite of this I had problems passing the password prompt as part of the album configuration during my attempts to update Bubba.

Mats

[Ubi]

it's correct that the bubba root user has no password. This is because of all those processes that have that pwd hardcoded in some config. Updating them (upon apt-get update) is too difficult if you consider the majority of users is noobs that doesn't understand the concent of config files. But that's not your issue as you get a "cannot find db" error.

Normally if I think a problem is db related I turn on mysql query logging to go look for the actual logins and db requests.

[matse]

How do I turn on mysql query logging?

Thanks!
Mats

[Cheeseboy]

As root, edit /etc/mysql/my.cnf and find the following lines:

Code: Select all

 * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
# general_log_file        = /var/log/mysql/mysql.log
# general_log             = 1

Remove the comments:

Code: Select all

general_log_file        = /var/log/mysql/mysql.log
general_log             = 1

Restart the RDBMS:

Code: Select all

# /etc/init.d/mysql restart

[matse]

Ok, here goes the log:

Code: Select all

/usr/sbin/mysqld, Version: 5.0.51a-17~bpo40+1-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
110416 19:37:45	      1 Connect     debian-sys-maint@localhost on 
		      1 Quit       
		      2 Connect     debian-sys-maint@localhost on 
		      2 Quit       
110416 19:37:46	      3 Connect     debian-sys-maint@localhost on 
		      3 Query       show /*!40003 GLOBAL */ variables
		      3 Quit       
		      4 Connect     debian-sys-maint@localhost on mysql
		      4 Query       select @@version_comment limit 1
		      4 Query       show variables like 'datadir'
		      4 Quit       
		      5 Connect     debian-sys-maint@localhost on 
		      5 Query       select @@version_comment limit 1
		      5 Query       SELECT count(*) FROM mysql.user WHERE user='root' and password=''
		      5 Quit       
		      6 Connect     debian-sys-maint@localhost on 
		      6 Query       select @@version_comment limit 1
		      6 Query       select concat("select count(*) into @discard from `",
                    TABLE_SCHEMA, "`.`", TABLE_NAME, "`") 
      from information_schema.TABLES where ENGINE="MyISAM"
110416 19:37:50	      6 Quit       
		      7 Connect     debian-sys-maint@localhost on 
		      7 Query       select @@version_comment limit 1
		      7 Query       select count(*) into @discard from `information_schema`.`COLUMNS`
		      7 Quit       
		      8 Connect     debian-sys-maint@localhost on 
		      8 Query       select @@version_comment limit 1
		      8 Query       select count(*) into @discard from `information_schema`.`ROUTINES`
		      8 Quit       
		      9 Connect     debian-sys-maint@localhost on 
		      9 Query       select @@version_comment limit 1
		      9 Query       select count(*) into @discard from `information_schema`.`TRIGGERS`
		      9 Quit       
110416 19:37:51	     10 Connect     debian-sys-maint@localhost on 
		     10 Query       select @@version_comment limit 1
		     10 Query       select count(*) into @discard from `information_schema`.`VIEWS`
		     10 Quit       
		     11 Connect     debian-sys-maint@localhost on 
		     11 Query       select @@version_comment limit 1
		     11 Query       select count(*) into @discard from `album`.`access`
		     11 Quit       
		     12 Connect     debian-sys-maint@localhost on 
		     12 Query       select @@version_comment limit 1
		     12 Query       select count(*) into @discard from `album`.`sessions`
		     12 Quit       
		     13 Connect     debian-sys-maint@localhost on 
		     13 Query       select @@version_comment limit 1
		     13 Query       select count(*) into @discard from `album`.`users`
		     13 Quit       
		     14 Connect     debian-sys-maint@localhost on 
		     14 Query       select @@version_comment limit 1
		     14 Query       select count(*) into @discard from `horde`.`horde_alarms`
		     14 Quit       
		     15 Connect     debian-sys-maint@localhost on 
		     15 Query       select @@version_comment limit 1
		     15 Query       select count(*) into @discard from `horde`.`horde_cache`
		     15 Quit       
		     16 Connect     debian-sys-maint@localhost on 
		     16 Query       select @@version_comment limit 1
		     16 Query       select count(*) into @discard from `horde`.`horde_datatree`
		     16 Quit       
		     17 Connect     debian-sys-maint@localhost on 
		     17 Query       select @@version_comment limit 1
		     17 Query       select count(*) into @discard from `horde`.`horde_datatree_attributes`
		     17 Quit       
		     18 Connect     debian-sys-maint@localhost on 
		     18 Query       select @@version_comment limit 1
		     18 Query       select count(*) into @discard from `horde`.`horde_groups`
		     18 Quit       
		     19 Connect     debian-sys-maint@localhost on 
		     19 Query       select @@version_comment limit 1
		     19 Query       select count(*) into @discard from `horde`.`horde_groups_members`
		     19 Quit       
110416 19:37:52	     20 Connect     debian-sys-maint@localhost on 
		     20 Query       select @@version_comment limit 1
		     20 Query       select count(*) into @discard from `horde`.`horde_histories`
		     20 Quit       
		     21 Connect     debian-sys-maint@localhost on 
		     21 Query       select @@version_comment limit 1
		     21 Query       select count(*) into @discard from `horde`.`horde_histories_seq`
		     21 Quit       
		     22 Connect     debian-sys-maint@localhost on 
		     22 Query       select @@version_comment limit 1
		     22 Query       select count(*) into @discard from `horde`.`horde_locks`
		     22 Quit       
		     23 Connect     debian-sys-maint@localhost on 
		     23 Query       select @@version_comment limit 1
		     23 Query       select count(*) into @discard from `horde`.`horde_perms`
		     23 Quit       
		     24 Connect     debian-sys-maint@localhost on 
		     24 Query       select @@version_comment limit 1
		     24 Query       select count(*) into @discard from `horde`.`horde_prefs`
		     24 Quit       
		     25 Connect     debian-sys-maint@localhost on 
		     25 Query       select @@version_comment limit 1
		     25 Query       select count(*) into @discard from `horde`.`horde_signups`
		     25 Quit       
110416 19:37:53	     26 Connect     debian-sys-maint@localhost on 
		     26 Query       select @@version_comment limit 1
		     26 Query       select count(*) into @discard from `horde`.`horde_syncml_anchors`
		     26 Quit       
		     27 Connect     debian-sys-maint@localhost on 
		     27 Query       select @@version_comment limit 1
		     27 Query       select count(*) into @discard from `horde`.`horde_syncml_map`
		     27 Quit       
		     28 Connect     debian-sys-maint@localhost on 
		     28 Query       select @@version_comment limit 1
		     28 Query       select count(*) into @discard from `horde`.`horde_tokens`
		     28 Quit       
		     29 Connect     debian-sys-maint@localhost on 
		     29 Query       select @@version_comment limit 1
		     29 Query       select count(*) into @discard from `horde`.`horde_users`
		     29 Quit       
		     30 Connect     debian-sys-maint@localhost on 
		     30 Query       select @@version_comment limit 1
		     30 Query       select count(*) into @discard from `horde`.`horde_vfs`
		     30 Quit       
		     31 Connect     debian-sys-maint@localhost on 
		     31 Query       select @@version_comment limit 1
		     31 Query       select count(*) into @discard from `horde`.`horde_vfs_seq`
		     31 Quit       
110416 19:37:54	     32 Connect     debian-sys-maint@localhost on 
		     32 Query       select @@version_comment limit 1
		     32 Query       select count(*) into @discard from `horde`.`imp_sentmail`
		     32 Quit       
		     33 Connect     debian-sys-maint@localhost on 
		     33 Query       select @@version_comment limit 1
		     33 Query       select count(*) into @discard from `horde`.`kronolith_events`
		     33 Quit       
		     34 Connect     debian-sys-maint@localhost on 
		     34 Query       select @@version_comment limit 1
		     34 Query       select count(*) into @discard from `horde`.`kronolith_shares`
		     34 Quit       
		     35 Connect     debian-sys-maint@localhost on 
		     35 Query       select @@version_comment limit 1
		     35 Query       select count(*) into @discard from `horde`.`kronolith_shares_groups`
		     35 Quit       
		     36 Connect     debian-sys-maint@localhost on 
		     36 Query       select @@version_comment limit 1
		     36 Query       select count(*) into @discard from `horde`.`kronolith_shares_seq`
		     36 Quit       
		     37 Connect     debian-sys-maint@localhost on 
		     37 Query       select @@version_comment limit 1
		     37 Query       select count(*) into @discard from `horde`.`kronolith_shares_users`
		     37 Quit       
110416 19:37:55	     38 Connect     debian-sys-maint@localhost on 
		     38 Query       select @@version_comment limit 1
		     38 Query       select count(*) into @discard from `horde`.`kronolith_storage`
		     38 Quit       
		     39 Connect     debian-sys-maint@localhost on 
		     39 Query       select @@version_comment limit 1
		     39 Query       select count(*) into @discard from `horde`.`mnemo_memos`
		     39 Quit       
		     40 Connect     debian-sys-maint@localhost on 
		     40 Query       select @@version_comment limit 1
		     40 Query       select count(*) into @discard from `horde`.`mnemo_shares`
		     40 Quit       
		     41 Connect     debian-sys-maint@localhost on 
		     41 Query       select @@version_comment limit 1
		     41 Query       select count(*) into @discard from `horde`.`mnemo_shares_groups`
		     41 Quit       
		     42 Connect     debian-sys-maint@localhost on 
		     42 Query       select @@version_comment limit 1
		     42 Query       select count(*) into @discard from `horde`.`mnemo_shares_seq`
		     42 Quit       
		     43 Connect     debian-sys-maint@localhost on 
		     43 Query       select @@version_comment limit 1
		     43 Query       select count(*) into @discard from `horde`.`mnemo_shares_users`
		     43 Quit       
		     44 Connect     debian-sys-maint@localhost on 
		     44 Query       select @@version_comment limit 1
		     44 Query       select count(*) into @discard from `horde`.`turba_objects`
		     44 Quit       
		     45 Connect     debian-sys-maint@localhost on 
		     45 Query       select @@version_comment limit 1
		     45 Query       select count(*) into @discard from `horde`.`turba_shares`
		     45 Quit       
110416 19:37:56	     46 Connect     debian-sys-maint@localhost on 
		     46 Query       select @@version_comment limit 1
		     46 Query       select count(*) into @discard from `horde`.`turba_shares_groups`
		     46 Quit       
		     47 Connect     debian-sys-maint@localhost on 
		     47 Query       select @@version_comment limit 1
		     47 Query       select count(*) into @discard from `horde`.`turba_shares_seq`
		     47 Quit       
		     48 Connect     debian-sys-maint@localhost on 
		     48 Query       select @@version_comment limit 1
		     48 Query       select count(*) into @discard from `horde`.`turba_shares_users`
		     48 Quit       
		     49 Connect     debian-sys-maint@localhost on 
		     49 Query       select @@version_comment limit 1
		     49 Query       select count(*) into @discard from `mediatomb`.`mt_autoscan`
		     49 Quit       
		     50 Connect     debian-sys-maint@localhost on 
		     50 Query       select @@version_comment limit 1
		     50 Query       select count(*) into @discard from `mediatomb`.`mt_cds_active_item`
		     50 Quit       
		     51 Connect     debian-sys-maint@localhost on 
		     51 Query       select @@version_comment limit 1
		     51 Query       select count(*) into @discard from `mediatomb`.`mt_cds_object`
		     51 Quit       
		     52 Connect     debian-sys-maint@localhost on 
		     52 Query       select @@version_comment limit 1
		     52 Query       select count(*) into @discard from `mediatomb`.`mt_internal_setting`
		     52 Quit       
		     53 Connect     debian-sys-maint@localhost on 
		     53 Query       select @@version_comment limit 1
		     53 Query       select count(*) into @discard from `mysql`.`columns_priv`
		     53 Quit       
		     54 Connect     debian-sys-maint@localhost on 
		     54 Query       select @@version_comment limit 1
		     54 Query       select count(*) into @discard from `mysql`.`db`
		     54 Quit       
		     55 Connect     debian-sys-maint@localhost on 
		     55 Query       select @@version_comment limit 1
		     55 Query       select count(*) into @discard from `mysql`.`func`
		     55 Quit       
		     56 Connect     debian-sys-maint@localhost on 
		     56 Query       select @@version_comment limit 1
		     56 Query       select count(*) into @discard from `mysql`.`help_category`
		     56 Quit       
		     57 Connect     debian-sys-maint@localhost on 
		     57 Query       select @@version_comment limit 1
		     57 Query       select count(*) into @discard from `mysql`.`help_keyword`
		     57 Quit       
110416 19:37:57	     58 Connect     debian-sys-maint@localhost on 
		     58 Query       select @@version_comment limit 1
		     58 Query       select count(*) into @discard from `mysql`.`help_relation`
		     58 Quit       
		     59 Connect     debian-sys-maint@localhost on 
		     59 Query       select @@version_comment limit 1
		     59 Query       select count(*) into @discard from `mysql`.`help_topic`
		     59 Quit       
		     60 Connect     debian-sys-maint@localhost on 
		     60 Query       select @@version_comment limit 1
		     60 Query       select count(*) into @discard from `mysql`.`host`
		     60 Quit       
		     61 Connect     debian-sys-maint@localhost on 
		     61 Query       select @@version_comment limit 1
		     61 Query       select count(*) into @discard from `mysql`.`proc`
		     61 Quit       
		     62 Connect     debian-sys-maint@localhost on 
		     62 Query       select @@version_comment limit 1
		     62 Query       select count(*) into @discard from `mysql`.`procs_priv`
		     62 Quit       
		     63 Connect     debian-sys-maint@localhost on 
		     63 Query       select @@version_comment limit 1
		     63 Query       select count(*) into @discard from `mysql`.`tables_priv`
		     63 Quit       
110416 19:37:58	     64 Connect     debian-sys-maint@localhost on 
		     64 Query       select @@version_comment limit 1
		     64 Query       select count(*) into @discard from `mysql`.`time_zone`
		     64 Quit       
		     65 Connect     debian-sys-maint@localhost on 
		     65 Query       select @@version_comment limit 1
		     65 Query       select count(*) into @discard from `mysql`.`time_zone_leap_second`
		     65 Quit       
		     66 Connect     debian-sys-maint@localhost on 
		     66 Query       select @@version_comment limit 1
		     66 Query       select count(*) into @discard from `mysql`.`time_zone_name`
		     66 Quit       
		     67 Connect     debian-sys-maint@localhost on 
		     67 Query       select @@version_comment limit 1
		     67 Query       select count(*) into @discard from `mysql`.`time_zone_transition`
		     67 Quit       
		     68 Connect     debian-sys-maint@localhost on 
		     68 Query       select @@version_comment limit 1
		     68 Query       select count(*) into @discard from `mysql`.`time_zone_transition_type`
		     68 Quit       
		     69 Connect     debian-sys-maint@localhost on 
		     69 Query       select @@version_comment limit 1
		     69 Query       select count(*) into @discard from `mysql`.`user`
		     69 Quit       
110416 19:38:05	     70 Connect     www-data@localhost as anonymous on 
110416 19:38:06	     70 Query       INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('7e7cbc6c0a6b5a7246326ef09be8bf8d', '10.0.0.5', 'Opera/9.80 (Windows NT 5.1; U; en) Presto/2.7.62 V', 1302982686)
		     70 Query       ROLLBACK
		     70 Query       SET AUTOCOMMIT=1

Any clues in here?

[Cheeseboy]

Nope, no news there, you already had that error in the web UI, didn't you?
Anything in /var/log/mysql.err? There must be a reason the transaction was rolled back....