Backend for PostgreSQL

[dsr1811]

Hi,

just double checking on the status of PostgreSql backend, i have installed joey and it looks like the changes are there, but when i install i get:

SQLSTATE[42883]: Undefined function: 7 ERROR: function group_concat(character varying) does not exist at character 78 HINT: No function matches the given name and argument types. You might need to add explicit type casts.

.../library/Zend/Db/Statement.php(284): Zend_Db_Statement_Pdo->_execute()
.../library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute()
.../library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query()
.../Tinebase/Container.php(998): Zend_Db_Adapter_Pdo_Abstract->query()
.../Tinebase/Container.php(251): Tinebase_Container->getGrantsOfContainer()
.../Addressbook/Setup/Initialize.php(192): Tinebase_Container->addGrants()
.../Setup/Initialize.php(71): Addressbook_Setup_Initialize->_createInitialRights()
.../Addressbook/Setup/Initialize.php(47): Setup_Initialize->_initialize()
.../Setup/Initialize.php(44): Addressbook_Setup_Initialize->_initialize()
.../Setup/Controller.php(1359): Setup_Initialize::initialize()
.../Setup/Controller.php(1253): Setup_Controller->_installApplication()
.../Setup/Controller.php(833): Setup_Controller->installApplications()
.../Setup/Frontend/Json.php(241): Setup_Controller->saveAuthentication()
[internal function]: Setup_Frontend_Json->saveAuthentication()
.../library/Zend/Server/Abstract.php(232): call_user_func_array()
.../Zend/Json/Server.php(558): Zend_Server_Abstract->_dispatch()
.../Zend/Json/Server.php(197): Zend_Json_Server->_handle()
.../Setup/Server/Json.php(77): Zend_Json_Server->handle()
.../Setup/Core.php(101): Setup_Server_Json->handle()
.../setup.php(53): Setup_Core::dispatchRequest()


It does seem to install and add the admin user, but it will not let sign in with a bad user/password error, and the log shows a date time exception while trying to create the session, see below:

10d12 -- none -- - 2012-08-30T13:14:40+00:00 INFO (6): Tinebase_Core::setupLogger::523 Logger initialized
10d12 -- none -- - 2012-08-30T13:14:40+00:00 DEBUG (7): Tinebase_Config_Abstract::_loadAllAppConfigsInCache::278 Loading all configs for app Tinebase
10d12 -- none -- - 2012-08-30T13:14:40+00:00 DEBUG (7): Tinebase_Config_Abstract::_loadAllAppConfigsInCache::285 Found 15 configs.
10d12 -- none -- - 2012-08-30T13:14:40+00:00 INFO (6): Tinebase_Core::setupLogger::523 Logger initialized
10d12 -- none -- - 2012-08-30T13:14:40+00:00 INFO (6): Tinebase_Core::setupCache::589 cache of backend type 'File' enabled
10d12 -- none -- - 2012-08-30T13:14:40+00:00 INFO (6): Tinebase_Core::setSessionBackend::803 Session of backend type 'File' configured.
10d12 -- none -- - 2012-08-30T13:14:40+00:00 WARN (4): Tinebase_Core::startSession::704 Session error: DateTimeZone::__construct() [<a href='datetimezone.--construct'>datetimezone.--construct</a>]: Unknown or bad timezone (+00:00)
10d12 -- none -- - 2012-08-30T13:14:40+00:00 DEBUG (7): Tinebase_Core::startSession::705 #0 /home/e-smith/files/ibays/tine20pg/html/Tinebase/DateTime.php(75): DateTimeZone->__construct('+00:00')
#1 [internal function]: Tinebase_DateTime->__wakeup()
#2 /home/e-smith/files/ibays/tine20pg/html/library/Zend/Session.php(479): session_start()
#3 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Core.php(701): Zend_Session::start()
#4 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Core.php(660): Tinebase_Core::startSession(Array)
#5 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Core.php(357): Tinebase_Core::setupSession()
#6 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Server/Json.php(36): Tinebase_Core::initFramework()
#7 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Core.php(232): Tinebase_Server_Json->handle()
#8 /home/e-smith/files/ibays/tine20pg/html/index.php(57): Tinebase_Core::dispatchRequest()
#9 {main}
10d12 -- none -- - 2012-08-30T13:14:40+00:00 DEBUG (7): Tinebase_Server_Json::handle::39 initFramework exception: exception 'Exception' with message 'DateTimeZone::__construct() [<a href='datetimezone.--construct'>datetimezone.--construct</a>]: Unknown or bad timezone (+00:00)' in /home/e-smith/files/ibays/tine20pg/html/Tinebase/DateTime.php:75
Stack trace:
#0 /home/e-smith/files/ibays/tine20pg/html/Tinebase/DateTime.php(75): DateTimeZone->__construct('+00:00')
#1 [internal function]: Tinebase_DateTime->__wakeup()
#2 /home/e-smith/files/ibays/tine20pg/html/library/Zend/Session.php(479): session_start()
#3 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Core.php(701): Zend_Session::start()
#4 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Core.php(660): Tinebase_Core::startSession(Array)
#5 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Core.php(357): Tinebase_Core::setupSession()
#6 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Server/Json.php(36): Tinebase_Core::initFramework()
#7 /home/e-smith/files/ibays/tine20pg/html/Tinebase/Core.php(232): Tinebase_Server_Json->handle()
#8 /home/e-smith/files/ibays/tine20pg/html/index.php(57): Tinebase_Core::dispatchRequest()
#9 {main}
10d12 -- none -- - 2012-08-30T13:14:40+00:00 DEBUG (7): Tinebase_Server_Json::handle::67 is JSON request. rawdata: Array
(
[0] => Array
(
[jsonrpc] => 2.0
[method] => Tinebase.login
[params] => Array
(
[username] => admin
[password] => *******
)

[id] => 3
)

)


