Calendar upgrade and PHP/Sqlite bug

[Cedric_C]

Hi everybody !

I am trying to update an existing EGW 1.6.003 to 1.8.001. Everything went fine except for the calendar module which refuses to upgrade (blank page).

Looking at Apache2 error log, the error reported is the following:
/usr/sbin/httpd2-prefork: symbol lookup error: /usr/lib/php5/extensions/pdo_sqlite.so: undefined symbol: sqlite3_open

I have checked which sqlite packages are installed on my system (SUSE Linux Enterprise Server 10 SP2):

rpm -qa | grep sqlite

sqlite-devel-3.2.8-15.2
php5-sqlite-5.3.2-28.1
sqlite-3.2.8-15.2

And that sqlite module is loaded in PHP (5.3.2):

php5 -i

…
pdo_sqlite

PDO Driver for SQLite 3.x => enabled
php5: symbol lookup error: /usr/lib/php5/extensions/pdo_sqlite.so: undefined symbol: sqlite3_libversion

Again we have an error with pdo_sqlite.so…

So I searched the web and I found this:
http://bugs.php.net/bug.php?id=48614

It seems that there is a known bug with PHP 5.3.x and the sqlite3 module which is not resolved yet !

I have found other products than EGW which have the same problem but sqlite can be deactivated in this products:
http://forums.cpanel.net/f5/undefined-symbol-sqlite3_libversion-148993.html
http://www.blogtips.org/php-532-permalinks-and-wordpress/

I read on the EGW Wiki that sqlite is needed by the new timezone system used in the calendar module so I can’t deactivate it.
Therefore, EGW needs PHP > 5.2, downgrading PHP is not favourite option as it may cause other problems and not resolve the main problem.

Does someone get the same problem ? Is there a way to correct it ?

Any help would be greatly appreciated, thanks !

Cédric

[Leithoff_Klaus]

main thing the sqlite is doing is delivering the timezone info we need for the timezonesupport.
If you create and fill the timezonetable manually using this:
http://dev.egroupware.org/other/egw_cal_timezones.sql.bz2
you may be able to ignore the errors wile updating, but I am not sure if it helps you at all, as you report to recive to get a blank screen on the attempt of updating.
at least give it a try, it will not hurt.

[Cedric_C]

Hello Klaus,

I did execute the SQL query you provided. I still can’t get calendar app
to update properly in the setup menu, anyway EGW seems to work.

I have now an other issue with my Funambol client which I use to sync
Outlook clients. It simply doesn’t work anymore. RPC server is returning
empty replies.

I have done some research and I found this:
http://www.egroupware.org/wiki?wikipage=synchronisation%20outlook

At the bottom of the text it is written that Funambol Outlook client is
not supported anymore, is it true ?

Best regards.

main thing the sqlite is doing is delivering the timezone info we need for the timezonesupport.
If you create and fill the timezonetable manually using this:
http://dev.egroupware.org/other/egw_cal_timezones.sql.bz2
you may be able to ignore the errors wile updating, but I am not sure if it helps you at all, as you report to recive to get a blank screen on the attempt of updating.
at least give it a try, it will not hurt.
Von: “Cedric C.” cedric.canitrot@orange-ftgroup.com
An: egroupware-developers@lists.sourceforge.net
Datum: Fri, 14 Jan 2011 05:28:11 -0800 (PST)

Hi everybody !

I am trying to update an existing EGW 1.6.003 to 1.8.001. Everything went
fine except for the calendar module which refuses to upgrade (blank page).

Looking at Apache2 error log, the error reported is the following:
/usr/sbin/httpd2-prefork: symbol lookup error:
/usr/lib/php5/extensions/pdo_sqlite.so: undefined symbol: sqlite3_open

I have checked which sqlite packages are installed on my system (SUSE Linux
Enterprise Server 10 SP2):

rpm -qa | grep sqlite

sqlite-devel-3.2.8-15.2
php5-sqlite-5.3.2-28.1
sqlite-3.2.8-15.2

And that sqlite module is loaded in PHP (5.3.2):

php5 -i

…
pdo_sqlite

PDO Driver for SQLite 3.x => enabled
php5: symbol lookup error: /usr/lib/php5/extensions/pdo_sqlite.so:
undefined
symbol: sqlite3_libversion

Again we have an error with pdo_sqlite.so…

So I searched the web and I found this:
http://bugs.php.net/bug.php?id=48614

It seems that there is a known bug with PHP 5.3.x and the sqlite3 module
which is not resolved yet !

I have found other products than EGW which have the same problem but sqlite
can be deactivated in this products:

http://forums.cpanel.net/f5/undefined-symbol-sqlite3_libversion-1489
93.html
http://www.blogtips.org/php-532-permalinks-and-wordpress/

I read on the EGW Wiki that sqlite is needed by the new timezone system used
in the calendar module so I can’t deactivate it.
Therefore, EGW needs PHP> 5.2, downgrading PHP is not favourite option as
it may cause other problems and not resolve the main problem.

Does someone get the same problem ? Is there a way to correct it ?

Any help would be greatly appreciated, thanks !

Cédric

–
View this message in context:
http://egroupware.219119.n3.nabble.com/Calendar-upgrade-and-PHP-Sqli
te-bug-tp2255421p2255421.html
Sent from the egroupware-developers mailing list archive at Nabble.com.

---

---

Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

---

IMPORTANT.Les informations contenues dans ce message electronique y compris les fichiers attaches sont strictement confidentielles
et peuvent etre protegees par la loi.
Ce message electronique est destine exclusivement au(x) destinataire(s) mentionne(s) ci-dessus.
Si vous avez recu ce message par erreur ou s il ne vous est pas destine, veuillez immediatement le signaler a l expediteur et effacer ce message
et tous les fichiers eventuellement attaches.
Toute lecture, exploitation ou transmission des informations contenues dans ce message est interdite.
Tout message electronique est susceptible d alteration.
A ce titre, le Groupe France Telecom decline toute responsabilite notamment s il a ete altere, deforme ou falsifie.
De meme, il appartient au destinataire de s assurer de l absence de tout virus.

IMPORTANT.This e-mail message and any attachments are strictly confidential and may be protected by law. This message is
intended only for the named recipient(s) above.
If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this e-mail message.
Any unauthorized view, usage or disclosure ofthis message is prohibited.
Since e-mail messages may not be reliable, France Telecom Group shall not be liable for any message if modified, changed or falsified.
Additionally the recipient should ensure they are actually virus free.

---