Radicore Forum: RADICORE Installation Issues » How to consolidate all the Radicore databases into a single database

Home » RADICORE » RADICORE Installation Issues » How to consolidate all the Radicore databases into a single database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to consolidate all the Radicore databases into a single database [message #7278]

Mon, 25 February 2019 13:01

MattieValdez
Messages: 1
Registered: February 2019

Junior Member

How can I consolidate all the Radicore databases into a single database

Report message to a moderator

Re: How to consolidate all the Radicore databases into a single database [message #7279 is a reply to message #7278]

Mon, 25 February 2019 13:17

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

It is not acceptable to append a new question onto somebody else's thread, so I have split this off into its own thread.

To answer your question I suggest you read http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq150

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: How to consolidate all the Radicore databases into a single database [message #7653 is a reply to message #7279]

Wed, 15 September 2021 16:40

PeterdePutter
Messages: 4
Registered: September 2021
Location: Amersfoort

Junior Member

Hello,

Even after reading the aforementioned FAQ, and setting all values in config.inc, I still experience some problems...
The errorlog shows:

Fatal Error: MySQL: Access denied for user 'Peter'@'%' to database 'k1593_audit' (# 1044)
Error in line 113 of file '____/radicore/includes/dml.mysqli.class.inc'.

Please note the bold text, since that should be (according to config.inc):
$servers[0]['switch_dbnames'] = array('audit' => 'single'

In MySQL, the database k1593_single does exist..
Probably just missing something, plze assist...

Report message to a moderator

Re: How to consolidate all the Radicore databases into a single database [message #7654 is a reply to message #7653]

Thu, 16 September 2021 04:35

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Can you send me a copy of your config.inc file so I can see what values you have defined?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: How to consolidate all the Radicore databases into a single database [message #7655 is a reply to message #7654]

Fri, 17 September 2021 17:45

PeterdePutter
Messages: 4
Registered: September 2021
Location: Amersfoort

Junior Member

Sure, the relevant items as follows:
Please note that name of the (single) database has changed into "auditgame".

Code: [Select all] [Show/ hide]

$GLOBALS['dbms']   = 'mysql';      // database engine is MySQL
$GLOBALS['dbhost'] = 'localhost';
$GLOBALS['SERVER_NAME'] = 'localhost';

$GLOBALS['dbusername'] = 'Peter';
$GLOBALS['dbprefix']   = 'k1593_';
$GLOBALS['dbport']     = 3306;
$GLOBALS['dbsocket']   = null;

// this demonstrates the multi-server option (see FAQ92)
if (preg_match('/^(127.0.0.1|localhost|desktop|laptop)$/i', $_SERVER['SERVER_NAME'])) {
    global $servers;
    $servers[0]['dbhost']     = $dbhost;
    $servers[0]['dbengine']   = $dbms;
    $servers[0]['dbusername'] = $dbusername;
    $servers[0]['dbuserpass'] = $dbuserpass;
    $servers[0]['dbport']     = $dbport;
    $servers[0]['dbprefix']   = $dbprefix;

// these are the database names used in the Data Dictionary
    $servers[0]['dbnames']    = 'audit, dict, menu, workflow';
// these are the database names used on the server
    $servers[0]['switch_dbnames'] = array('audit' => 'auditgame',
					  'dict' => 'auditgame',
					  'menu' => 'auditgame',
					  'workflow' => 'auditgame');

Report message to a moderator

Re: How to consolidate all the Radicore databases into a single database [message #7656 is a reply to message #7655]

Sat, 18 September 2021 04:25

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

The reason that the framework is looking for a database with the prefix 'k1593_' is because you told it to. Your config file contains this at line 5:

Code: [Select all] [Show/ hide]

$GLOBALS['dbprefix']   = 'k1593_';

and then this at line 16:

Code: [Select all] [Show/ hide]

$servers[0]['dbprefix']   = $dbprefix;

If you dont want to use a prefix then line 16 should set it to empty.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: How to consolidate all the Radicore databases into a single database [message #7657 is a reply to message #7656]

Sat, 18 September 2021 04:44

PeterdePutter
Messages: 4
Registered: September 2021
Location: Amersfoort

Junior Member

Tony,

Thanks for your reply. However, the problem is that the framework is looking for a database "k1593_audit" when it should be looking for the database "k1593_auditgame". The prefix is fine, since my ISP is forcing this on me... Confused

I'm still thinking i'm missing something simple...
Maybe the problem is, that i am dealing with a combination of a prefixed database and all databases consolidated in one?

Excuse my English grammar, since this is not my native language

Report message to a moderator

Re: How to consolidate all the Radicore databases into a single database [message #7658 is a reply to message #7657]

Sat, 18 September 2021 05:14

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Look at the condition on line 9:

Code: [Select all] [Show/ hide]

if (preg_match('/^(127.0.0.1|localhost|desktop|laptop)$/i', $_SERVER['SERVER_NAME'])) {

This will only set values in $servers[0] if that condition is met. That example was for my personal test environment, so you either need to to comment out this line OR change the server name.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: How to consolidate all the Radicore databases into a single database [message #7659 is a reply to message #7658]

Sat, 18 September 2021 07:52

PeterdePutter
Messages: 4
Registered: September 2021
Location: Amersfoort

Junior Member

Thanks!
That works like a charm!

Report message to a moderator

Previous Topic:	Installation issue
Next Topic:	V 2.19.0 - logon problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jun 20 08:37:38 EDT 2025

Total time taken to generate the page: 0.10307 seconds