so i am not sure if this is related to selecting the postgre driver, i would appreciate any ideas on this. thanks.

[fgsl]

Hello, dsr1811.

I will download the last release and verify it.

group_concat() is a MySQL function, it doesn't exist in PostgreSQL.

I remember that I already fixed it in pgsqlbackend branch. It must be easy to fix in master now.

Thank you for reporting.

[dsr1811]

Hi fgsl,

Thanks for your work on this!!.

I was finally able to get pgsqlbranch to install and login, but not master. I am having some issues with pgsqlbranch though. Are you able to install and use all features with your branch? The installer did not like the sales or the mail modules, not that critical, right now and i understand that this is a work in progress.

Also, I also noticed a couple of other errors, they are as follows:

1) http://xxx.xxx.com/themes/tine20/resour ... 20.css.css" - cant find this file

2) The import seems to be failing also with, message repeated for every record:

b1788 Admin Account, Tine 2.0 - 2012-09-05T14:22:40+00:00 INFO (6): Tinebase_Import_Abstract::_handleImportException::661 SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying = integer at character 145
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.


Other that than that all else looks good. Thanks.l

[fgsl]

About the error with group_concat() function, I have open the issue 7062.

https://forge.tine20.org/mantisbt/view.php?id=7062

[fgsl]

Hi, dsr1811.

I will verify this problems comparing branch pgsqlbackend with Joey, but could you report these bugs in Mantis?

https://forge.tine20.org/mantisbt

[dsr1811]

Yes, i will post when i get a chance this week, thanks.

[ph_il]

full postgresql support has been included in Joey (2012.10). please report any bugs you find in our mantis bugtracker.

[AFM]

Hello
We published PostgreSQL tunings for using with Tine20.
One could expect around 20% gain at similar hw and sw setup.
These are, actually, a sequence of articles regarding Postgresql, kernel, net and block i/o, file system, data storage, virtualization tunings.

If your site allows publishing external url, we could directly point to the article at http://www.techforce.com.br/news/linux_ ... ng_example

Regards.
Andre Felipe

[ph_il]

this should be added to the wiki, maybe we should add a "database performance optimization" section there. what do you think?