Exceptions while creating PDO objects

Tiny Tiny RSS Support
21

@Elgohan
shit, copy and paste error… :innocent:

Ich habe es mit einer frischen DSM Installation 6.2.2, MariaDB10 und PHP7 unter Synology zum laufen gebracht. Und das ohne PHP5 überhaupt zu installieren. Dazu muss man allerdings phpmyadmin manuell installieren und einrichten.
Was zum Erfolg führt (PDO Error) ist foldendes:
Es hilft für die jeweilige PHP-Installationen eine Datei /usr/local/etc/php56/conf.d/user-settings.ini bzw. /usr/local/etc/php70/conf.d/user-settings.ini anzulegen und dort die relevanten Module bzw. auch spezifische open_basedir hineinzuschreiben.
Für PHP7:
open_basedir = Null

zend_extension = opcache.so
zend_extension = xdebug.so

extension = apcu.so
extension = bcmath.so
extension = bz2.so
extension = calendar.so
extension = curl.so
extension = dba.so
extension = exif.so
extension = ftp.so
extension = gd.so
extension = gettext.so
extension = gmp.so
extension = iconv.so
extension = imap.so
extension = intl.so
extension = ldap.so
extension = mailparse.so
extension = mcrypt.so
extension = memcached.so
extension = mysqli.so
extension = openssl.so
extension = pdo_dblib.so
extension = pdo_mysql.so
extension = pdo_pgsql.so
extension = pdo_sqlite.so
extension = pgsql.so
extension = phar.so
extension = posix.so
extension = redis.so
extension = shmop.so
extension = soap.so
extension = sockets.so
extension = sqlite3.so
extension = ssh2.so
extension = sysvmsg.so
extension = sysvsem.so
extension = sysvshm.so
extension = wddx.so
extension = xmlrpc.so
extension = xsl.so
extension = zip.so

Vielleicht hilft es ja jemandem.
Grüße

22

It could help more people if you’d posted this in English…

23

I did something better… I just compiled a working spk :grinning:

I did a lot of research what has changed with PHP 7.2 and MariaDB10 and what’s going wrong with the package offered by synocommunity. There project spksrc is the base for this package.
But every nice side has a bad side… There is no support for PHP5.6/7.0 and MariaDB5 anymore. Multisupport could be added, but I miss the time for this a the moment.
This package only works for DSM 6.1/6.2 and only with PHP7.2 & MariaDB10 (Port 3307). You could change the port in config.php.
Supported languages are English/French (original) and German (hopefully I translated everthing correct).
I would offer a link if it is appreciated and ok for fox.

@fox
thanks for the great reader and the support!

regards
mmkt

24

as long as it is clear this is a third party thing why not

25

If your Synology model supports the Virtual Machine Manager package, then running tt-rss inside a guest is much easier. You also get the extra functionality provided by VMM, such as the ability to take scheduled snapshots.

26

Mac OSCatalina 10.15.2
XAMPP 7.3.7

I moved my CLI to ZSH from SH. Now, when I run php ./update_daemon2.php, I get:

Exception while creating PDO object:SQLSTATE[HY000] [2002] Operation timed out
%

I figured I’ll move my CLI back to SH. Ran update_daemon2.php again. Same error. I also ran with php ./update.php -daemon. Same error.

I changed ‘DB_HOST’ to a variety of different configurations (’’, ‘localhost’, ‘127.0.0.1’) - did not fix.

Anyone have any ideas on how to resolve?

27

So I answered my own question. For Mac/XAMPP users who have updated to Catalina and initiated zsh, here’s what you need to do:

  1. Create a new file .zprofile at the top of your user directory
  2. Copy the contents of .bash_profile into .zprofile and save
  3. Restart Terminal

The .bash_profile and .zprofile should begin with /Applications/xampp/xamppfiles/bin

Simple, right? {except these instructions oddly do not exist anywhere, apparently}

28

Thanks for sharing.

If the files are going to be identical, you could just soft or hard link them. It’ll save you from updating two files if you need to make changes.

29

Excellent idea. Thanks!