Re: Starting MySQL with different database directory
On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote: > I hope this is the right place--i looked over the MySQL docs but they talk > about a different startup practice than what FreeBSD uses. > > I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my > MySQL data directory in a place other than /var/db/mysql. I thought i do this > by > copying the appropriate my.cnf into /etc/my.conf and adding a line like > "datadir = > /usr/local/mysql/var/" and making it readable to mysql user. But this doesnt > work; > when i restart MySQL its still using /var/db/mysql. > > So i looked at the mysql-server startup script in /usr/local/etc/rc.d and > added to > rc.conf "mysql_dbdir="/usr/local/mysql/var"". (I DON'T want to do it this way, > because i really want my MySQL related configuration things in my MySQL > configuration file, not split between there and my FreeBSD startup file. What > if > i need to start mysql in some other way? But for now im just trying to see > what > i can get to work.) This seemed to change something--mysqld had been running > when i made this change and when I ran "mysql-server stop" it couldnt stop, > because it was looking in /usr/local/mysql/var/foo.pid--i think this means it > did > register the change to the new directory. But i couldnt then start it, > because when > I run "mysql-server start" i get a "Can't connect to local MySQL server > through > socket '/tmp/mysql.sock'" error. > > What's the right way to do this? Again id really prefer to do this all > through the > my.cnf file, but this seems not to be getting read, at least for this reason. > > Thank you. > > Jen > > > - > Food fight? Enjoy some healthy debate > in the Yahoo! Answers Food & Drink Q&A. > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > By default MySQL daemon run as user "mysql". If you want start/stop mysqld then in /usr/local/etc/rc.d /mysql-server.sh replace line mysql_user="mysql" to mysql_user="" and change in /etc/rc.conf mysql_dbdir="/xxx/xxx/xx" or chahge owner for /xxx/xxx/xx to Needed directory structure will created. Before all changes stop mysqld. -- Kalashnikov Ilya <[EMAIL PROTECTED]> ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Starting MySQL with different database directory
On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote: > I hope this is the right place--i looked over the MySQL docs but they talk > about a different startup practice than what FreeBSD uses. > > I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my > MySQL data directory in a place other than /var/db/mysql. I thought i do this > by > copying the appropriate my.cnf into /etc/my.conf and adding a line like > "datadir = > /usr/local/mysql/var/" and making it readable to mysql user. But this doesnt > work; > when i restart MySQL its still using /var/db/mysql. > > So i looked at the mysql-server startup script in /usr/local/etc/rc.d and > added to > rc.conf "mysql_dbdir="/usr/local/mysql/var"". (I DON'T want to do it this way, > because i really want my MySQL related configuration things in my MySQL > configuration file, not split between there and my FreeBSD startup file. What > if > i need to start mysql in some other way? But for now im just trying to see > what > i can get to work.) This seemed to change something--mysqld had been running > when i made this change and when I ran "mysql-server stop" it couldnt stop, > because it was looking in /usr/local/mysql/var/foo.pid--i think this means it > did > register the change to the new directory. But i couldnt then start it, > because when > I run "mysql-server start" i get a "Can't connect to local MySQL server > through > socket '/tmp/mysql.sock'" error. > > What's the right way to do this? Again id really prefer to do this all > through the > my.cnf file, but this seems not to be getting read, at least for this reason. > > Thank you. > > Jen > > > - > Food fight? Enjoy some healthy debate > in the Yahoo! Answers Food & Drink Q&A. > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > Hi Dr. Jennifer Nussbaum. Need append to /etc/rc.conf follow line: mysql_dbdir="/mysql/db/location" See please /usr/local/etc/rc.d/mysql-server.sh -- Kalashnikov Ilya <[EMAIL PROTECTED]> ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Substitute command on vi
On Fri, 2006-05-05 at 10:12 -0300, Aguiar Magalhaes wrote: > Hi list, > > I need to substitute a lot of characters ^M (ctrl+M) > at the end of each line in my file. > > The command :%s/^M//g insn't have success. > > How can i do it ? > > Thanks, > > Aguiar > > > > ___ > Abra sua conta no Yahoo! Mail: 1GB de espaço, alertas de e-mail no celular e > anti-spam realmente eficaz. > http://br.info.mail.yahoo.com/ > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > I also has it problem. I'm in Midnight Commander copy symbol '^M' and paste to my script instead (see below) :-/ script: sed -e 's/$//g' filename > filename.copy It work. :) -- Kalashnikov Ilya <[EMAIL PROTECTED]> ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Shared Library Error
On Thu, 2006-05-04 at 16:34 +0100, Soo-Hyun Choi wrote: > I did "ldconfig -R" and "ldconfig -m /usr/local/lib" but I still get > the error message. > > So, how would you explicitly do with that if you get: > [EMAIL PROTECTED] ~]$firefox > /libexec/ld-elf.so.1: Shared object "libgmodule-2.0.so.600" not found, > required by "libgtk-x11-2.0.so.600" > > Thanks, > > > On 5/4/06, [EMAIL PROTECTED]@mgEDV.net <[EMAIL PROTECTED]> wrote: > > > > > How do I check/modify ldconfig settings? Would you give me some > > > examples? > > > > ! man ldconfig > > ldconfig -r > > ls -l /etc/ld* > > ls -l /var/run/ld* > > echo $LD_LIBRARY_PATH > > > > > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > make link with name libgmodule-2.0.so.600 to libgmodule-2.0.so and try again. run as root: prompt# ln -s libgmodule-2.0.so libgmodule-2.0.so.600 -- Kalashnikov Ilya <[EMAIL PROTECTED]> ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: What's that filesystem for a usb flash drive?
Saul Mena Avila пишет: Hello!. I've been trying to mount my flash memory but it just doesn't let me. I use (as root): mount -t msdosfs /dev/ad0 /flash The feedback is something like "device ad0 doesn't allow action" Can anybody help me? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" Hello. You device must be /dev/da0s1 # mount -t msdosfs /dev/da0s1 /flash ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP
On Tue, 2005-06-14 at 10:05 -0500, Joseph Koenig (jWeb) wrote: > Hi, > > I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on > FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory > to set the listen_address (and uncommented it) and have the port line > uncommented and set to the default 5432. I then restarted the postmaster and > tried to connect. I get: > > could not connect to server: Connection refused > Is the server running on host "xx.xxx.xx.xxx" and accepting > TCP/IP connections on port 5432? > > I can connect from localhost just fine. Is there anything that needs to be > set in /etc/inetd.conf or /etc/hosts.allow? I have postgresql_enable="YES" > in my /etc/rc.conf file, but have not rebooted since I added that. If that's > the problem, is there a good way to load that value without rebooting? Is it > just an environmental variable? Thanks, > > Joe Koenig > Production Manager > jWeb New Media Design > [EMAIL PROTECTED] > http://www.jwebmedia.com/ > 636.928.3162 > > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > also check how database is started. example: pg_ctl start -D $PGDATA -o -i Options -i listen tcp connection. -- Kalashnikov Ilya <[EMAIL PROTECTED]> ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP
On Tue, 2005-06-14 at 10:05 -0500, Joseph Koenig (jWeb) wrote: > Hi, > > I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on > FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory > to set the listen_address (and uncommented it) and have the port line > uncommented and set to the default 5432. I then restarted the postmaster and > tried to connect. I get: > > could not connect to server: Connection refused > Is the server running on host "xx.xxx.xx.xxx" and accepting > TCP/IP connections on port 5432? > > I can connect from localhost just fine. Is there anything that needs to be > set in /etc/inetd.conf or /etc/hosts.allow? I have postgresql_enable="YES" > in my /etc/rc.conf file, but have not rebooted since I added that. If that's > the problem, is there a good way to load that value without rebooting? Is it > just an environmental variable? Thanks, > > Joe Koenig > Production Manager > jWeb New Media Design > [EMAIL PROTECTED] > http://www.jwebmedia.com/ > 636.928.3162 > > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > -- see pg_hba.conf in $PGDATA directory. :) ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: How much HDD space does FreeBSD need?
On Thu, 2005-03-17 at 13:58 +, Soo-Hyun Choi wrote: > Hi, > > I'm wondering how much HDD space does FreeBSD need in a normal > installation. What I mean by the normal installation includes 'Full > X-Development' packages with Gnome. Oh, It's 5.3-RELEASE. > > My HDD has 10G space for FreeBSD and I installed onto that space. The > FreeBSD installation was of no problem. However, once I tried to > upgrade Gnome 2.8 to 2.10, I've faced up a warning message at some > point that I am running out of HDD space. (I just executed the > recommend upgrade shell script from http://www.FreeBSD.org/gonme/) > > Is 10G HDD space is not good enough? > > Soo-Hyun read script output! "Not enough space ... Please set the MC_TMPDIR variable to a location that has at least 200 MB of free space..." 1. you_prompt$ setenv MC_TMPDIR /path/to/temp/folder/where/enough/space 2. run script again -- Kalashnikov Ilya <[EMAIL PROTECTED]> ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
