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 QA. ___ 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: 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 QA. ___ 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=your-account and change in /etc/rc.conf mysql_dbdir=/xxx/xxx/xx or chahge owner for /xxx/xxx/xx to your-account 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: 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] -- 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: 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: 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]