PDA

View Full Version : I can't update mysql



jirawat
08-22-2008, 10:39 PM
I've try to update mysql 5.0.41 to 5.0.67 but I've got error as below.
At http://files.directadmin.com/services/all/mysql/64-bit/ I can't find MySQL-client-5.0.67-0.glibc23.x86_64.rpm, correct file is MySQL-client-community-5.0.67-0.rhel5.x86_64.rpm
How can I solve this problem?



--11:12:04-- http://files.directadmin.com/services/all/mysql/64-bit/MySQL-client-5.0.67-0.glibc23.x86_64.rpm
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
11:12:05 ERROR 404: Not Found.

--11:12:05-- http://files.directadmin.com/services/all/mysql/64-bit/MySQL-devel-5.0.67-0.glibc23.x86_64.rpm
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
11:12:05 ERROR 404: Not Found.

--11:12:05-- http://files.directadmin.com/services/all/mysql/64-bit/MySQL-server-5.0.67-0.glibc23.x86_64.rpm
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
11:12:06 ERROR 404: Not Found.

--11:12:06-- http://files.directadmin.com/services/all/mysql/64-bit/MySQL-shared-5.0.67-0.glibc23.x86_64.rpm
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
11:12:07 ERROR 404: Not Found.

*** Cannot find /usr/local/directadmin/custombuild/mysql/MySQL-client-5.0.67-0.glibc23.x86_64.rpm. Aborting ***

DirectAdmin Support
08-23-2008, 11:34 AM
Hello,

I've added the missing rpms, give that a try now.

John

jirawat
08-23-2008, 06:39 PM
It's work now, Thank you very much. :)

Jirawat

miantiao
04-08-2009, 12:04 AM
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
13:04:05 ERROR 404: Not Found.



--13:04:04-- http://files.directadmin.com/services/custombuild//usr/local/directadmin/custombuild/options.conf
=> `./custombuild.tar.gz'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
13:04:05 ERROR 404: Not Found.

--13:04:05-- http://is/
=> `./custombuild.tar.gz'
Resolving is... 38.97.225.166
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

--13:07:15-- http://is/
(try: 2) => `./custombuild.tar.gz'
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

--13:10:26-- http://is/
(try: 3) => `./custombuild.tar.gz'
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

--13:13:38-- http://is/
(try: 4) => `./custombuild.tar.gz'
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

--13:16:51-- http://is/
(try: 5) => `./custombuild.tar.gz'
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

--13:20:05-- http://is/
(try: 6) => `./custombuild.tar.gz'
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

DirectAdmin Support
04-08-2009, 12:08 AM
Hello,

Can you include your OS version, 32-bit or 64-bit, the full contents of your options.conf and what exactly you typed from the command line? Paste the entire output please.

John

miantiao
04-08-2009, 12:18 AM
centos 4.6 32-bit

DirectAdmin Installation


************************************************************************
*
* Found /root/.custombuild. Using custombuild 1.1 instead of customapache
*
************************************************************************

Related pages:
http://www.directadmin.com/forum/forumdisplay.php?f=61
http://files.directadmin.com/services/custombuild/1.1/

--13:04:00-- http://files.directadmin.com/services/custombuild/1.1/custombuild.tar.gz
=> `custombuild.tar.gz'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 85,253 (83K) [application/x-gzip]

100%[========================================================================================>] 85,253 57.34K/s

13:04:03 (57.18 KB/s) - `custombuild.tar.gz' saved [85253/85253]

--13:04:04-- http://files.directadmin.com/services/custombuild//usr/local/directadmin/custombuild/options.conf
=> `./custombuild.tar.gz'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
13:04:05 ERROR 404: Not Found.

--13:04:05-- http://is/
=> `./custombuild.tar.gz'
Resolving is... 38.97.225.166
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

--13:07:15-- http://is/
(try: 2) => `./custombuild.tar.gz'
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

--13:10:26-- http://is/
(try: 3) => `./custombuild.tar.gz'
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

DirectAdmin Support
04-08-2009, 12:26 AM
Hello,

Try:
cd /usr/local/directadmin/custombuild
./build update
./build all dand check to see if it does it again.

John

miantiao
04-08-2009, 01:30 AM
cd /usr/local/directadmin/custombuild
./build update
./build all d

end
# All parts have been installed

Run the setup script!

# ./setup.sh



************************************************************************
*
* Found /root/.custombuild. Using custombuild 1.1 instead of customapache
*
************************************************************************

Related pages:
http://www.directadmin.com/forum/forumdisplay.php?f=61
http://files.directadmin.com/services/custombuild/1.1/

--15:21:29-- http://files.directadmin.com/services/custombuild/1.1/custombuild.tar.gz
=> `custombuild.tar.gz'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 85,253 (83K) [application/x-gzip]

