[Solved] Import from Apache

[Razva]

Hi,

This is the first time I'm installing LiteSpeed, so I should be considered as a "totally newbie LS user".

I'm having a CentOS 5.5 VPS, fresh install, with Apache2 + PHP5. When installing the Free version there was no option to import any httpd.conf or migrate anything from Apache.

I've searched the wiki but I didn't found anything at installation/configuration...so I am clearly missing something.

Can you please point me to some tutorial or give a hand?

Cheers!

LATER EDIT: also please take a look at litespeedtech.com/support/forum/showthread.php?t=4641

 

[webizen]

Here are the how-to's that can be helpful:

migrate from apache:
http://www.litespeedtech.com/how-tos.html#qa_mapache

import from apache config:
http://www.litespeedtech.com/how-tos.html#qa_apimport

build php with lsapi:
http://www.litespeedtech.com/how-tos.html#qa_phplsapi

setup php support:
http://www.litespeedtech.com/how-tos.html#qa_php

 

[Razva]

Great, worked like a charm (import and php configuration).

Now...the single problem is..."Fatal error: Call to undefined function mysql_connect()".

Seems that it doesn't connects to the MySQL server?

NOTE: Package mysqlclient15-devel-5.0.91-1.jason.1.x86_64 already installed and latest version

 

[webizen]

You need to build matching php in lsws. The php build coming with lsws doesn't have many extensions (such as mysql, etc) built in.

Here is a guide for php build and its troubleshoot how-to:

http://www.litespeedtech.com/support/wiki/doku.php?id=litespeed_wiki:php:lsapi

http://www.litespeedtech.com/support/wiki/doku.php?id=litespeed_wiki:php:lsapi:troubleshoot

 

[Razva]

I've tried the fix --with-mysql=/usr and --with-mysql=/usr/share

Same result... CentOS 5.5 x64. Any ideas please?

LATER EDIT: worked with "--with-libdir=lib64"

So for you guys who have fresh CentOS 5.5x64...note that

LATER EDIT 2: compiled, but still didn't fixed the "Fatal error: Call to undefined function mysql_connect()" problem.

My time is up. Is there any way to receive paid support? I just need a clean installation and basic setup. Cheers!

 

[webizen]

option "--with-libdir=lib64" was noted in the troubleshooting guide.

 

[eva2000]

might help http://www.litespeedtech.com/support/forum/showthread.php?t=4592

 

[Razva]

Recompiling. Fingers crossed. I have a feeling that I also need to compile adodb.

 

[Razva]

Nope, no luck.

If you are so kind...can you please point me to some "--with-whatever" in order to fix this darn thing? I can't fix the adodb-mysql error...

 

[webizen]

try '--with-mysql=shared,/usr' '--with-pdo-mysql=shared,/usr'

 

[Razva]

Here's the full list I've used:

'--with-adodb' '--with-adodb-mysql' '--with-litespeed' '--with-libdir=lib64' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-pcre=shared,/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--with-kerberos' '--enable-ucd-snmp-hack' '--enable-shmop' '--enable-calendar' '--without-mime-magic' '--without-sqlite' '--with-libxml-dir=/usr' '--enable-xml' '--with-system-tzdata' '--enable-force-cgi-redirect' '--enable-pcntl' '--with-imap=shared' '--with-imap-ssl' '--enable-mbstring=shared' '--enable-mbregex' '--with-ncurses=shared' '--with-gd=shared' '--enable-bcmath=shared' '--enable-dba=shared' '--with-db4=/usr' '--with-xmlrpc=shared' '--with-ldap=shared' '--with-ldap-sasl' '--with-mysql=shared,/usr' '--with-mysqli=shared,/usr/bin/mysql_config' '--enable-dom=shared' '--enable-wddx=shared' '--with-snmp=shared,/usr' '--enable-soap=shared' '--with-xsl=shared,/usr' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--with-curl=shared,/usr' '--enable-pdo=shared' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-mysql=shared,/usr' '--with-pdo-sqlite=shared,/usr' '--with-pdo-dblib=shared,/usr' '--enable-json=shared' '--enable-zip=shared' '--with-readline' '--enable-dbase=shared' '--with-pspell=shared' '--with-mcrypt=shared,/usr' '--with-mhash=shared,/usr' '--with-tidy=shared,/usr' '--with-mssql=shared,/usr' '--enable-sysvmsg=shared' '--enable-sysvshm=shared' '--enable-sysvsem=shared' '--enable-posix=shared' '--with-unixODBC=shared,/usr'

