Server Troubles

[BrandMan211]

I'm currently having trouble with domains hosted on a VPS I co-administrate. All domains are working except a few. I checked the syntax in each BIND records file, and I find no mistake. I check to see if the name servers are set correctly, and I still find no solution. If you want, i can post a records file of each domain name.

Help is greatly appreciated

-BrandMan211

[yager]

It's pretty hard to help with so little detailed information about what isn't working or what trouble you're having. A domain name would be the most helpful; but even a detailed description of what you observe to be incorrect would be a step forward.

[Rick]

wow Yager, you sound exactly like me for the last 5 years ;)

Yes, please post all your bind zone files as well as named.conf

Two useful tools check to check out are "man named-checkconf" + "man named-checkzone"

[yager]

wow Yager, you sound exactly like me for the last 5 years ;)
I don't have nearly your patience, Rick :)

[BrandMan211]

The other admin found the problem somewhere along the line, so don't worry about it.

[Faltzer]

I seem to be having server problems of my own as well. The mySQL RPM install was succesfull for Fedora Core 6, but I start it through Webmin and all it has to say is:


Failed to start database :

sh: /etc/rc.d/init.d/mysqld: No such file or directory


I'm probably the user who most needs help with servers and Linux here.

[Rick]

Hi, everyone has to learn somewhere, don't let it get you down. There all sorts of ways of learning- like books, forums, mailing lists. Our forum definately isn't huge but I'll give you the best advise I can.

So, looks like your mysql init.d script is missing, or named something else.

-Does /etc/init.d/mysql exist?

Try running these commands:

