Opened 10 years ago

Closed 10 years ago

#750 closed defect (fixed)

ushahidi doesn't connect to DB during quickstart setup

Reported by: camerons Owned by: live-demo@…
Priority: critical Milestone:
Component: OSGeoLive Keywords: 5.0 ushahidi


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:

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."

Change history (8)

comment:1 Changed 10 years ago by camerons

Resolution: fixed
Status: newclosed

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.

comment:2 Changed 10 years ago by hamish


actually the problem was in 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 tried to automatically set up the db it would fail, as seen in Alex's build log.

hopefully fixed by r6960.


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)

comment:3 Changed 10 years ago by 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.

comment:4 Changed 10 years ago by hamish

Resolution: fixed
Status: closedreopened

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) is still failing to seed the pw into /var/cache/debconf/passwords.txt

... reading up on debconf-set-selections


comment:5 Changed 10 years ago by hamish

Priority: normalcritical

comment:6 Changed 10 years ago by hamish

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

see also


comment:7 Changed 10 years ago by hamish

hopefully fixed by r7044,5,7.

needs testing on a new build!


comment:8 Changed 10 years ago by hamish

Resolution: fixed
Status: reopenedclosed

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.


Note: See TracTickets for help on using tickets.