Page 1 of 2
Problems with Update
Posted: 03 Apr 2011, 12:08
by 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
Re: Problems with Update
Posted: 03 Apr 2011, 12:18
by 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
Re: Problems with Update
Posted: 03 Apr 2011, 14:34
by 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
Re: Problems with Update
Posted: 03 Apr 2011, 15:08
by 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
Re: Problems with Update
Posted: 03 Apr 2011, 15:17
by Ubi
<<this post is removed by Ubi because of enhanced stupidity by ubi himselfs>>
Re: Problems with Update
Posted: 03 Apr 2011, 16:38
by 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
Re: Problems with Update
Posted: 04 Apr 2011, 00:28
by DanielM
Ubi wrote:<<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
matse wrote: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
Re: Problems with Update
Posted: 10 Apr 2011, 12:59
by 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
Re: Problems with Update
Posted: 10 Apr 2011, 13:50
by Ubi
You'd almost say the database was no longer present. Could you go into mysql as root and type
?
Re: Problems with Update
Posted: 10 Apr 2011, 15:00
by 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
Re: Problems with Update
Posted: 10 Apr 2011, 15:36
by 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.
Re: Problems with Update
Posted: 16 Apr 2011, 15:46
by matse
How do I turn on mysql query logging?
Thanks!
Mats
Re: Problems with Update
Posted: 16 Apr 2011, 16:20
by 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:
Re: Problems with Update
Posted: 16 Apr 2011, 16:46
by 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?
Re: Problems with Update
Posted: 16 Apr 2011, 17:15
by 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....