imoda Posted May 24, 2011 Share Posted May 24, 2011 Hi, I have a server with GoDaddy. I recently updated the PHP via SSH from 5.1 to 5.2, consequently that broke the connection from their control panel to my MySQL databases. We are sorry, the system has encountered an error while processing your request. Home If you continue to receive this error, please contact your system administrator. Your URL: /mysql/domain.do Error details: CommandFailedException: Threw SQLException saving DB user for Domain ID: 32 at c.g.t.f.systems.mysql.LinuxMySqlSubsystem.saveDBUser:458 at c.g.t.w.actions.mysql.ActionMySqlDomain.process:131 at c.g.t.w.actions.AbstractSpringAction.execute:118 .... at c.g.t.w.filters.AuthorizedResourceFilter.doFilter:38 .... at c.g.t.w.filters.RequestPopulationFilter.doFilter:117 .... Cause: SQLException: Table 'mysql.servers' doesn't exist .... at c.g.t.f.systems.mysql.LinuxMySqlSubsystem.saveDBUser:446 at c.g.t.w.actions.mysql.ActionMySqlDomain.process:131 at c.g.t.w.actions.AbstractSpringAction.execute:118 .... at c.g.t.w.filters.AuthorizedResourceFilter.doFilter:38 .... at c.g.t.w.filters.RequestPopulationFilter.doFilter:117 .... I tried contacting support, but they wont help unless I pay them $100/hr. I'm just wondering if anyone else has had this problem or might know how to solve it. I've updated MySQL as well via the Simple Control Panel but that didn't help =\ Quote Link to comment https://forums.phpfreaks.com/topic/237279-phpmysql-connection-on-centos-5-server/ Share on other sites More sharing options...
gizmola Posted May 24, 2011 Share Posted May 24, 2011 Is that some sort of script? Where is that error coming from? Often there are multiple installations of apache/php and the main trick is finding out what you have where. When you did this upgrade how did you do it? Yum? Did you do a rpm -qa? What packages are installed? Quote Link to comment https://forums.phpfreaks.com/topic/237279-phpmysql-connection-on-centos-5-server/#findComment-1219347 Share on other sites More sharing options...
imoda Posted May 24, 2011 Author Share Posted May 24, 2011 That is the error message that kicks back in the GD control panel after creating a DB. Upgraded with yum. rpm -qa: mailcap-2.1.23-1.fc6 audit-libs-1.7.17-3.el5 readline-5.1-3.el5 elfutils-libelf-0.137-3.el5 libsysfs-2.0.0-6 aspell-0.60.3-7.1 gpm-1.20.1-74.1 mingetty-1.07-5.2.2 ftp-0.17-35.el5 vzdummy-jre-fc6-1.0-1.swsoft libselinux-1.33.4-5.5.el5 libuser-0.54.7-2.1.el5_4.1 MAKEDEV-3.23-1.2 tmpwatch-2.9.7-1.1.el5.2 dmraid-events-1.0.0.rc13-63.el5 vixie-cron-4.1-77.el5_4.1 basesystem-8.0-5.1.1.el5.centos chkconfig-1.3.30.2-2.el5 info-4.8-14.el5 gawk-3.1.5-14.el5 libidn-0.6.5-1.1 less-436-2.el5 libgcrypt-1.4.4-5.el5 libusb-0.1.12-5.1 crontabs-1.10-8 slang-2.0.6-4.el5 sharutils-4.6.1-2 telnet-0.17-39.el5 rootfiles-8.1-1.1.1 coreutils-5.97-23.el5_4.2 psmisc-22.2-7 libselinux-python-1.33.4-5.5.el5 net-tools-1.60-81.el5 screen-4.0.3-1.el5_4.1 tcpdump-3.9.4-15.el5 policycoreutils-1.33.12-14.8.el5 jdk-1.5.0_22-fcs tomcat55-5.5.28-1.gdg squirrelmail-1.4.8-5.el5.centos.10 libXdmcp-1.0.1-2.1 perl-libwww-perl-5.805-1.1.1 distcache-1.4.5-14.1 avelsieve-1.9.7-1 perl-Net-IP-1.25-2.fc6 cyrus-sasl-plain-2.1.22-5.el5_4.3 libXau-1.0.1-3.1 webalizer-2.01_10-30.1 tomcat55-webapps-5.5.28-1.gdg python-sqlite-1.1.7-1.2.1 yum-fastestmirror-1.1.16-14.el5.centos.1 nano-1.3.12-1.1 mysql-5.1.52-jason.1 php-ncurses-5.2.16-jason.1 php-devel-5.2.16-jason.1 php-pgsql-5.2.16-jason.1 php-xml-5.2.16-jason.1 turbopanel-tomcat-1.4.9-20110304.0130 turbopanel-firewall-1.4.9-20110304.0130 redhat-logos-4.9.99-11.el5.centos php-pear-1.9.1-1.jason.1 mod_ssl-2.2.17-jason.1 glibc-common-2.5-49.el5_5.7 pam-0.99.6.2-6.el5_5.2 krb5-libs-1.6.1-36.el5_5.6 nss-3.12.8-1.el5.centos glibc-headers-2.5-49.el5_5.7 postgresql-libs-8.1.22-1.el5_5.1 bind-libs-9.3.6-4.P1.el5_5.3 libpng-1.2.10-7.1.el5_5.3 device-mapper-multipath-0.4.7-34.el5_5.6 libxml2-python-2.6.26-2.1.2.8.el5_5.1 samba-client-3.0.33-3.29.el5_5.1 gnupg-1.4.5-14.el5_5.1 perl-Archive-Tar-1.39.1-1.el5_5.2 fipscheck-lib-1.2.0-1.el5 rpm-4.4.2.3-20.el5_5.1 samba-3.0.33-3.29.el5_5.1 postgresql-server-8.1.22-1.el5_5.1 openssh-clients-4.3p2-41.el5_5.1 mkinitrd-5.1.19.6-61.el5_5.2 termcap-5.5-1.20060701.1 mktemp-1.5-23.2.2 libsepol-1.15.2-3.el5 gzip-1.3.5-11.el5.centos.1 groff-1.18.1.1-11.1 iputils-20020927-46.el5 dmidecode-2.10-3.el5 jwhois-3.2.3-8.el5 iptables-1.3.5-5.3.el5_4.1 man-pages-2.39-15.el5_4 cracklib-2.8.9-3.3 audit-libs-python-1.7.17-3.el5 libselinux-utils-1.33.4-5.5.el5 dmraid-1.0.0.rc13-63.el5 quota-3.13-1.2.5.el5 filesystem-2.4.0-3.el5 bash-3.2-24.el5 libstdc++-4.1.2-48.el5 libcap-1.10-26 grep-2.5.1-55.el5 libjpeg-6b-37 vim-common-7.0.109-6.el5 cpio-2.6-23.el5_4.1 file-4.17-15.el5_3.1 elfutils-0.137-3.el5 time-1.7-27.2.2 ncompress-4.2.4-47 libsemanage-1.9.1-4.4.el5 curl-7.15.5-9.el5 usermode-1.88-3.el5.2 vzdev-1.0-7.swsoft lynx-2.8.5-28.1.el5_2.1 lsof-4.78-3 mcstrans-0.2.11-3.el5 finger-server-0.17-32.2.1.1 libxslt-1.1.17-2.el5_2.2 automake-1.9.6-2.3.el5 perl-DBI-1.52-2.el5 zlib-devel-1.2.3-3 perl-Compress-Zlib-1.42-1.fc6 postfix-2.3.3-2.1.el5_2 perl-Digest-HMAC-1.01-15 phpMyAdmin-2.11.9.6-2.gdg ntp-4.2.2p1-9.el5.centos.2.1 mod_jk-1.2.27-1.el5.gdg perl-Net-DNS-0.59-3.el5 perl-Socket6-0.19-3.fc6 xorg-x11-filesystem-7.1-2.fc6 perl-Crypt-SSLeay-0.51-11.el5 libgomp-4.4.0-6.el5 python-iniparse-0.2.3-4.el5 yum-3.2.22-26.el5.centos gpg-pubkey-0d4306ef-45f6bc30 mysqlclient15-5.0.91-1.jason.1 php-snmp-5.2.16-jason.1 php-ldap-5.2.16-jason.1 php-mysql-5.2.16-jason.1 mysql-devel-5.1.52-jason.1 turbopanel-postgresql-1.4.9-20110304.0130 turbopanel-email-1.4.9-20110304.0130 apr-1.3.12-1.jason.1 apr-util-ldap-1.3.9-1.jason.2 mod_python-3.3.1-8.jason.2 kernel-headers-2.6.18-194.26.1.el5 popt-1.10.2.3-20.el5_5.1 openssl-0.9.8e-12.el5_5.7 bzip2-libs-1.0.3-6.el5_5 perl-5.8.8-32.el5_5.2 net-snmp-libs-5.3.2.2-9.el5_5.1 kpartx-0.4.7-34.el5_5.6 libxml2-2.6.26-2.1.2.8.el5_5.1 krb5-devel-1.6.1-36.el5_5.6 libsmbclient-3.0.33-3.29.el5_5.1 perl-suidperl-5.8.8-32.el5_5.2 sudo-1.7.2p1-9.el5_5 openssl-devel-0.9.8e-12.el5_5.7 rpm-libs-4.4.2.3-20.el5_5.1 bind-9.3.6-4.P1.el5_5.3 fipscheck-1.2.0-1.el5 net-snmp-utils-5.3.2.2-9.el5_5.1 dhclient-3.0.5-23.el5_5.2 module-init-tools-3.3-0.pre3.1.60.el5_5.1 centos-release-notes-5.5-0 zlib-1.2.3-3 ncurses-5.5-24.20060715 sqlite-3.3.6-5 diffutils-2.8.1-15.2.3.el5 iproute-2.6.18-11.el5 procps-3.2.7-16.el5 ethtool-6-4.el5 aspell-en-6.0-2.1 talk-0.17-29.2.2 traceroute-2.0.1-5.el5 findutils-4.2.27-6.el5 tar-1.15.1-30.el5 which-2.16-7 wget-1.11.4-2.el5_4.1 xinetd-2.3.14-10.el5 talk-server-0.17-29.2.2 libgcc-4.1.2-48.el5 tcp_wrappers-7.6-40.7.el5 libattr-2.4.32-1.1 cyrus-sasl-lib-2.1.22-5.el5_4.3 keyutils-libs-1.2-1.el5 elfutils-libs-0.137-3.el5 m4-1.4.5-3.el5.1 procmail-3.22-17.1.el5.centos sgpio-1.2.0_10-2.el5 ed-0.2-39.el5_2 mailx-8.1.1-44.2.2 shadow-utils-4.0.17-15.el5 rsyslog-3.22.1-3.el5 passwd-0.73-1 authconfig-5.3.21-6.el5 ntsysv-1.3.30.2-2.el5 mlocate-0.15-1.el5.2 cyrus-sasl-2.1.22-5.el5_4.3 portmap-4.0-65.2.2.1 unixODBC-2.2.11-7.1 autoconf-2.59-12 keyutils-libs-devel-1.2-1.el5 libselinux-devel-1.33.4-5.5.el5 cyrus-imapd-perl-2.3.7-7.el5_4.3 cyrus-imapd-utils-2.3.7-7.el5_4.3 perl-Digest-SHA1-2.11-1.2.1 perl-Net-SSLeay-1.30-4.fc6 perl-HTML-Tagset-3.10-2.1.1 pkgconfig-0.21-2.el5 perl-IO-Socket-INET6-2.51-2.fc6 perl-BSD-Resource-1.28-1.fc6.1 libX11-1.0.3-11.el5 fontconfig-2.4.1-7.el5 createrepo-0.4.11-3.el5 cpp-4.1.2-48.el5 gcc-4.1.2-48.el5 m2crypto-0.16-6.el5.6 gd-vz-java-profile-1.0.0-2 php-common-5.2.16-jason.1 php-cli-5.2.16-jason.1 mysql-bench-5.1.52-jason.1 php-xmlrpc-5.2.16-jason.1 php-mbstring-5.2.16-jason.1 php-imap-5.2.16-jason.1 turbopanel-dns-1.4.9-20110304.0130 turbopanel-ftp-1.4.9-20110304.0130 apr-util-1.3.9-1.jason.2 httpd-2.2.17-jason.1 imap-passwd-1.0.1-3.el5.gdg nash-5.1.19.6-61.el5_5.2 device-mapper-1.02.39-1.el5_5.2 openldap-2.3.43-12.el5_5.3 db4-4.3.29-10.el5_5.2 logrotate-3.7.4-9.el5_5.2 e2fsprogs-1.39-23.el5_5.1 expat-1.95.8-8.3.el5_5.3 libtiff-3.8.2-7.el5_5.5 device-mapper-event-1.02.39-1.el5_5.2 samba-common-3.0.33-3.29.el5_5.1 db4-utils-4.3.29-10.el5_5.2 tcsh-6.14-17.el5_5.2 glibc-devel-2.5-49.el5_5.7 dbus-libs-1.1.2-14.el5 net-snmp-5.3.2.2-9.el5_5.1 dbus-1.1.2-14.el5 rpm-python-4.4.2.3-20.el5_5.1 vsftpd-2.0.5-16.el5_5.1 yum-allowdowngrade-1.1.16-14.el5.centos.1 setup-2.5.58-7.el5 libtermcap-2.0.8-46.1 libacl-2.2.39-6.el5 libgpg-error-1.4-2 binutils-2.17.50.0.6-14.el5 cracklib-dicts-2.8.9-3.3 make-3.81-3.el5 finger-0.17-32.2.1.1 newt-0.52.2-15.el5 SysVinit-2.86-15.el5 util-linux-2.13-0.52.el5_4.1 setuptool-1.19.2-1.el5.centos stunnel-4.15-2.el5.1 vim-enhanced-7.0.109-6.el5 man-1.6d-1.1 sed-4.1.5-5.fc6 glib2-2.12.3-4.el5_3.1 gdbm-1.8.0-26.2.1 hesiod-3.1.0-8 perl-Convert-ASN1-0.20-1.1 hmaccalc-0.9.6-3.el5 centos-release-5-5.el5.centos lm_sensors-2.10.7-9.el5 rsync-2.6.8-3.1 unzip-5.52-3.el5 vzdummy-kernel-el5-2.0-1.ce.swsoft libutempter-1.1.4-4.el5 vim-minimal-7.0.109-6.el5 vzdummy-glibc-1.0-1.swsoft gmp-4.1.4-10.el5 libc-client-2004g-2.2.1 imake-1.0.2-3 perl-DBD-MySQL-3.0007-2.el5 libsepol-devel-1.15.2-3.el5 jdk-wrapper-1.5.0_22-1.gdg perl-IO-Zlib-1.04-4.2.1 perl-URI-1.35-3 tomcat55-admin-5.5.28-1.gdg perl-IO-Socket-SSL-1.01-1.fc6 perl-HTML-Parser-3.55-1.fc6 phpPgAdmin-4.2.2-1.gdg cyrus-imapd-2.3.7-7.el5_4.3 mailman-2.1.9-4.el5 yum-metadata-parser-1.1.2-3.el5.centos spamassassin-3.2.5-1.el5 libXpm-3.5.5-3 gd-2.0.33-9.4.el5_4.2 python-elementtree-1.2.6-5 python-urlgrabber-3.1.0-5.el5 gpg-pubkey-e8562897-459f07a4 php-pdo-5.2.16-jason.1 php-5.2.16-jason.1 php-odbc-5.2.16-jason.1 mysql-server-5.1.52-jason.1 php-gd-5.2.16-jason.1 turbopanel-base-1.4.9-20110304.0130 turbopanel-mysql-1.4.9-20110304.0130 turbopanel-1.4.9-20110304.0130 pcre-8.02-1.jason.1 mod_perl-2.0.4-7.jason.2 tzdata-2010l-1.el5 glibc-2.5-49.el5_5.7 e2fsprogs-libs-1.39-23.el5_5.1 nspr-4.8.6-1.el5_5 e2fsprogs-devel-1.39-23.el5_5.1 python-2.4.3-27.el5_5.3 udev-095-14.21.el5_5.1 gnutls-1.4.1-3.el5_4.8 cups-libs-1.3.7-18.el5_5.8 lvm2-2.02.56-8.el5_5.6 freetype-2.2.1-28.el5_5.1 bzip2-1.0.3-6.el5_5 nscd-2.5-49.el5_5.7 initscripts-8.45.30-3.el5.centos openssh-4.3p2-41.el5_5.1 postgresql-8.1.22-1.el5_5.1 samba-swat-3.0.33-3.29.el5_5.1 openssh-server-4.3p2-41.el5_5.1 caching-nameserver-9.3.6-4.P1.el5_5.3 Quote Link to comment https://forums.phpfreaks.com/topic/237279-phpmysql-connection-on-centos-5-server/#findComment-1219637 Share on other sites More sharing options...
gizmola Posted May 24, 2011 Share Posted May 24, 2011 I looked at the error again and I think i see the problem: Cause: SQLException: Table 'mysql.servers' doesn't exist So apparently the morons at godaddy make a table named servers in the mysql database. The mysql database is mysql's original data dictionary database and is intended solely for the use of mysql. When you upgraded it wiped the contents of the mysql database and recreated it, and their "servers" table got deleted. This is probably something that gets created when the turbopanel crap is installed on a server, so you might be able to figure out where that script exists and run it again manually. I don't recommend things like this on your production server without a backup or a really good understanding of what they have. One thing you can do on an individual package to see what its contents are is to run: rpm -qil package You will get this type of information: [david@penny ~]$ rpm -qil pcre Name : pcre Relocations: /usr Version : 6.6 Vendor: CentOS Release : 2.el5_1.7 Build Date: Thu Nov 29 21:10:29 2007 Install Date: Mon Mar 28 12:10:15 2011 Build Host: builder6 Group : System Environment/Libraries Source RPM: pcre-6.6-2.el5_1.7.src.rpm Size : 223885 License: BSD Signature : DSA/SHA1, Sat Dec 1 17:10:37 2007, Key ID a8a447dce8562897 URL : http://www.pcre.org/ Summary : Perl-compatible regular expression library Description : Perl-compatible regular expression library. PCRE has its own native API, but a set of "wrapper" functions that are based on the POSIX API are also supplied in the library libpcreposix. Note that this just provides a POSIX calling interface to PCRE: the regular expressions themselves still follow Perl syntax and semantics. The header file for the POSIX-style functions is called pcreposix.h. /lib/libpcre.so.0 /lib/libpcre.so.0.0.1 /usr/bin/pcregrep /usr/bin/pcretest /usr/lib/libpcrecpp.so.0 /usr/lib/libpcrecpp.so.0.0.0 /usr/lib/libpcreposix.so.0 /usr/lib/libpcreposix.so.0.0.0 /usr/share/doc/pcre-6.6 /usr/share/doc/pcre-6.6/AUTHORS /usr/share/doc/pcre-6.6/LICENCE /usr/share/man/man1/pcregrep.1.gz /usr/share/man/man1/pcretest.1.gz To find the package a particular file on the fs belongs to you can do this: [david@penny ~]$ rpm -qif /usr/bin/pcregrep Name : pcre Relocations: /usr Version : 6.6 Vendor: CentOS Release : 2.el5_1.7 Build Date: Thu Nov 29 21:11:05 2007 Install Date: Mon May 12 17:51:10 2008 Build Host: builder6 Group : System Environment/Libraries Source RPM: pcre-6.6-2.el5_1.7.src.rpm Size : 232621 License: BSD Signature : DSA/SHA1, Sat Dec 1 17:10:37 2007, Key ID a8a447dce8562897 URL : http://www.pcre.org/ Summary : Perl-compatible regular expression library Description : Perl-compatible regular expression library. PCRE has its own native API, but a set of "wrapper" functions that are based on the POSIX API are also supplied in the library libpcreposix. Note that this just provides a POSIX calling interface to PCRE: the regular expressions themselves still follow Perl syntax and semantics. The header file for the POSIX-style functions is called pcreposix.h. I would suggest going back to the forums with the specific information and question I provided and ask them how you can just reinstall the tables they add to the database. Of course the best answer is that you should have had a mysql backup (maybe you do) before you started messing with any of this, and if so you could just find the backup portion of that table and reload that table. Here's the tables that come with mysql in its mysql database in version 5.0x to give you an idea: Database changed mysql> show tables; +---------------------------+ | Tables_in_mysql | +---------------------------+ | columns_priv | | db | | func | | help_category | | help_keyword | | help_relation | | help_topic | | host | | proc | | procs_priv | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +---------------------------+ 17 rows in set (0.00 sec) If you have problems with godaddy, a little righteous indignation as to why they would install tables into the mysql data dictionary might not hurt your cause. Quote Link to comment https://forums.phpfreaks.com/topic/237279-phpmysql-connection-on-centos-5-server/#findComment-1219723 Share on other sites More sharing options...
johndavis03 Posted November 29, 2011 Share Posted November 29, 2011 Please login to mysql database as root and add the table 'servers' to it.. it will fix use the below dump CREATE TABLE IF NOT EXISTS `servers` ( `Server_name` char(64) NOT NULL, `Host` char(64) NOT NULL, `Db` char(64) NOT NULL, `Username` char(64) NOT NULL, `Password` char(64) NOT NULL, `Port` int(4) DEFAULT NULL, `Socket` char(64) DEFAULT NULL, `Wrapper` char(64) NOT NULL, `Owner` char(64) NOT NULL, PRIMARY KEY (`Server_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table'; Quote Link to comment https://forums.phpfreaks.com/topic/237279-phpmysql-connection-on-centos-5-server/#findComment-1292104 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.