Install OpenGoo for newbie

[kingkongFive]

Hello,
I'm new to OpenGoo and I would like to try it.
I downloaded it and unzipped it in Xampp (mnt\var\ www).
When I open my browser and type Localhost\opengoo I came across the installation procedure. But on step 3, when I'm asked for a username, password and database name, I get the following message:
Failed to connect to database with data you provided

I've notice the
"Note: You must manually create the database schema before you can continue. "

but I must say I know nothing about php, MySQL or anything else like this.
I tried other groupware or CMS but never had to really work with this...
as mentioned in the subject, I'm just a newbie...

So I can I go through this Step 3?
Txs,
KKF
 

[cabeza]

You must create a database for OpenGoo before installation.
To do it you should execute a create database statement, this means:
1.- open a console
2.- Go to mysql/bin folder whixh should be inside xampp folder
3.- Execute: mysql --user=root -p
4.- Password for root user will be requested, type it and press enter
5.- You will have a mysql> prompt, so type the following: create database opengoo;
6.- You should see something like "Query OK, 1 row affected (0.01 sec)"
7.- Close the console, and retry step 3 of the OpenGoo installer, entering opengoo as database name.
Let us know if you need further instructions.
Marcos

[kingkongFive]

hey cabeza,
I tried what you said.
I open mysql.exe and tried to run the command.
it didn't work but then I enter "create database opengoo;"
and it worked !
thanks a lots   
so now I can try opengoo and I already can say that it is really intuitive and very simple... even for a newbie like me !
again, thanks a lot
KKF

[siswanto]

Dear All,

i have follow this guide the setup database and Success to install opengoo. But, i have new problem.  why i can't load login form ?, The result is blank page...
http://localhost/opengoo/
Can any help me ?

Thanks
siswanto

[OriginalPerser]

Hello siswanto,

i got the same problem after my installation of opengoo. The procedure was without failures, but when it comes to type in the data for administrator account, i just get a empty page?

What might be the problem?

Thanks
OP

[bigbearomaha]

One thing for other folks, even though you said you got the database created.  You said you installed XAMPP,  With XAMPP comes a tool to admin MySQL called "phpmyadmin" if you use the interface for xampp and select admin MySQL, it will take you to this tool which is much easier for folks new to databases to use.

It is only suggested that you use some form of the app name as the name or in the name of the database you create for it.  it makes it easier to identify when it comes time to backup or otherwise administrate it.  Typically though, you can use any name, any name for a user and any password as long as those are the information you provide to the web app config file to access the database.

For security reasons, you should ALWAYS set a secure password ( 8 to 12 characters, mixed letters, numbers and symbols) for the root or admin user of the database.  for example, mySQL provides user "root" with no password by default, it needs one.  same for postgresql, it comes with user 'postgres' and also needs a pass created for it. then you create another user, usually the same name or related.  You shouldn't really use the 'root' or primary database admin account for webapps to access the database.

Big Bear

[Dinesh H]

Dear siswanto and OriginalPerser,

I am also facing the same problem and I have tried both 14.2 and 1.52.  If you have found any solution, please post here, so that it can help me too.

Thanks.
-Dinesh