100%[========================================================================================>] 85,253 57.38K/s

15:21:31 (57.22 KB/s) - `custombuild.tar.gz' saved [85253/85253]

--15:21:33-- http://files.directadmin.com/services/custombuild//usr/local/directadmin/custombuild/options.conf
=> `./custombuild.tar.gz'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
15:21:34 ERROR 404: Not Found.

--15:21:34-- http://is/
=> `./custombuild.tar.gz'
Resolving is... 38.97.225.166
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

--15:24:45-- http://is/
(try: 2) => `./custombuild.tar.gz'
Connecting to is|38.97.225.166|:80... failed: Connection timed out.
Retrying.

--15:27:56-- http://is/
(try: 3) => `./custombuild.tar.gz'
Connecting to is|38.97.225.166|:80...


http://files.directadmin.com/services/custombuild//usr/local/directadmin/custombuild/options.conf Not Found

DirectAdmin Support
04-08-2009, 11:59 AM
I've never gotten that errror when I run the setup.sh...

Does the manual "./build update; ./build all d" work for you?

I've changed the code around slightly on the assumption that maybe wget wants the -O as the first option instead of the 2nd option.
I've also added an echo commands just before the custombuild.tar.gz extraction to tell us where it calls in relation to that error, as well as what value the CUSTOMBUILD_OPT is set to.

I'm not positivie as to the cause of the error quite yet.

John

miantiao
04-08-2009, 09:11 PM
./build all d



Done iconv.
Dumping database mysql
Found /usr/local/directadmin/custombuild/mysql/MySQL-client-5.0.77-0.i386.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-devel-5.0.77-0.i386.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-server-5.0.77-0.i386.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-shared-5.0.77-0.i386.rpm
Stopping mysqld ...
Shutting down MySQL..............................................................................................................................................................................................................................................................................................................................................................................................................................................................


I can't setup ... :confused:



[root@sh15 ~]# ./setup.sh


*** DirectAdmin already exists ***
Press Ctrl-C within the next 10 seconds to cancel the install
Else, wait, and the install will continue, but will destroy existing data


Please enter your Client ID : *****
Please enter your License ID : *****
Please enter your hostname \(server.domain.com\)
It must be a Fully Qualified Domain Name
Do *not* use a domain you plan on using for the hostname:
eg. don't use domain.com. Use server.domain.com instead.
Do not enter http:// or www

Enter your hostname (FQDN) : sh13.wuhanm.com
Client ID: 7353
License ID: 43674
Hostname: sh13.wuhanm.com
Is this correct? (y,n) : y
Is eth0 your network adaptor with the license IP? (y,n) : y
Is 114.80.67.15 the IP in your license? (y,n) : y

DirectAdmin will now be installed on: Enterprise 4.6
Is this correct? (must match license) (y,n) : y

You now have 2 options for your apache/php setup.

1: customapache: older software. Includes Apache 1.3, php 4 and frontpage.
2: custombuild 1.1: newer software (recommended). Includes any Apache version, php 4, 5, or both in cli and/or suphp. Frontpage not available.
Post any issues with custombuild to the forum: http://www.directadmin.com/forum/forumdisplay.php?f=61

Enter your choice (1 or 2): 2
You have chosen custombuild 1.1.

Would you like the default settings of apache 2.2 and php 5 cli? (y/n): n
You have chosen to customize the custombuild options. Please wait while options configurator is downloaded...

--10:47:30-- http://files.directadmin.com/services/custombuild/options-1.1
=> `/usr/local/directadmin/custombuild/options'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 11,385 (11K) [text/plain]

100%[====================================>] 11,385 19.17K/s

