ushahidi doesn't connect to DB during quickstart setup

[camerons]

Running osgeolive5.0b5, I open a clean VM, then open ushahidi application by selecting ushahidi from the pull down menu.

I then start following the steps of the quickstart:  http://adhoc.osgeo.osuosl.org/livedvd/docs/en/quickstart/ushahidi_quickstart.html

Choose “Basic Installation”, “Let’s get started”, and it will prompt you for a few details. The database name is “ushahidi”, database user name is “user”, the password is also “user”. The database host is “localhost”. Then continue.

I then get the following error: "Oops! We couldn't make a connection to the database server with the credentials given. Please make sure they are correct."

[camerons]

On 19/08/11 19:43, Henry Addo wrote:

Fixed the installer and updated the quickstart doc to accommodate failed mysql database setup. I have the changes committed to the repo. I tested the installer locally but pretty certain it will work on osgeolive 5.0. I'll download the mini iso over the weekend to play around with it.

[hamish]

Hi,

actually the problem was in install_mysql.sh. The seeding of the admin pw was failing because the server's package name changed with this version of ubuntu and the value in /var/cache/debconf/password.txt was empty. So when install_ushahidi.sh tried to automatically set up the db it would fail, as seen in Alex's build log.

hopefully fixed by r6960.

Hamish

ps- re. the new quickstart hint: are the instructions valid as there is no root password? (you need to do sudo su to get there)

[hamish]

ps- on the desktop the passwords.txt file lists "administrative,user" for the mysql acc't. is the username actually "administrative" or is that just descriptive? the pw is ok.

[hamish]

no luck, still get the "Ops!" when you try to log in.

5.0rc2 build log, as well as if you try mysql -uroot -p, "user":

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

install_mysql.sh is still failing to seed the pw into /var/cache/debconf/passwords.txt

... reading up on debconf-set-selections

Hamish

[hamish]

trying for better debconf pre-seeding in r7043, but not entirely optimistic.

see also  http://serverfault.com/questions/19367/scripted-install-of-mysql-on-ubuntu/19399#19399

Hamish

[hamish]

hopefully fixed by r7044,5,7.

needs testing on a new build!

Hamish

[hamish]

5.0rc3: fixed!

It seems the trouble with pre-seeding the pw for root was the lack of "seen true" in the debconf hints.

anyway, it is now possible to auth as both 'root' and 'user', and ushahidi can get past that page onto the create project one.

Hamish