Opened 12 years ago
Closed 12 years ago
#750 closed defect (fixed)
ushahidi doesn't connect to DB during quickstart setup
|Reported by:||camerons||Owned by:|
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 by , 12 years ago
|Status:||new → closed|
comment:2 by , 12 years ago
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.
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 by , 12 years ago
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 by , 12 years ago
|Status:||closed → reopened|
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
comment:5 by , 12 years ago
|Priority:||normal → critical|
comment:6 by , 12 years ago
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
comment:7 by , 12 years ago
hopefully fixed by r7044,5,7.
needs testing on a new build!
comment:8 by , 12 years ago
|Status:||reopened → closed|
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.
On 19/08/11 19:43, Henry Addo wrote: