[crackmac]

I’m not an expert but maybe I can help you find more answers.
You can locate where mysql lives with any variation of the “which” command which locates the binary file.
% which mysqld_safe
/usr/local/mysql/bin/
The most common location for mysql is in the /usr/local/mysql directory. For version and assorted other information use the mysqlcheck command. See the –help for options.
% mysqlcheck –help
One of the many things I’ve learned from AFP548.com was the my.cnf file. This file lives in the /etc directory and sets the location of the .sock amongst many other settings. Examples of the conf options are found in the sample config files located in the /usr/share/mysql folder (see my-small.cnf, my-large.cnf etc.).
Other places of interest are:
/System/Library/StartupItems/MYSQL
I hope that helps.
–KD

[QUOTE][u]Quote by: darthbator[/u]

Hello I recently inherited a Mac OSX Xserve at my job and decided that I would like to run mysql on it. After poking around a little it looks like someone tried to remove the default 4.x.x install of mysql that comes with OSX server. in /var there is a folder named .mysqlold which is empty (I am assuming this is the old mysql directory). I could not find mysql anywhere else on the box, worse yet I could not find mysql.sock anywhere on the box. So I decided to simply go to the mysql stite and download a new mysql binary, so I went ahead and downloaded the mysql build for PPC 64 bit (as my dual G5 xserve should be able to use the 64 bit binary). I go about instsalling the dmg as normal, and it unpacks inside /usr/local/$MYSQLDIR.

after cd ing into the directory I notice a ./configure script there so I decide to ./configure –help just to see why that’s even there (as the build is binary and not source). The build then informs me that it’s going to start mysql. I go ahead and do a quick ps aux|grep mysql just to make sure and am greeted with.

[i]root 26832 0.0 -0.0 27808 688 p1 S 3:39PM 0:00.03 /bin/sh ./bin/mysqld_safe –no-defaults
mysql 26848 0.0 -1.0 92108 20436 p1 S 3:39PM 0:00.13 /usr/local/mysql-standard-5.0.27-osx10.4-powerpc-64bit/bin/mysqld –no-defaults –basedir[/i]

looks like it’s running to me, however I still cannot connect to the server since there is no mysql.sock. Does anyone know how to create a new one? I checked $MYSQLDIR/bin/mysqld –verbose –help but didn’t come up with much other then some info that lead me to belive that the socket location was still pointing to /var/mysql/mysql.sock. any help would be most appreciated.

[/QUOTE]

[crackmac]

If you can ssh into the server then use the command serveradmin to stop and restart the vpn service.

[code]% sudo serveradmin stop vpn
% sudo serveradmin start vpn[/code]

The serveradmin command is a very powerful tool for remote administration. Here is a link to the official command line admin manual.

command_line_10-4.pdf

I hope that helps.–KD

[QUOTE][u]Quote by: FastEddy[/u]

Hello All,

I’m trying to figure out how to start a VPN connection form a tunnel built in Internet Connection.

I have a working config, I have shell access, and when the tunnel is up, I have ARD access.
This host is behind a linksys in a remote office. The XServe is in a datacenter.

I’ve tried to use Automater, Apple Script and scoured posts and the command line options.

If I understand correctly, vpnd is for a VPN server, yes? The XServe is the VPN server in my case.
I want a client session to be initiated from a working config.

This is all Tiger based, latest updates.

Thanks in Advance,
Eddy

[/QUOTE]

[crackmac]

I experienced a similar problem and was told that you should set up the VPN and then promote the machine to OD master. I started from scratch and haven’t had the balls to upgrade the server to an OD master yet because it’s not absolutly necessary in my case.
I would save all your settings; reinstall the server keeping the it a standalone server; Set up VPN; then Promote to OD masster.
–Kevin

[QUOTE][u]Quote by: giblad[/u]

Andrina

Sorry it’s taken so long to reply.

I have already replicated the problem on a vanilla OD structure with just one user set up.

The server runs sweet without the VPN service enabled as it seems to be the VPN service that causes all authentication to fail.

It is impossible for me to seperate the VPN and OD as I only have only one available server. My test server does not belong to me.

I have now taken the VPN service away from the server and handed it over to a dedicated ‘box’ and all is well, however I am still no nearer to finding out what caused the problem in the first place and that is what is so frustrating.

If anyone else out there has had similar problems to this, then I would like to hear from you.

Thanks

[/QUOTE]

[crackmac]

[QUOTE][u]Quote by: MacTroll[/u]<p>Be careful as the first site selected tends to have an alias of "*" in it.

Make sure that no aliases exist under the "alias" tabs of any of the site configurations and see if that helps.</p>[/QUOTE]

Excellent! Thank you!

[crackmac]

Hi TIA,
How are the signing on? Are they using terminal or something else?
I usually do something like

%ssh [email protected]

and then it just asks for a password. Is that what’s happening (or not happening)? Have these particular users been able to log on in the past and is this a new problem?

[Author]

Posts