Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

archive.sh and pdo_mysql #1190

Closed
anonymous-matomo-user opened this issue Mar 3, 2010 · 5 comments
Closed

archive.sh and pdo_mysql #1190

anonymous-matomo-user opened this issue Mar 3, 2010 · 5 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Milestone

Comments

@anonymous-matomo-user
Copy link

Hello!
My OS: CentOS
Piwik vers: 0.5.4
I have a Zend Server Community Edition and mysql 5.0.77
Piwik works good, very good). pdo_mysql - is up and running. All excellent.

But when you run the script:
piwik/misc/cron/archive.sh

You get an error:
#0 / ...path.../libs/Zend/Db/Adapter/Pdo/Mysql.php (96): Zend_Db_Adapter_Pdo_Abstract-> _connect ()
#1 / ...path.../core/Db/Pdo/Mysql.php (30): Zend_Db_Adapter_Pdo_Mysql-> _connect ()
#2 / ...path.../core/Piwik.php (1479): Piwik_Db_Pdo_Mysql-> getConnection ()
#3 / ...path.../core/FrontController.php (218): Piwik:: createDatabaseObject ()
#4 / ...path.../index.php (103): Piwik_FrontController-> init ()
#5 (main)

Thank you.

@robocoder
Copy link
Contributor

Check your PATH (and lib path). When you use archive.sh, you're using php-cli -- depending on your PATH, this could be Zend Server or the pre-built php binaries that came with your original CentOS install.

@anonymous-matomo-user
Copy link
Author

Where can directly set the path to pdo_mysql, which would archive.sh saw him?

@robocoder
Copy link
Contributor

That's not what I said.

The problem is that archive.sh is finding your old php binary instead of the Zend Server version. Check your PATH. You might have to do something like editing your PATH, customizing archive.sh for your environment, or creating a soft-link, eg

ln -s /usr/local/zend/bin/php-cli /usr/bin/php

@anonymous-matomo-user
Copy link
Author

Write:

for TEST_PHP_BIN in php5 php; do
      if which /usr/local/zend/bin/php >/dev/null 2>/dev/null; then
        PHP_BIN=`/usr/local/zend/bin/php`
        break
      fi
    done

But it became an error:

The mysql driver is not currently installed

Mysql - installed, and - works fine.:

rpm-qa | grep mysql
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-5.0.77-4.el5_4.1
mysql-server-5.0.77-4.el5_4.1
mysql-5.0.77-4.el5_4.1
mysql-devel-5.0.77-4.el5_4.1
mysql-bench-5.0.77-4.el5_4.1
mysql-connector-odbc-3.51.26r1127-1.el5
mysql-devel-5.0.77-4.el5_4.1

What to do? What data are needed to solve this problem?

@robocoder
Copy link
Contributor

Please don't use Trac for technical support.

I have posted my response in the forum where you re-opened a thread.

http://forum.piwik.org/index.php?showtopic=5401

Thanks.

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Projects
None yet
Development

No branches or pull requests

3 participants