ls /etc/init.d/*sql*
rpm -qa | grep -i mysql | xargs rpm -ql | grep init.d


The second command above is a powerful combination, it will list all of your installed rpms, find any that match "mysql", list all the files in the each of the rpms, and look for files which are supposed to be in the init.d directory.

Let me know what you come back with. More then likely, its just named /etc/init.d/mysql

[Faltzer]

Thanks rick for the encouraging words.


- It seems to be missing from what I gather from my FTP client.
- I ran both commands, it seems that nothing happened when I run the two. Or is it normal? After I ran those commands, I yet found nothing in my /etc/init.d folder.

[Rick]

I logged into your server. You do not have any mysql server rpms installed:

[root@parahosting /]# rpm -qa | grep -i mysql
mysql-5.0.27-1.fc6
perl-DBD-MySQL-3.0007-1.fc6
php-mysql-5.1.6-3.3.fc6

the first is the mysql client package, perl connection library, php connection library. None of these provide you with a mysql server.

So, you need to install the mysql-server package before trying to start up the mysqld service. I used yum to check the repo for the mysql server package:

[root@parahosting /]# yum list | grep -i mysql | grep server
mysql-server.i386 5.0.27-1.fc6 updates-released
[root@parahosting /]#

then, I installed it like this:




[root@parahosting /]# yum -y install mysql-server
Loading "installonlyn" plugin
Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Excluding Packages from Fedora Core 6 - i386 - Released Updates
Finished
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for mysql-server to pack into transaction set.
mysql-server-5.0.27-1.fc6 100% |=========================| 34 kB 00:00
---> Package mysql-server.i386 0:5.0.27-1.fc6 set to be updated
--> Running transaction check

Dependencies Resolved

================================================== ===========================
Package Arch Version Repository Size
================================================== ===========================
Installing:
mysql-server i386 5.0.27-1.fc6 updates-released 10 M

Transaction Summary
================================================== ===========================
Install 1 Package(s)
Update 0 Package(s)
Remove 0 Package(s)

Total download size: 10 M
Downloading Packages:
(1/1): mysql-server-5.0.2 100% |=========================| 10 MB 01:26
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: mysql-server ######################### [1/1]

Installed: mysql-server.i386 0:5.0.27-1.fc6
Complete!
[root@parahosting /]#


After this completed, I can fire up mysqld in your server:

[root@parahosting /]# /etc/init.d/mysqld start
Starting MySQL: [ OK ]
[root@parahosting /]#


And also connect to it using the client:

[root@parahosting /]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.27

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| Hikaridream |
| brandman_mybb |
| brandman_top |
| death_mybb |
| fhq |
| hauntermaster_mybb |
| hosting |
| killfish_mybb |
| mysql |
| narutofrp |
| oogally |
| para |
| pokeuniv_phpbb3 |
| rindiny_pkrf |
| rindiny_pkrindin |
| rindiny_pkrt |
| rindiny_pokeuniv |
| smbz_blog |
| smbzchat |
| tangeloman_mybb |
| test |
+--------------------+
22 rows in set (0.14 sec)

mysql>

[Faltzer]

Eh, I forgot to tell you about that RPM part. I actually used YUM for mySQL installation. Thanks rick! Is it just me, or is my PHP not detecting the mySQL function properly?

[Rick]

seems like it should. a quick test is:

php -i | grep -i mysql


if you see stuff, you have mysql support in your php setup. Next step is to write a simple script that uses mysql_connect() and see what happens when you run it.

[Faltzer]

I could just test with the current forum I have installed as well.



[B]PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php4/mbstring.so' - /usr/lib/php4/mbstring.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php4/mysql.so' - /usr/lib/php4/mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php4/mysqli.so' - /usr/lib/php4/mysqli.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php4/pdo.so' - /usr/lib/php4/pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php4/pdo_mysql.so' - /usr/lib/php4/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php4/pdo_sqlite.so' - /usr/lib/php4/pdo_sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0
Configure Command => './configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--with-mime-magic=/etc/httpd/conf/magic' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--enable-force-cgi-redirect' '--enable-pcntl' '--with-imap=shared' '--with-imap-ssl' '--enable-mbstring=shared' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-ncurses=shared' '--with-gd=shared' '--enable-bcmath=shared' '--enable-dba=shared' '--with-db4=/usr' '--with-xmlrpc=shared' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-mysqli=shared,/usr/bin/mysql_config' '--enable-dom=shared' '--with-dom-xslt=/usr' '--with-dom-exslt=/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--enable-soap=shared' '--with-xsl=shared,/usr' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--enable-fastcgi' '--enable-pdo=shared' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-mysql=shared,/usr' '--with-pdo-pgsql=shared,/usr' '--with-pdo-sqlite=shared,/usr' '--with-readline'
/etc/php.d/mysql.ini,
/etc/php.d/mysqli.ini,
/etc/php.d/pdo_mysql.ini,


Seems like PHP-MySQL isn't installed. I'll use YUM to install.

[Rick]

Ok seems like your php install is a bit fubared. no problem.. run this:

rpm -qa | grep "php-" | xargs rpm -e --nodeps

yum -y install php-*



that should remove your current php rpms and then reinstall all of the FC6 rpms.

[Faltzer]

Existing lock /var/run/yum.pid: another copy is running. Aborting.


That's what happens when I try to run a yum command.

[Faltzer]

Nevermind, I terminated the running process.

[Faltzer]

So the result right now, is that all php pages show up as plain text. I believe this is temporary, correct? php.ini seems to be working fine.

[Faltzer]

PHP's gone back to its old "non-supportive mysql" way. :/

[BrandMan211]

And now I can't update Apache. >_<

httpd: Syntax error on line 191 of /etc/httpd/conf/httpd.conf: Cannot load /etc/httpd/modules/libphp5.so into server: /etc/httpd/modules/libphp5.so: cannot open shared object file: No such file or directory

[Faltzer]

Oh, I found why an error occurs in the PHP modules:


Error: php-pecl-apc conflicts with php-eaccelerator


Ignore BranMan211's above post.

[Rick]

Hi, I would remove all of your php related rpms, clean out your httpd config files for anything that mentions php, and then reinstall php with the yum utility. I wouldnt install eaccellerator or anything like that.