10:47:32 (19.12 KB/s) - `/usr/local/directadmin/custombuild/options' saved [11385/11385]

Do you want to have PHP4 or PHP5 as default? (4/5): 5
Do you want to have PHP5? (yes/no): yes
Do you want to have PHP5 as CLI or CGI? (cli/cgi): cli
Do you want to have PHP4? (yes/no): no
Do you want to have the php.ini (PHP configuration file) rewritten? (yes/no): yes
For the next question, the usual file is the dist (distribution) version.What type of php.ini (PHP configuration file) do you want to have? (dist/recommended): dist
Do you want to have Zend Optimizer? (yes/no): yes
Do you want to be able to update/instal MySQL using CustomBuild? (yes/no): yes
Which version of MySQL do you want to have? (4.1/5.0: 5.0
Do you want CustomBuild to backup MySQL databases before the update? (yes/no): yes
Which version of Apache do you want to have? (1.3/2.0/2.2): 2.2
Do you want to be able to install/update phpMyAdmin using CustomBuild? (yes/no): yes
Do you want to be able to install/update Atmail webmail using CustomBuild? (yes/no): yes
Do you want to be able to install/update SquirrelMail webmail using CustomBuild? (yes/no): yes
Do you want to be able to install/update RoundCube webmail using CustomBuild? (yes/no): yes
Do you want to be able to install/update UebiMiau webmail using CustomBuild? (yes/no): yes
Do you want to install PHP mail() header patch together with PHP? (yes/no): yes
Do you want to install Dovecot? (yes/no): yes
Do you want to be able to update Exim configuration file (exim.conf) using CustomBuild? (yes/no): yes
Do you want to be able to install/update ProFTPD using CustomBuild? (yes/no): yes
Do you want CustomBuild to install Jailed shell (beta)? (yes/no): no
Do you want CustomBuild to download versions.txt every time? (yes/no): yes
Do you want to enable bolded text? (yes/no): yes
Do you want to clean everything (run './build clean' every time) running CustomBuild? (yes/no): yes
Which fileserver do you want to use (1 is located in USA, 2 - Europe)? (1/2): 1
Options.conf has been installed successfully
beginning pre-checks, please wait...
--10:48:11-- http://files.directadmin.com/services/4.6/files.sh
=> `/usr/local/directadmin/scripts/files.sh'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1,064 (1.0K) [application/x-sh]

100%[========================================================================================>] 1,064 --.--K/s

10:48:13 (72.48 MB/s) - `/usr/local/directadmin/scripts/files.sh' saved [1064/1064]

adding gd ...
--10:48:13-- http://files.directadmin.com/services/4.6/gd-2.0.28-4.i386.rpm
=> `/usr/local/directadmin/scripts/packages/gd-2.0.28-4.i386.rpm'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 121,926 (119K) [application/x-rpm]

100%[========================================================================================>] 121,926 102.12K/s

10:48:15 (101.84 KB/s) - `/usr/local/directadmin/scripts/packages/gd-2.0.28-4.i386.rpm' saved [121926/121926]

Preparing... ########################################### [100%]
1:gd ########################################### [100%]
--10:48:15-- http://www.directadmin.com/named
=> `/etc/init.d/named'
Resolving www.directadmin.com... 66.51.122.131
Connecting to www.directadmin.com|66.51.122.131|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2,472 (2.4K) [text/plain]

100%[========================================================================================>] 2,472 --.--K/s

10:48:16 (2.71 MB/s) - `/etc/init.d/named' saved [2472/2472]

/usr/sbin/setenforce: SELinux is disabled
--10:48:18-- https://www.directadmin.com/cgi-bin/daupdate?uid=7353&lid=43674
=> `/usr/local/directadmin/update.tar.gz'
Resolving www.directadmin.com... 66.51.122.131
Connecting to www.directadmin.com|66.51.122.131|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5,402,893 (5.2M) [application/x-gzip]

100%[========================================================================================>] 5,402,893 277.14K/s ETA 00:00

10:48:39 (264.22 KB/s) - `/usr/local/directadmin/update.tar.gz' saved [5402893/5402893]

All Checks have passed, continuing with install...
Setting hostname to `sh13.wuhanm.com'
mkdir: cannot create directory `/etc/virtual/usage': File exists
Checking quotas...
--10:52:18-- https://www.directadmin.com/cgi-bin/licenseupdate?lid=43674&uid=7353
=> `/usr/local/directadmin/conf/license.key'
Resolving www.directadmin.com... 66.51.122.131
Connecting to www.directadmin.com|66.51.122.131|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [application/octet-stream]

[ <=> ] 1,559 --.--K/s

