Connect extension to database on different server

Next topic

Author	Message
Pasha Iakhontov	Wednesday 12 November 2008 6:05:55 pm I have a custom extension that needs to connect to a database on a different server. I can create a new database connection file based on ezdb.php and just modify it to grab the settings from the extensions site.ini, but the problem I have is that all my classes extend eZPersistentObject and my data type extends eZDataType. Obviously those classes just include the the standard call to eZDB::instance() as well as those classes include other classes. I am stuck as I don't see a simple way of achieving what I am after.....any help/ideas appreciated!
Łukasz Serwatka	Thursday 13 November 2008 12:31:20 am Hi, As fare as I remember this is not possible with standard eZ Publish persistent object. Kristof made a patch while ago which allow connect to extrnal DB with eZ P persistent object. See http://issues.ez.no/IssueView.php?Id=10667 Patch was made against 3.9 series, thus you will need to clean up it a bit in order to make with work with 4.x Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Piotrek Karaś	Tuesday 17 March 2009 1:36:54 pm How come hasn't Kristof's patch made it to the regular code? I guess using some independent connection and abstraction layer would be much safer in this case... -- Company: mediaSELF Sp. z o.o., http://www.mediaself.pl eZ references: http://ez.no/partners/worldwide_partners/mediaself eZ certified developer: http://ez.no/certification/verify/272585 eZ blog: http://ez.ryba.eu

Author

Message

Wednesday 12 November 2008 6:05:55 pm

I have a custom extension that needs to connect to a database on a different server.

I can create a new database connection file based on ezdb.php and just modify it to grab the settings from the extensions site.ini, but the problem I have is that all my classes extend eZPersistentObject and my data type extends eZDataType. Obviously those classes just include the the standard call to eZDB::instance() as well as those classes include other classes.

I am stuck as I don't see a simple way of achieving what I am after.....any help/ideas appreciated!

Łukasz Serwatka

Thursday 13 November 2008 12:31:20 am

Hi,

As fare as I remember this is not possible with standard eZ Publish persistent object. Kristof made a patch while ago which allow connect to extrnal DB with eZ P persistent object.

See http://issues.ez.no/IssueView.php?Id=10667

Patch was made against 3.9 series, thus you will need to clean up it a bit in order to make with work with 4.x

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Piotrek Karaś

Tuesday 17 March 2009 1:36:54 pm

How come hasn't Kristof's patch made it to the regular code?
I guess using some independent connection and abstraction layer would be much safer in this case...

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

eZ debug

Timing:	Jan 18 2025 18:27:33
Script start
Timing:	Jan 18 2025 18:27:33
Module start 'layout'
Timing:	Jan 18 2025 18:27:33
Module start 'content'
Timing:	Jan 18 2025 18:27:33
Module end 'content'
Timing:	Jan 18 2025 18:27:33
Script end

Main resources:

Total runtime	0.0148 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	588.0469	152.6406
Module start 'layout'	0.0052	0.0026	740.6875	39.4922
Module start 'content'	0.0078	0.0048	780.1797	89.3672
Module end 'content'	0.0126	0.0021	869.5469	34.3047
Script end	0.0147		903.8516

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	18.5873	14	0.0002
Check MTime	0.0012	8.0269	14	0.0001
Mysql Total
Database connection	0.0010	6.6535	1	0.0010
Mysqli_queries	0.0021	14.1591	3	0.0007
Looping result	0.0000	0.0807	1	0.0000
Template Total	0.0018	12.2	1	0.0018
Template load	0.0011	7.5750	1	0.0011
Template processing	0.0007	4.5621	1	0.0007
Override
Cache load	0.0009	6.0726	1	0.0009
General
dbfile	0.0004	2.3868	8	0.0000
String conversion	0.0000	0.0403	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs