MySql Not Working With PHP5
Apr 21, 2009I have installed PHP5 in my windows server (IIS6).But when I check with phpinfo() its not showing mysql extension or any details.
I have enabled the mysql extension in php.ini
I have installed PHP5 in my windows server (IIS6).But when I check with phpinfo() its not showing mysql extension or any details.
I have enabled the mysql extension in php.ini
I have suPHP installed in FastCGI mode. PHP5 is my default installation but I have it setup so that PHP4 can also run. At least that is my intention.
I have PHP5 working without a problem.
PHP4 is loading if I add the directinf x-httpd-php4 .php into my .htaccess file.
HOWEVER: PHP (via phpinfo) is trying to load the config file from /usr/local/etc/php5/cgi/php.ini when it should be from ....php4/cgi/php.ini
Where do I go to fix this? Or is there a second directive that I need to load in the .htaccess file?
Also... In either php5 or php4, if I put a php.ini file into a directory, it is suppose to load that one. However, it is not doing this either.
Is this possible? It seems that yum wants to also upgrade to mysql 5 if I want to upgrade php to 5. I'm having a hard time finding any info about it online.
View 4 Replies View RelatedI have a VPS.
I have installed "Lighttpd, php5cgi, mysql-server, mysql-client,
libmysqlclient15-dev"
I have optimized the MySQL Server (/etc/mysql/my.cnf).
All these together just take 30 mb Memory.
Lighttpd use just 12mb memory And everything is very good.
But,
When I install php5 mod MySQL:
apt-get install php5-mysql
Then the Lighttpd memory increases to 90mb!
I am using updated Debian Lenny, MySQL5, php5.
While trying to compile PHP 5 with mysql and mysqli , I was facing some issues.
Actually, the configure command generates a bad Makefile.
Open the Makefile and look for a line staring with EXTRA_LIBS
You will see that the option “-lmysqlclient” is repeated twice. Delete one of them and save the Makefile.
Now, you should be able to run the Make command and compile PHP without any issues.
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
any hosts that can provide the following:
PHP5.3 +
MySQL
CRON (to run daily/weekly scripts at a certain time)
Mass Email. The scripts will send emails to a number of users(between 10-100 at first, but may grow) and this will be done daily and weekly.
In the past, I've tended to go with SupaNames or FastHosts but looking at their solutions for this, it's not quite right for my requirements.
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each.
Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem.
Also on the server we have Fantastico.
I've enabled one more php using this guide: [URL] .... but mysql is not working with the new php installation, how to get it working?
View 7 Replies View RelatedThis is on a CentOS 7.1, Plesk 12. New.
On Plesk 10.4 I had a script that backed up my MySQL databases separately. The script doesn't work now. I get an error:
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)​
Do I need to do something different with this new "MariaDB" thing?
Here's the script:
DB_BACKUP="/pat/to/databackup/`date +%Y-%m-%d`"
DB_USER="admin"
DB_PASSWD="-p`cat /etc/psa/.psa.shadow`"
HN=`hostname | awk -F. '{print $1}'`
[Code] ....
I have a domain with a few forwarding email accounts that forward to mac.com email accounts... for some reason every once in a while these accounts stop working...
This is the error I get when I email to that account:
This message was created automatically by mail delivery software.
A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed: ...
I have just installed PHP5 into my IIS server and want to install projectpier
1st problem: When I go to [url]I get the errorThis Virtual Directory does not allow contents to be listed.
There is an index.php in there but doesn't load even though I have specified it as a default content page in the website..
2nd problem: After I manually browse to the install page I get the following errors:
#Error: /config/config.php is not writable
# Error: /public/files is not writable
# Error: /cache is not writable
# Error: /upload is not writable
I have realised that permissions are not setup right so I went and gave cart blanche access to the folder for any user..it worked but is far from secure.What is the best way to do this?
When installing web applications like this are they usually done from the servers browser where the server is the only one with full access.I tried this and it didn't work.
Running ubuntu server 6 if I apt-get php5 the version I get is 5.1.2.
Now the latest version on the php.net site is 5.2.5.
Does it really make much of a difference if I'm slightly below current? What are your thoughts please?
I know if I go compiling from source php and mysql are difficult to get working together which is why I like the apt-get method.
We have a client which site requires PHP4, not PHP5 to run. Can we run both PHP versions alongside each other? Apparently, their site will only work in PHP4. We are running Plesk 8.3.0 for Linux.
View 8 Replies View RelatedI have PHP 5.2.5 compiled with GD library working on my webserver,
yesterday i wanted to add Curl Support, so i had to recompile php.
I downloaded and installed Curl latest version and tried to recompile PHP :
'./configure'
'--prefix=/usr/local/php'
'--enable-discard-path'
'--disable-force-cgi-redirect'
'--enable-shared'
'--disable-static'
'--disable-debug'
'--disable-rpath'
'--enable-pic'
'--enable-inline-optimization'
'--enable-memory-limit'
'--with-gd'
'--with-png-dir'
'--with-jpeg-dir'
'--with-config-file-path=/etc'
'--with-config-file-scan-dir=/etc/php'
'--with-pear=/usr/share/pear'
'--enable-magic-quotes'
'--enable-debugger'
'--enable-track-vars'
'--with-exec-dir=/usr/bin'
'--with-versioning'
'--with-mod_charset'
'--with-regex=php'
'--enable-track-vars'
'--enable-trans-sid'
'--enable-safe-mode'
'--enable-ctype'
'--enable-ftp'
'--with-gettext=/usr'
'--enable-posix'
'--enable-session'
'--enable-sysvsem'
'--enable-sysvshm'
'--with-openssl=/usr'
'--without-kerberos'
'--with-freetype-dir=/usr'
'--with-zlib=/usr'
'--with-zlib=/usr'
'--with-zlib-dir=/usr'
'--with-zlib-dir'
'--enable-xslt'
'--with-xslt-sablot'
'--with-iconv-dir=/usr/local/lib'
'--with-mysql-sock=/var/lib/mysql/mysql.sock'
'--with-mysql'
'--enable-mbstring=all'
'--enable-fastcgi'
'--enable-discard-path'
'--enable-force-cgi-redirect'
'--with-curl=/usr/local/curl'
I can't get it working, this is the error i get :
..
checking for T1lib support... no
checking whether to enable truetype string function in GD... no
checking whether to enable JIS-mapped Japanese font support in GD... no
checking for fabsf... yes
checking for floorf... yes
If configure fails try --with-jpeg-dir=<DIR>
checking for png_write_image in -lpng... yes
If configure fails try --with-xpm-dir=<DIR>
If configure fails try --with-freetype-dir=<DIR>
configure: error: GD build test failed. Please check the config.log for
details.
I think i'm not the only one who is experiencing this problem, take a look here:
[url]
Why do PHP.net don't give much importance to this BUG?
I'm using the same OS : Centos 5
I recently installed ubuntu 7.10, and apache2. Both installed with no problems. In my browser i am able to type localhost, and i recieve the "It works" page. I can also start,stop and restart with no problems. However, I cannot install php5. I use synaptic package manager to install, and i added the appropriate lines to the httpd.conf file but i still cannot view .php files. I try to run a simple php page and a dialog box pops up prompting me to open or save the file. If i choose either, the box just pops up again.
View 15 Replies View RelatedI compiled php5 from source, i'm running php5+lighttpd using fastcgi..
i want to uninstall php5 and install php4, i tried this :
[root@srvxx php-5.2.5]# make uninstall
make: *** No rule to make target `uninstall'. Stop.
anyone knows how to uninstall PHP5?
i have a server run with phpsuexec and php4 default,
i want to let certain account run with php5,
it looks likely i can add a php.ini in the account,
I'm trying to keep up with things by developing for PHP5. My current host still uses PHP 4.4.1, which is a pain. Can someone advise me if I should change host to someone who uses PHP5. I would rather have shared hosting due to budget. If so, who should I use? Otherwise, can someone point me in the direction of a resource that describes how to develop for PHP5 while retaining backward compatibility for PHP4.x so I can write code targeted primarily at PHP5, but also works on PHP4.x?
View 6 Replies View RelatedI have a slight problem I can manage most of the features on a VPS server, but I want to upgrade php4 to php5 on the server.
Problem is I have no idea where to start, Im using plesk control panel using WebFusion hosting.
Does anyone have any idea, articles etc. I have had a look online but come up with nothing that simply walks me through what I have to do.
i am getting Internal Server Error while accessing php5 pages.
cat .htaccess
AddHandler application/x-httpd-php5 .php
Premature end of script headers: /usr/local/cpanel/cgi-sys/php5
I've already managed to pick two web hosts for my business that probably won't do the job, so I'm looking for some advice. Primarily we need PHP 5 (with cURL), MySQL 5, easy to implement SSL and some kind of e-mail. I wouldn't imagine using more than 1gb monthly data transfer or needing more than about 20mb of storage.
The database design and all the code was custom written by me and a friend. We are not interested in overly-fluffy GUI's - we like power tools without the finger guards. We'd also like to have good logs of errors, accesses, etc.
Finally, I'm not interested in saving $10 a month to get an overloaded server that goes down now and then. Web host rates are pretty much trivial in comparison with the cost of downtime for this site.
I have installed PHP 5.2.1 (with this guide) working along side PHP 4.4.6, but I am trying to install mailparse into PHP5 and have not had much luck at it.
I think it maybe installing it for PHP 4 and not PHP5 as it seems to be the same date all the time: 20020429 and I believe it should be 2004 or newer from what I have read on Auracle Support Forum.
I have tried:
Code:
/bin/mount /tmp -o remount,exec
pecl install mailparse
pico /usr/local/Zend2/etc/php.ini
Added: extension=mailparse.so to the php.ini of PHP5
service httpd restart
/bin/mount /tmp -o remount,noexec
I have also tried installing from the tar file I wget with the following commands
Code:
cd /home/src/mailparse-2.1.1
/usr/local/php5/bin/phpize5
./configure
make
make install
Then I believe I did
Code:
pico /usr/local/Zend2/etc/php.ini
Changed: extension_dir to /usr/local/php5/lib/php/extensions/
cp /usr/local/lib/php/extensions/no-debug-non-zts-20020429/mailparse.so /usr/local/php5/lib/php/extensions/
But it still does not work
We have a server runing both php4 + php5 and had someone set it up that way when we got the server. but now i cant find who did it for us. And would like to hear how to do it. Im not the best with this kind of stuff and thats why i hire someone to do it lasttime
I been reading on cpanel.net but nothing is up to date!
I'm running cPanel hosting on Centos VPS, apache was last built with PHP 4.4.2. Now I have a client who wants to install mediawiki which requires php5. I don't want to recompile Apache with php5 because I don't know how this could affect my other customers.
Is it possible to run php5 for on a "per account" basis while keeping php4 as the default for the server ?
how do i install php5 on my linux vps centos OS i want to do that installing because right now using php4 and i want to upgrade to php5 and mySql 5 to my vps. i'm on self managed/unmanage server
View 10 Replies View RelatedIs there any difference in performance if you upgrade from php4 to php5? Or can it reduce the average server load?
View 12 Replies View Relatedis mysql5 required for php5? I currently have php4&5 installed with mysql4
If I install mysql5 is it backwards compatible?
Are there any known issues with mysql5 on a server like performance issues? I'm not looking to have scripts recode at this point in time.
I keep seeing instructions on installing using apt-get install php5-gd to install it, but when I do that my server says unknown command....
View 4 Replies View RelatedI have a client who is currently running their own linux machine and has php4 installed (mad I know ) Anyways, I have been asked to make some scripts for them, however I am wanting to use php5 rather than php4 as that is what I am accustomed to not to mention it's still got support for it. Does anyone know of any good online resources on how to upgrade to php5? or better still, how to install php5 and run both 4 and 5 on the same server (using Apache)
View 5 Replies View Related