PDA

View Full Version : How should I be running this script?



blackhawkit
11-05-2007, 02:26 AM
Maybe its just me but the how to I found in the services directory for the beta custombuild script didn't seem very helpful. Assuming I have everything set in the options.conf file, what command do I run? ./build all? ./build update? ./build update_all? I tried this once already and it pretty much broke my server...so I obviously need to try this again.

--edit--

The old scripts won't fix it either. I get a syntax error on an Order allow,deny statement in the apache conf...Isn't there a command to have DA rewrite the config files?

-Morgan

smtalk
11-05-2007, 04:40 AM
Do get all the data you need to do this:


./build update_data
Or:

./build update

To build everything, you need to use:
./build all

To rewrite the configuration files:


./build rewrite_confs


Don't forget to restart the apache service after "./build rewrite_confs".

blackhawkit
11-05-2007, 04:24 PM
I now get



*************************************
* *
* All parts have been installed *
* *
*************************************

Type: /sbin/service httpd restart
[root@norad custombuild]# service httpd restart
Stopping httpd: [FAILED]
Starting httpd: httpd: Syntax error on line 20 of /etc/httpd/conf/httpd.conf: Cannot load /usr/lib/apache/libperl.so into server: /usr/lib/apache/libperl.so: undefined symbol: ap_null_cleanup

[root@norad custombuild]#


Line 20 is LoadModule perl_module /usr/lib/apache/libperl.so

I also get:



071105 15:48:43 [Warning] Asked for 196608 thread stack, but got 126976
ERROR: 1136 Column count doesn't match value count at row 1
071105 15:48:43 [ERROR] Aborting

071105 15:48:43 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
and use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Starting MySQL.................................................................................................../etc/init.d/mysql: line 159: kill: (2629) - No such process
[FAILED]
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.
Starting MySQL................................... [FAILED]
This script updates all the mysql privilege tables to be usable by
the current version of MySQL

Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=da_admin --host=localhost --database=mysql
Please check the above output and try again.

Running the script with the --verbose option may give you some information
of what went wrong.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option


Everything is dead =[

blackhawkit
11-05-2007, 09:23 PM
Does anyone know how I can get around these errors? I have no clue :confused:

smtalk
11-05-2007, 11:53 PM
Do "./build rewrite_confs", because mod_perl shouldn't be there. You can also run "./build mod_perl", if you want.

blackhawkit
11-06-2007, 02:48 AM
Thanks :) That did seem to get apache up and going. I didn't know I had to run that after everything was said and done. However.. The real issue is the MySQL error, over anything by far. Do you have any recommendations for this?

smtalk
11-06-2007, 01:26 PM
What's your OS? Everything is okay with /usr/local/directadmin/conf/mysql.conf file?

blackhawkit
11-06-2007, 01:41 PM
Well..that file only has


user=da_admin
passwd=****

And the password is displays is the original DA password which I have since changed...is it supposed to be as empty as that?

blackhawkit
11-06-2007, 04:43 PM
Ok someone has GOT to have SOME suggestion?!?!?! MySQL is straight up dead right now...I'll keep trying to get it working but right now I have made 0 progress, and I can't get any work done. I did things as I was supposed to..

blackhawkit
11-06-2007, 04:58 PM
Here is what I get when I try to start mysqld with user mysql, a TON of these:

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

And then when I ran a killall to kill all the proccesses, when I came back to the tab I saw this:

071106 16:52:42 InnoDB: Started; log sequence number 0 43634
071106 16:52:42 [Note] mysqld: ready for connections.
Version: '5.0.45-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

I did some googling and I came across a mysql bug report on the mysql site for 4.1, but I am still poking around.

blackhawkit
11-06-2007, 05:03 PM
I have no idea what I did but it seems to be running now....and now it stops and starts fine. Weird?!?!?!?

--edit--

I did end up having to reset directadmin's mysql password though, but no snags after that so far...

+++
11-20-2007, 07:02 AM
I'm having the same problem. I'm running FreeBSD 6.2 and I did the custombuild with MySQL 5.0. mysqld will not start. I find this in my log:

071120 06:37:40 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
071120 6:37:40 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
071120 6:37:40 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
071120 6:37:40 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
071120 6:37:41 InnoDB: Started; log sequence number 0 0
071120 6:37:41 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
071120 06:37:41 mysqld ended

071120 06:38:00 mysqld started
071120 6:38:01 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
071120 6:38:01 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
071120 6:38:01 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
071120 6:38:01 InnoDB: Started; log sequence number 0 43655
071120 6:38:01 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
071120 06:38:01 mysqld ended

Help?