[SOLVED] installing webacula - 'Can't connect to SQL server'

Pomardako · 02-07-2013, 11:36 AM

Hi guys, at the first, my apologize for my english, not so very good

.

I have a problem with the webacula installation , i write the problem here :

Fatal error: Uncaught exception 'Zend_Exception' with message 'Fatal error: Can't connect to SQL server' in /var/www/webacula/html/index.php:178
Stack trace:
#0 {main}
thrown in /var/www/webacula/html/index.php on line 178

-The requirements its correct..

Webacula check System Requirements...

sh: psql: not found
sh: sqlite3: not found
Current MySQL version = 5.1.41 OK

Current PHP version = 5.3.2-1ubuntu4.18 OK

php pdo installed. OK
php gd installed. OK
php xml installed. OK
php dom installed. OK

php pdo_mysql installed. OK
Warning. PHP extension pdo_pgsql not installed.
Warning. PHP extension pdo_sqlite not installed.
php-dom, php-xml installed. OK

-I have the "zend-framework" at /var/www/webacula/library/Zend.

-I reviewed the /var/www/webacula/install/db.conf.

-I can connect with bconsole with console commands.

-I followed this manuals, and doesnt work anything :

http://cheatsheet.logicalwebhost.com/bacula-howto/

https://dev.uabgrid.uab.edu/wiki/WebaculaInstallation

http://www.java-tutorial.ch/ubuntu/w...tion-on-ubuntu

Any idea?

Thx a lot!

Habitual · 02-07-2013, 06:31 PM

Code:

php -m | grep pdo

Pomardako · 02-08-2013, 09:26 AM

Code:

bacula@bacula:~$ sudo php -m | grep pdo
[sudo] password for bacula:
pdo_mysql

:?

Habitual · 02-08-2013, 12:11 PM

Code:

php -v
lsb_release -drc
ls -ld /var/lib/mysql/web*

output please.

Pomardako · 02-08-2013, 12:31 PM

OMG! , i solved this problem. This is ridiculous. Only put the quotes in the config.ini at the connection config. All manuals dont put this quotes!

Quote:

[general]
;; supported adapters : PDO_MYSQL, PDO_PGSQL, PDO_SQLITE
db.adapter = "PDO_MYSQL"
db.config.host = "192.168.2.229"
db.config.username = "bacula"
db.config.password = "admin"
db.config.dbname = "bacula"
;; for Sqlite db.config.dbname = "/full patch/bacula.db"

Thx a lot!

Pomardako · 02-08-2013, 12:43 PM

Ah, and other fix, at /etc/mysql/my.cnf

comment this line :

Quote:

#bind-address = 127.0.0.1

Habitual · 02-08-2013, 01:17 PM

good catch!