Opened 8 years ago

Closed 8 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
Cc:

Description

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

Change history (8)

comment:1 Changed 8 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 8 years ago by 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)

comment:3 Changed 8 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 8 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)

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

... reading up on debconf-set-selections

Hamish

comment:5 Changed 8 years ago by hamish

Priority: normalcritical

comment:6 Changed 8 years ago by 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

comment:7 Changed 8 years ago by hamish

hopefully fixed by r7044,5,7.

needs testing on a new build!

Hamish

comment:8 Changed 8 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.

Hamish

Note: See TracTickets for help on using tickets.