Page 1 of 2

Incompatible change coming for RC2

Posted: Thu Nov 26, 2009 3:43 pm
by cpg
hi

we have an incompatible change coming for the platform. related to bug #41, having a separate user and password for the platform.

at the moment i am testing with rpms from http://alpha.amahi.org/tmp/
for platform (4.3-24) and hdactl (2.45-1).

for testing this: you rpm -Uvh --nodeps those two rpms *BEFORE* running the amahi-installer command.

i am not 100% positive it works so please report.

if you already have an f12 machine and would like to try by doing an update:

update those two rpms and then issue the sql command below as root (mysql -u root -p) with hda as the password.

this is a simple change but rather hard to do with updates.

if you update and it does not work (phusion complains about config/database.yml) you should be able to fix it with this mysql command (mysql -u root -phda):

Code: Select all

GRANT ALL PRIVILEGES ON *.* to 'amahihda'@'localhost' IDENTIFIED BY 'AmahiHDARulez' WITH GRANT OPTION;
*edit* you will also need to do these shell commands:

Code: Select all

mysqladmin -u root -p create hda_production [enter "hda" as the password] mysqldump --add-drop-table -u root -phda demo_development | mysql -u root -phda hda_production mysqladmin -u root -p drop demo_development [enter "hda" as the password]

Re: Incompatible change coming for RC2

Posted: Thu Nov 26, 2009 8:07 pm
by rampage537
[root@home tmp]# rpm -Uvh --nodeps hdactl-2.45-1.i386.rpm
Preparing... ########################################### [100%]
file /etc/cron.hourly/hda-update from install of hdactl-2.45-1.i386 conflicts with file from package hdactl-2.44-38.x86_64
...
[root@home tmp]#

Re: Incompatible change coming for RC2

Posted: Thu Nov 26, 2009 10:00 pm
by cpg
ok, i put the hdactl-2.45-1.x86_64.rpm (64 bits) in there ... http://alpha.amahi.org/tmp/

however, by the time you read this, you may already see some new rpms there, as i can see this rpm has a broken installer :(

Re: Incompatible change coming for RC2

Posted: Thu Nov 26, 2009 10:09 pm
by rampage537
There appears to be a database problem.

*
Your config/database.yml may not be written correctly. Please check it and fix any errors.
*
Your database schema may be out of date or nonexistant. Please run rake db:migrate to ensure that the database schema is up-to-date.
*
The database server may not be running. Please check whether it's running, and start it if it isn't.

Error message:
Unknown database 'hda_production' (Mysql::Error)
Exception class:
Mysql::Error

Re: Incompatible change coming for RC2

Posted: Fri Nov 27, 2009 12:30 am
by cpg
*edit* you will also need to do this to move the demo_development database into the hda_production:

Code: Select all

mysqladmin -u root -p create hda_production [enter "hda" as the password] mysqldump --add-drop-table -u root -phda demo_development | mysql -u root -phda hda_production mysqladmin -u root -p drop demo_development [enter "hda" as the password]

Re: Incompatible change coming for RC2

Posted: Fri Nov 27, 2009 6:25 am
by cpg
OK, thanks for helping out rampage!!

i pushed some more changes into git and also released this into the f12 repo.

this will break every single f12 machine out there as far as the amahi web interface is concerned.

see the code in the first post in this thread on how to recover a machine that has croaked.

Re: Incompatible change coming for RC2

Posted: Fri Nov 27, 2009 6:39 am
by cpg
come to think about it, this change could break app installation, in particular creating and destroying DBs for apps!

please test a few apps to see how they install and uninstall.

also, another area to test is creating aliases and static ips. report any issues there (not inside the router stuff).

Re: Incompatible change coming for RC2

Posted: Fri Nov 27, 2009 1:44 pm
by rampage537
cpg the files are missing from the alpha folder

Re: Incompatible change coming for RC2

Posted: Fri Nov 27, 2009 1:47 pm
by rampage537
I have not had any issues with any apps so far

Re: Incompatible change coming for RC2

Posted: Fri Nov 27, 2009 2:22 pm
by cpg
cpg the files are missing from the alpha folder
sorry if it wasn't clear.

these were released to the repo, so they will get picked up automatically via automatic updates.