an abstraction layer so be used to allow different databases to be used

Hello,

an abstraction layer should be used for database access the best choice seems to be http://pear.php.net/package/MDB2

its packahed into centos / debian

(from redmine: issue id 632, created on 2012-02-22, closed on 2012-06-01)

• Changesets:
  • Revision 2c80fce6 by Benoit MORTIER on 2012-04-12T07:42:49.000Z:

Fixes: #632 an abstraction layer so be used to allow different databases to be used

• Revision 9f3a8d16 by Benoit MORTIER on 2012-04-12T08:34:05.000Z:

Fixes: #632 an abstraction layer so be used to allow different databases to be used

• Uploads:
  • 0001-Fixes-632-rsyslog-uses-MDB2.patch
  • 0001-Fixes-632-gofon-uses-MDB2.patch
  • 0002-Fixes-632-Added-require_once.patch
  • 0001-Fixes-632-Refactor-and-code-clean.patch
  • 0002-Forgot.patch
  • 0001-Fixes-632-gofax-using-MDB2.patch
  • 0001-Fixes-632-removed-some-mysql-references.patch
  • 0001-Fixes-632-Removed-more-mysql-occurences.patch
  • 0001-Fixes-632-added-class-databaseManagement.patch
  • 0001-Fixes-632-Using-brand-new-databaseManagement-class.patch

Hello,

this would have to be done for the

gophon gofax rsyslog

plugins

Cheers

(from redmine: written on 2012-03-27)

By bmortier on 2017-09-02T14:40:48 (imported from GitLab)

This might work for rsyslog, I did not manage to test it yet (php path problem)

(from redmine: written on 2012-03-30)

By Côme Chilliet on 2017-09-02T14:40:48 (imported from GitLab)

With this gofon uses MDB2 too. Needs to be heavily tested.

(from redmine: written on 2012-04-11)

By Côme Chilliet on 2017-09-02T14:40:48 (imported from GitLab)

Hello,

applied gophon patch

Cheers

(from redmine: written on 2012-04-11)

By bmortier on 2017-09-02T14:40:48 (imported from GitLab)

Did some code refactor on gofon.

(from redmine: written on 2012-04-11)

By Côme Chilliet on 2017-09-02T14:40:49 (imported from GitLab)

Oops, forgot some ; in last patch

(from redmine: written on 2012-04-11)

By Côme Chilliet on 2017-09-02T14:40:49 (imported from GitLab)

Gofax has been migrated. Needs to be heavily tested

(from redmine: written on 2012-04-11)

By Côme Chilliet on 2017-09-02T14:40:49 (imported from GitLab)

Hello,

i have searched the source for occurence of mysql stuiff and i have found those

in class_msgPool.inc

public static function mysqlerror($error, $plugin= "") { /* Assign headline depending on type */ $headline= ("MySQL operation failed!"); return $headline."

".("Error").": ".$error; }

should be renamed dbError and such in all the plugins using it

in function_debug.inc remove

function print_result($RESULT){}

and in all plugin using it

in class_setupCheck.inc the php mysql module is mandatory is should not be

@ /* Check if mysql module is available */ $N = msgPool::checkingFor(_("MySQL")); $D = _("FusionDirectory requires this module to communicate with several supported databases."); $S = msgPool::installPhpModule("MySQL"); $R = is_callable("mysql_query"); $M = TRUE; $this->basic_checks[] = array("NAME" => $N , "DESC" => $D , "RESULT" => $R , "SOLUTION" => $S , "MUST" => $M ); @

in class_phoneAccount.inc

function generate_mysql_entension_entries($save = false)

should be reamed generateExtensionEntries and in all other part using it

(from redmine: written on 2012-04-11)

By bmortier on 2017-09-02T14:40:50 (imported from GitLab)

Removed most of mysql occurences

(from redmine: written on 2012-04-12)

By Côme Chilliet on 2017-09-02T14:40:50 (imported from GitLab)

Now some operations are in databaseManagement. The class databaseManagement is now the only place where mysql is set as database driver, making it easier to change in the futur.

(from redmine: written on 2012-04-12)

By Côme Chilliet on 2017-09-02T14:40:50 (imported from GitLab)

Close issue

(from redmine: written on 2012-06-01)

By bmortier on 2017-09-02T14:40:50 (imported from GitLab)

closed

By bmortier on 2017-09-02T14:40:51 (imported from GitLab)

added Added PJ1802-0188 fusiondirectory-core labels and removed Bugs label