StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POProblems with php-cli and mysql, why is mysql_pconnect() not available?
primarykey
Id
729070
data
AcceptedAnswerId
729109
AnswerCount
3
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2009-04-08T08:41:09.143
FavoriteCount
0
LastActivityDate
2013-06-24T19:18:27.707
LastEditDate
2009-04-08T09:05:22.127
LastEditorUserId
2172
OwnerUserId
2172
ParentId
0
PostTypeId
1
Score
1
ViewCount
4800
LastEditorDisplayName
text
Body
I've installed various PHP packages to be able to use PHP with Apache but also in the commandline. From both I need to be able to connect to MySQL databases. Pretty simple right? That's what I thought but with php-cli I receive following error: <pre><code>Fatal error: Call to undefined function mysql_pconnect() </code></pre> I have tried starting from scratch by removing all depending packages and configuration like this: <pre><code>sudo apt-get --purge remove php5 libapache2-mod-php5 php5-cli php5-mysql </code></pre> Then I've run following command to install the packages: <pre><code>sudo apt-get install php5 libapache2-mod-php5 php5-cli php5-mysql </code></pre> Then I've found out which php.ini the cli uses like that: <pre><code>php -r "phpinfo();" | grep php.ini </code></pre> Which gives me this: <pre><code>Configuration File (php.ini) Path => /etc/php5/cli/php.ini </code></pre> Then i've uncommented 'mysql.so' in the extensions section but when i do and run following command it says: <pre><code>PHP Warning: Module 'mysql' already loaded in Unknown on line 0 </code></pre> So for some reason he thinks it is already loaded, but with or without the 'mysql.so' enabled the php cli does not find the 'mysql_pconnect' function. I know there's a sections to enable persistent connections, it on by default and the standard function 'mysql_connect' is also not available. What am I missing? Thanks! UPDATE: As suggested by Bart S. 'php -r "phpinfo();" | grep mysql': <blockquote> <pre><code>MYSQL_SOCKET => /var/run/mysqld/mysqld.sock MYSQL_INCLUDE => -I/usr/include/mysql MYSQL_LIBS => -L/usr/lib -lmysqlclient mysql.allow_persistent => On => On ... and more </code></pre> </blockquote> From Jaka Jančar. 'php -v' shows: <blockquote> PHP 5.1.2 (cli) (built: Feb 11 2009 19:55:22) </blockquote> And from php interactive mode 'php -r 'var_dump(extension_loaded("mysql"));' gives nothing!
Tags
<php>
Title
Problems with php-cli and mysql, why is mysql_pconnect() not available?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USSander Versluys
UserOwnerUserId
1. USSander Versluys
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POProblems with php-cli and mysql, why is mysql_pconnect() not available?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.