10:52:20 (135.16 MB/s) - `/usr/local/directadmin/conf/license.key' saved [1559]

Services file already exists. Assuming its been extracted, skipping...

*****************************************************
*****************************************************

It seems as though mysql has already been installed.
The directory /var/lib/mysql has been found. For the best results, its recommended that this be deleted.
All database data will be lost if you delete it

Do you want to delete it? (y is recommended)? (y,n) : y
mv: cannot overwrite directory `/var/lib/mysql.backup/mysql'
warning: /usr/local/directadmin/scripts/packages/MySQL-server-5.0.67-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
Giving mysqld a couple of seconds to exit nicely
1:MySQL-server ########################################### [100%]
090409 10:54:01 [Warning] Asked for 196608 thread stack, but got 126976
090409 10:54:02 [Warning] Asked for 196608 thread stack, but got 126976
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h sh13.wuhanm.com password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting MySQL.[ OK ]
Thank you for installing the MySQL Community Server! For Production
systems, we recommend MySQL Enterprise, which contains enterprise-ready
software, intelligent advisory services, and full production support with
scheduled service packs and more. Visit www.mysql.com/enterprise for more
information.
warning: /usr/local/directadmin/scripts/packages/MySQL-client-5.0.67-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
warning: /usr/local/directadmin/scripts/packages/MySQL-devel-5.0.67-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]
Starting MySQL[ OK ]
Waiting for mysqld to start....
Setting MySQL Root Password...
Setting DirectAdmin user and password...
Updating privilege tables...
Stopping xinetd: [ OK ]
Starting xinetd: [ OK ]
Preparing... ########################################### [100%]
package proftpd-1.3.1-1 is already installed
Preparing... ########################################### [100%]
package proftpd-standalone-1.3.1-1 is already installed
mkdir: cannot create directory `/var/log/proftpd': File exists
Preparing... ########################################### [100%]
1:da_exim ########################################### [100%]
Preparing... ########################################### [100%]
package da_vm-pop3d-1.1.7f-2 is already installed
make: `wrapper' is up to date.
Testing for perl (/usr/bin/perl)...
Configuring scripts...
./install.sh -m 751 -O 103 -g 2 . /etc/virtual/majordomo
./install.sh -m 755 -O 103 -g 2 . /etc/virtual/majordomo/bin
Copying tools to /etc/virtual/majordomo/bin
Copying Majordomo files to /etc/virtual/majordomo
Copying archiving and other tools to /etc/virtual/majordomo/Tools
./install.sh -m 755 -O 103 -g 2 . /etc/virtual/majordomo/Tools
Using installed majordomo.cf
Installing manual pages in /etc/virtual/majordomo/man

To finish the installation, 'su' to root and type:

make install-wrapper

If not installing the wrapper, type

cd /etc/virtual/majordomo; ./wrapper config-test

(no 'su' necessary) to verify the installation.
./install.sh -o root -g 2 \
-m 4755 wrapper /etc/virtual/majordomo/wrapper

To verify that all the permissions and etc are correct,
run the command

cd /etc/virtual/majordomo; ./wrapper config-test
Starting DA-PopB4Smtp:
Stopping xinetd: [ OK ]
Starting xinetd: [ OK ]
************************************************************************
*
* Found /root/.custombuild. Using custombuild 1.1 instead of customapache
*
************************************************************************

Related pages:
http://www.directadmin.com/forum/forumdisplay.php?f=61
http://files.directadmin.com/services/custombuild/1.1/

--10:54:25-- http://files.directadmin.com/services/custombuild/1.1/custombuild.tar.gz
=> `custombuild.tar.gz'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 85,267 (83K) [application/x-gzip]

100%[========================================================================================>] 85,267 71.54K/s

10:54:28 (71.34 KB/s) - `custombuild.tar.gz' saved [85267/85267]

--10:54:29-- http://files.directadmin.com/services/custombuild//usr/local/directadmin/custombuild/options.conf
=> `./custombuild.tar.gz'
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
10:54:30 ERROR 404: Not Found.

--10:54:30-- http://is/
=> `./custombuild.tar.gz'
Resolving is... 38.97.225.166
Connecting to is|38.97.225.166|:80...

daveyw
04-09-2009, 05:22 AM
I'm having also problems with upgrading MySQL from 4.x to 5.0.77. You can find my thread here (http://www.directadmin.com/forum/showthread.php?t=30381)

smtalk
05-09-2009, 04:28 PM
The problem has been fixed, it was caused by the options file (http://files.directadmin.com/services/custombuild/options) and was appearing only at the installation time.