Still...no luck...

 

[webizen]

Have you loaded mysql, pdo and pdo-mysql extensions in php.ini? To find out the path to php.ini in use, do '/usr/local/lsws/fcgi-bin/lsphp5 -i | grep "Loaded Configuration File" ' from command line.

 

[Razva]

I suppose...I didn't?

Loaded Configuration File => (none)

But here's the thing:
Apache: http://www.adventisttv.ro < fully functional with Apache & PHP
LiteSpeed: http://www.adventisttv.ro:7080 < bummer with LiteSpeed

I think I'm missing something here...

 

[mistwang]

install mysql-devel with command
"yum install mysql-devel"

 

[Razva]

[root@adventisttv /]# yum install mysql-devel.x86_64
Package mysql-devel-5.1.52-jason.1.x86_64 already installed and latest version
Nothing to do
[root@adventisttv /]#

Nopez...

 

[mistwang]

"rpm -ql mysql-devel"
to check where those files installed, if it is installed to a special directory, change your PHP configuration parameters to use that location.

 

[Razva]

[root@adventisttv /]# rpm -ql mysql-devel
/usr/include/mysql
/usr/include/mysql/decimal.h
/usr/include/mysql/errmsg.h
/usr/include/mysql/keycache.h
/usr/include/mysql/m_ctype.h
/usr/include/mysql/m_string.h
/usr/include/mysql/my_alloc.h
/usr/include/mysql/my_attribute.h
/usr/include/mysql/my_compiler.h
/usr/include/mysql/my_config.h
/usr/include/mysql/my_config_x86_64.h
/usr/include/mysql/my_dbug.h
/usr/include/mysql/my_dir.h
/usr/include/mysql/my_getopt.h
/usr/include/mysql/my_global.h
/usr/include/mysql/my_list.h
/usr/include/mysql/my_net.h
/usr/include/mysql/my_no_pthread.h
/usr/include/mysql/my_pthread.h
/usr/include/mysql/my_sys.h
/usr/include/mysql/my_xml.h
/usr/include/mysql/mysql.h
/usr/include/mysql/mysql_com.h
/usr/include/mysql/mysql_embed.h
/usr/include/mysql/mysql_time.h
/usr/include/mysql/mysql_version.h
/usr/include/mysql/mysqld_ername.h
/usr/include/mysql/mysqld_error.h
/usr/include/mysql/plugin.h
/usr/include/mysql/sql_common.h
/usr/include/mysql/sql_state.h
/usr/include/mysql/sslopt-case.h
/usr/include/mysql/sslopt-longopts.h
/usr/include/mysql/sslopt-vars.h
/usr/include/mysql/typelib.h
/usr/lib64/mysql/libmysqlclient.so
/usr/lib64/mysql/libmysqlclient_r.so
/usr/share/aclocal/mysql.m4
[root@adventisttv /]#

The php.ini is http://adventisttv.ro/php.ini.txt

Maybe I'm a dumbass, but I can't find anything related with /include/ nor /lib64/

I'm totally lost!

 

[mistwang]

Using "/usr" is correct, you can ignore "include", "lib64". So, you have built your binary correctly, just did not load the shared modules.
Copy over php.ini used by Apache PHP to /usr/local/lsws/lsphp5/lib/, should make it work.

 

[Razva]

Done. Same result...

[root@adventisttv /]# cp /etc/php.ini /usr/local/lsws/lsphp5/lib/

[root@adventisttv php]# locate php.ini
/etc/php.ini
/home/adventisttv/php.ini.txt
/root/lsws-4.0.19/add-ons/directadmin/php.ini
/root/lsws-4.0.19/admin/conf/php.ini
/root/lsws-4.0.19/admin/misc/php.ini
/root/lsws-4.0.19/php/php.ini
/usr/local/lsws/add-ons/directadmin/php.ini
/usr/local/lsws/admin/conf/php.ini
/usr/local/lsws/admin/misc/php.ini
/usr/local/lsws/lsphp5/lib/php.ini
/usr/local/lsws/php/php.ini
/usr/local/lsws/phpbuild/php-5.2.16/php.ini-dist
/usr/local/lsws/phpbuild/php-5.2.16/php.ini-recommended
/usr/local/lsws/phpbuild/php-5.3.5/php.ini-development
/usr/local/lsws/phpbuild/php-5.3.5/php.ini-production

 

[mistwang]

change configuration from '--with-mysql=shared,/usr' to '--with-mysql=/usr', then rebuild PHP.