Wednesday, January 23, 2008

Sharing...

Have you ever tried to set up a share point using the command line?

Why would you do this?

Well, I thought that there must be a way to copy share points after a clean install.

So, how do we find out what is being shared:

Enter this command:
sharing -l

This gives you something like this:

name: Software
path: /Volumes/Backup/Software
afp: {
name: Software
shared: 1
guest access: 0
inherit perms: 1
}
ftp: {
name: Software
shared: 0
guest access: 0
}
smb: {
name: Software
shared: 0
guest access: 0
inherit perms: 0
oplocks: 0
strict locking: 0
directory mask: 493
create mask: 420
}


In order to set up this share point again after a clean install one would have to enter this command:
sharing -a /Volumes/Backup/Software -g 000 -i 10 -s 100

Friday, January 18, 2008

chmod ACL removal

The command to recursively remove all ACLs from the files in the working directory and its subdirectories is:

sudo echo | sudo chmod -R -E ./*

Thursday, January 10, 2008

How to rebuild the LaunchServices database

If your "Open With" menu shows applications that are no longer installed, or shows some of them as duplicates, you can use the following Terminal command to rebuild your LaunchServices database:

/System/Library/Frameworks/ApplicationServices.framework/Frameworks/LaunchServices.framework/Support/lsregister -kill -r -domain local -domain system -domain user

Monday, November 19, 2007

Enable Mail Bundles in Mac OS X 10.5 Leopard

Normally Bundles no longer work after installing Leopard.
I miss Mail.appetizer. To get these working again in Leopard follow these steps:

Quit Mail

Enter these commands in Terminal:

defaults write com.apple.mail EnableBundles -bool YES
defaults write com.apple.mail BundleCompatibilityVersion -int 3

Start Mail

Friday, November 16, 2007

Turn off Translucent Menu Bar in Leopard

sudo defaults write /System/Library/LaunchDaemons/com.apple.WindowServer 'EnvironmentVariables' -dict 'CI_NO_BACKGROUND_IMAGE' 1

Thursday, November 8, 2007

Changing the root password on MySQL

Many distributions of Linux have an option to install MySQL. In this case, or even if you compile MySQL, the default password is blank. MySQL can also run on Windows boxen. When you install MySQL, make sure that you set the root password. You can do this:



root@u-1:/home/u-1# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 3.23.47
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> SET PASSWORD FOR root@localhost=PASSWORD('rubberchicken');
Query OK, 0 rows affected (0.06 sec)
mysql>


In this example, we set the root password to rubberchicken. Note from the above that the password wasn't set. If we try this again, we need to use the -p option to enter the password:



root@u-1:/home/u-1# mysql -u root mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
root@u-1:/home/u-1# mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 3 to server version: 3.23.47
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql>


To reset a root password that you forgot (using paths on our system):



[root@host root]#killall mysqld
[root@host root]#/usr/libexec/mysqld -Sg --user=root &


You may have better luck with:



mysqld --skip-grant-tables --user=root


Go back into MySQL with the client:



[root@host root]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 3.23.41
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> USE mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE user
-> SET password=password("newpassword")
-> WHERE user="root";
Query OK, 2 rows affected (0.04 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> exit;
[root@host root]#killall mysqld


Start MySQL the normal way for your system, and all is good. For Red Hat this is:



/etc/init.d/mysqld start

Monday, October 29, 2007

Group Members

Have you ever tried to get a list of group members in a text file.

Well you can do it this way:

dscl /LDAPv3/ldap.company.com -read /Groups/ThisGroup Member > ThisGroupsMembers.txt