Following installation instructions exactly leads to botched install, and web-based portion doesn't catch it

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Install FusionPBX using the Easy Install script, and specify MySQL as the 
desired database.
2. When you get to the screen where you need to manually finish the install by 
browsing to the web interface, enter only the information you are told to enter 
by the script.  In particular, note the instructions given for the second page, 
which tell you only to fill in the "Create Database Username" and "Create 
Database Password" fields (and gives no indication that anything is required in 
any of the other fields, let alone what should go into those fields).
3. Click NEXT and note the error messages produced by MySQL, and that the 
installer did not catch any problem or give you another chance to enter the 
correct data (which of course isn't possible anyway if you don't know what you 
did wrong).  Now try to use your browsers back button to try changing and 
resubmitting data - it will not let you do it.  At this point, it appears the 
MySQL database is partially configured but not in such a manner that it is 
usable.

What is the expected output? What do you see instead?

I expect to see an error message (and perhaps suggestions to fix what is wrong) 
and a way to go back and re-enter the missing or invalid data without having to 
scrap the installation and start over from scratch.  In the Easy Install 
script, I expect it to give complete and accurate information about what needs 
to be entered on the second page of the web portion of the install, and not 
assume that somehow I will magically know that any other fields need to be 
filled in, or that I will know what needs to be entered enter into those 
fields.  I do not expect to see a bunch of MySQL error messages and no way to 
back up and fix the error.

After the installation is botched, if I try to browse to the FusionPBX address 
I see the background graphic and two blank translucent white fields and that's 
all.  In particular, there is no login screen offered.

What version of the product are you using? On what operating system?

The version installed by the Easy Install script on November 4, 2012 (early AM) 
under Debian Linux.

Please provide any additional information below.

See 
http://michigantelephone.wordpress.com/2012/11/04/oh-fusionpbx-how-you-vex-me/ 
for screen shots and additional information, but be aware that I was tired and 
not at all happy that I had just wasted a couple hours of my life when I wrote 
it, so my tone was not exactly sunny and bright.

A plea to all concerned with the FusionPBX project:  PLEASE do not assume that 
new users have ANY experience at all in creating or using databases, at least 
not on anything more than an extremely superficial level (which is to say, you 
use software that uses a database, but you neither know nor care anything about 
the database as long as it works).  I've used Asterisk@Home and its successors 
for several years and I could probably count the times I've ever had the need 
to directly look at or modify the database on my fingers, and even then I used 
a tool such as phpMyAdmin or Webmin's database browser to do it.  I honestly 
have no clue how the other fields (not specified by the text in the Easy 
Install script) should be filled in.  I've never directly created a database in 
my life, so why anyone would assume I should know how to fill in this 
information (or that it needs to be filled in at all) is beyond me (I'm in part 
reacting to a comment left by a reader of my blog article here).

Please remember, it's supposed to be an EASY install script, not a script where 
you get to the end and it all blows up because you make a mistake, because you 
assumed the script's instructions told you EVERYTHING you needed to do!

Original issue reported on code.google.com by michigantelephone on 4 Nov 2012 at 5:51

[GoogleCodeExporter]

+1 on this issue. Having a screenful of SQL error messages on a browser when 
you have followed all of the instructions on the terminal screen is not useful.

Original comment by sarahand...@googlemail.com on 8 Nov 2012 at 11:17

[GoogleCodeExporter]

Certainly this can and will be improved as time permits. Priority of database 
support in FusionPBX is in this order PostgreSQL, SQLite, and MySQL. The order 
of ease if use is SQLite, PostgreSQL, MySQL. Native support in FreeSWITCH is 
SQLite and PostgreSQL was recently added and MySQL is unlikely to get native 
support in FreeSWITCH because the libraries to do it are GPL however it is 
still possible to use via ODBC.

As I said before this will be improved as time and resources allow.

Original comment by markjcrane@gmail.com on 10 Nov 2012 at 4:35

• Changed state: Accepted

[GoogleCodeExporter]

Any progress on this? 

I've been trying to install with mysql and it continues to fail. 
Platform:
- CentOS 6.4, 64bit 2.6.32-358.2.1.el6.x86_64
- mysql-server x86_64 Ver 5.1.67 Rel 1.el6_3
- Apache x86_64 Ver 2.2.15 Rel 26.el6.centos

Database gets created, tables created, then GUI reports:
error: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)

To get past that error was to edit the following :
./resources/install.php
./includes/classes/database.php
./app/sql_query/sql_db_conversion.php
./app/sql_query/sql_query_pdo.php

had to change from :
/var/run/mysqld/mysqld.sock 
to:
/var/lib/mysql/mysql.sock 

So now we are listening on the right socket, which got me past that, now I get 
the fusion splash page with nothing on it, so nothing being returned to 
populate the menus. 

I hope this helps someone to go in the right direction to correct the mysql 
issue.

Original comment by smack...@gmail.com on 13 Apr 2013 at 1:37

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

FusionPBX is capable of using SQLite, MySQL and PostgreSQL.

1. SQLite - Recommended for personal and small businesses use. (native to 
freeswitch)
2. Postgres - Developers choice for medium to the largest systems. Native 
driver support to freeswitch)
3. MySQL - It's fast and okay for moderately sized businesses.

Some notes for MySQL.

Installation is not that hard but it might take you a little effort. If you 
don't want to use create database username and password then use the command 
line mysqld to make sure the fusionpbx database has been created. Then make 
sure to use a MySQL user account that has permission to the fusionpbx database 
with permission to add tables.

The install is really not that hard if your experience and knowledge prevents 
you from getting it working then either choose a different database or pay for 
some support to get help installing it. Go to 
http://www.fusionpbx.com/support.php

Original comment by markjcrane@gmail.com on 30 Nov 2013 at 4:47

• Changed state: Done
• Added labels: Type-Other
• Removed labels: Type-Defect