Client Support Community Server Status Contact Us Client Login
Email Hosting Website Hosting Reseller Hosting VPS Hosting Dedicated Servers
    Join our Community      Check your private messages       Profile       Search       FAQ       Memberlist       Log in

Installing PDO Driver for MySQL
Goto page 1, 2  Next
  
Post new topic   Reply to topic    NetHosted Community Index -> General Support
Axolotl Reply with quote
 NetHosted Customer

 

 Joined: 17 Jan 2005
 Posts: 22
 
PostPosted: Sun Jun 10, 2007 10:17 pm    Post subject: Installing PDO Driver for MySQL
 
Hi Andrew et al,

I'm just wondering if it's possible to install the PDO Driver for MySQL DB?
http://au3.php.net/pdo 

My shared IP address is: 85.13.238.130
(not sure which server this is)

Thanks again for the great support and prompt services.

Regards,
Tim
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5684
 
PostPosted: Sun Jun 10, 2007 10:39 pm    Post subject:
 
Hi,

I'll look into this for you after the servers have had their kernels upgraded (due to happen shortly).

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5684
 
PostPosted: Sun Jun 10, 2007 11:07 pm    Post subject:
 
Tim,

This has been installed for you.

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Floob Reply with quote
 NetHosted Customer

 

 Joined: 01 Apr 2005
 Posts: 51
 
PostPosted: Mon Jun 11, 2007 12:28 am    Post subject:
 
Has this got anything to do with MySQL being down?

Ticket raised.
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5684
 
PostPosted: Mon Jun 11, 2007 12:50 am    Post subject:
 
Ticket answered, issue solved

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Axolotl Reply with quote
 NetHosted Customer

 

 Joined: 17 Jan 2005
 Posts: 22
 
PostPosted: Mon Jun 11, 2007 9:18 am    Post subject:
 
Hi Andrew,

Thanks again for your help and quick response. However it seems like the PDO driver for MySQL has note yet been installed.

According to phpinfo():

PDO support enabled
PDO drivers sqlite2, sqlite

I am on:
System Linux jupiter.solardns.com 2.6.9-55.7.ELsmp #1 SMP Wed Jun 6 17:13:38 EDT 2007 i686

Thank you!

Tim
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5684
 
PostPosted: Mon Jun 11, 2007 10:21 am    Post subject:
 
Tim,

I'm taking a look.

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5684
 
PostPosted: Mon Jun 11, 2007 10:55 am    Post subject:
 
Tim,

I can't get this to work, the mysql driver is not loading without error when added as an extension. This could be due to the version of PHP 5 we are using but I can't find any concrete help on the internet regarding this either.

Sorry,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Axolotl Reply with quote
 NetHosted Customer

 

 Joined: 17 Jan 2005
 Posts: 22
 
PostPosted: Mon Jun 11, 2007 1:23 pm    Post subject:
 
Hi Andrew,

Thanks for getting back to me again.

In regards to the error you get when installing the MySQL PDO driver, may I ask you what errors you are getting so may be I can lend a hand (and indirectly back to me

I found this attached to the comments from the PHP documentation. See if this can be of any help.

Quote:
If your having problems re-compiling PHP with PDO as shared module try this.

--enable-pdo=shared
--with-pdo-mysql=shared,/usr/local/mysql
--with-sqlite=shared
--with-pdo-sqlite=shared

1. If PDO is built as a shared modules, all PDO drivers must also be
built as shared modules.
2. If ext/pdo_sqlite is built as a shared module, ext/sqlite must also
be built as a shared module.
3. In the extensions entries, if ext/pdo_sqlite is built as a shared
module, php.ini must specify pdo_sqlite first, followed by sqlite.


I really would like to get this working because using this then the application will be able to use transactions and commit with the InnoDB engine of MySQL.

Good luck!

Thanks again.

Tim
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5684
 
PostPosted: Mon Jun 11, 2007 1:34 pm    Post subject:
 
Tim,

Although possible to compile into PHP this way I'd prefer to use pear/pecl to get it working. The error is:

Code:
pdo_mysql.so: undefined symbol: php_pdo_declare_long_constant


We run PHP as a CGI module I'm not sure if this affects PDO in any way.

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Axolotl Reply with quote
 NetHosted Customer

 

 Joined: 17 Jan 2005
 Posts: 22
 
PostPosted: Tue Jun 12, 2007 6:11 am    Post subject:
 
Hi Andrew,

I read that when it comes to making the PDO MySQL driver to work, the order which the extensions are loaded can matter.

Also there is a bug report which has quite a bit of feedback on using pear/pecl to install:
http://pecl.php.net/bugs/bug.php?id=6117 

Looks like it's not a straightforward solution. Hope you will look into it again please.

Tim
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5684
 
PostPosted: Tue Jun 12, 2007 6:58 am    Post subject:
 
Tim,

I will take a look, this bug report does look quite old though!

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5684
 
PostPosted: Tue Jun 12, 2007 9:54 am    Post subject:
 
I've tried a few things mentioned in there but it's still not playing ball. I tried an upgrade to the latest PHP 5 to see if that helped but that caused so many problems in general that I had to revert before I could attempt the PDO stuff.

Sorry,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Axolotl Reply with quote
 NetHosted Customer

 

 Joined: 17 Jan 2005
 Posts: 22
 
PostPosted: Tue Jun 12, 2007 11:29 am    Post subject:
 
Thanks very much for your attempt anyway. I hope when PHP6 is out, this would not be a hassle anymore.

I have been having trouble access jupiter server as all my domains do not seem to be resolving.

jupiter.solardns.com is down too (from my end anyway)

Tim
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5684
 
PostPosted: Tue Jun 12, 2007 11:51 am    Post subject:
 
Tim,

I have taken a look but can't find any issues with Jupiter? I can access sites via it and I can verify the domain is resolving via third parties.

Not sure what the problem is but it does seem local?

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Post new topic   Reply to topic    NetHosted Community Index -> General Support
Goto page 1, 2  Next
Page 1 of 2

User Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

 
Jump to: