user3215's questions

I am trying to setup mysql-cluster-gpl-7.1.17-linux-i686-glibc23.tar.gz on ubuntu 10.04 server for the past 3 weeks and not successful yet.

The links I followed are:

http://stepbysteparticles.com/index.php?option=com_content&view=article&id=48&Itemid=54

http://cyrenity.wordpress.com/2010/08/12/howto-setup-mysql-cluster-beginners-tutorial/

http://tech.jocke.no/2011/03/13/mysql-cluster-how-to-with-load-balancing-failover/

http://www.lod.com/whitepapers/mysql-cluster-howto.html

http://blog.rimuhosting.com/2011/07/06/building-database-clusters-with-mysql/

All the configurations in the above links are almost same with some slight changes and I just gave a try of all if any works but none.

I already made a post in serverfault but I am still could not able to make it work.

I always come back here if nothing works out after many tries and now I am.

Also I am not understanding whether mysql-server or mysql-client need to be installed along with mysql-cluster else mysql-cluster alone is enough for running mysqld on SQL nodes. In my case the setup is 3 nodes=(data1+sql1 + data2+sql2 + mgmt node).

Frequent errors:

/etc/init.d/mysql.server start

Output:

Starting MySQL
 * Couldn't find MySQL manager (/usr/bin/mysqlmanager) or server (/usr/bin/mysqld_safe)

I even tried copying /usr/local/mysql/bin/* to /usr/bin but still no use as it was telling . * Manager of pid-file quit without updating file. while trying to start!

While trying to start mysql daemon on data/sql node

cd /usr/local/mysql

./bin/mysqld_safe --user=mysql --defaults-file=/etc/my.cnf &

Output:

[1] 2338
root@web2:/usr/local/mysql# 111208 15:53:47 mysqld_safe Logging to syslog.
111208 15:53:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111208 15:53:47 mysqld_safe mysqld from pid file /var/lib/mysql/web2.pid ended

[1]+  Done                    ./bin/mysqld_safe --user=mysql --defaults-file=/etc/my.cnf

Anybody take up and help me here please?. Anybody clarify if there is any problem with ubuntu or with cluster config?. I have to implement this on cloud servers once I am successful.

Thank you!

Update:1

Now on SQL/Data nodes I have had already removed mysql-server and mysql-client which I generally install as a basic package of any fresh installation. I removed them by running following command and on both of the nodes only mysql-cluster is available which I could not able to setup:

apt-get remove mysql-client mysql-client-5.1 mysql-client-core-5.1 mysql-common mysql-server mysql-server-5.1 mysql-server-core-5.1

Update:2

I have fixed the issues I had. Now I have the following things left to be done.

1. What is the best method to Add/Remove mgmt, SQL/DATA nodes being online?

   EDIT: I tried mysql docs for adding nodes online but confused and didn't work unless I shutdown all the nodes and remove the logs under /var/lib/mysql-cluster on all the nodes.

2. What additional configurations should I include in my my.conf file for best performance tuning like DataMemory and IndexMemory, if anybody using for production, can recommend or paste it here please?

Update:3

1. How to convert all the table engines of the database to NDB which are having foreign keys also?

   EDIT: I found a script for converting all the table engines but all the tables of my database are not converted as for the error: ERROR 1217 (23000) at line 11: Cannot delete or update a parent row: a foreign key constraint fails

2. Is there a way to possess both the features of NDB & InnoDB with cluster and multi-master replication with no risk(down time)?

Does anybody know how to apply a customized user settings to other existing or new users?. Something like a customized preferences settings for system wide so that everybody posses those settings and below will explain in clear what I actually ment.

On every machine I will install the following:

Eclipse
Mysql Query Browser and Admin
Mysql Workbench
Oracle VirtualBox
Thunderbird
-----------
-----------
-----------

If I install them by apt, this will automatically create shortcuts in Applications but when I build them from source or extract the tar ball, I will have to add New Item at it's relevant place going to System-->Preferences-->Main Menu to make them available as a shortcuts and this settings are applied only for the account I login and perform them. How could I make this preferences settings for complete system wide which applies for all users? or if there is a way to apply a customized user settings to other users will also be ok. Any hint please?

Thank you!

I have a huge file with the entries like the one below:

<option value="201">Medical</option>
<option value="203">Finance</option>
<option value="205">Tax Return</option>
---------------------------
---------------------------

I am trying to delete 'options' entries in this file in one-shot so that file looks like the one below after editing:

Medical
Finance
Tax Return
----------
----------

I searched this in the google if I could do this with vim or gedit but didn't find any relevant to this(don't know searching with what keyword). Anybody has any idea, please?

How do I list top or bottom 10 lines from the line that matched the word 'error' in a file.

I'm using grep 'error' /var/log/logfile.log > errors to print and save the lines that matched the word 'error' in to the file called 'errors'. How could I change this to suite my requirement?. Anybody has any idea?

I have postfix mail agent installed and I've configured gmail relay and I could send mails from the terminal as below:

root@statino1:~# mail -s "subject_here" [email protected]
CC: <hit enter for empty cc>

Type the mesage here
press Ctrl+d

I have to send a log file contents as a mail and schedule it to run everyday.

How do I send log file contents as mail message, how do I automate the inputs of mail command? so that I can schedule it. Anybody has any idea?

When I try to use iptables command on one of my Rackspace cloud server, I'm getting the following error.

In an attempt to apply iptables rules with iptables-apply -t 120 /etc/iptables.rules and iptables-restore < /etc/iptables.rules I got the next error:

FATAL: Could not load /lib/modules/2.6.32.4-rscloud/modules.dep: No such file or directory
iptables-restore v1.4.4: iptables-restore: unable to initialize table 'filter'

Error occurred at line: 2
Try `iptables-restore -h' or 'iptables-restore --help' for more information.

How do I fix this?

EDIT 1:

uname -r :

2.6.32.4-rscloud

modprobe /lib/modules/$(uname -r)/kernel/net/ipv4/netfilter/iptable_filter.ko :

FATAL: Could not load /lib/modules/2.6.32.4-rscloud/modules.dep: No such file or directory

ls: cannot access /lib/modules/2.6.32.4-rscloud/kernel/net/ipv4/netfilter/: No such file or directory

apt-cache search linux-image-* :

alsa-base - ALSA driver configuration files
linux-image-2.6.31-14-generic - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-14-server - Linux kernel image for version 2.6.31 on x86_64
linux-image-2.6.31-14-virtual - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-302-ec2 - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-9-rt - Linux kernel image for version 2.6.31 on Ingo Molnar's full real time preemption patch
linux-image-rt - Rt Linux kernel image
rt2400-source - source for rt2400 wireless network driver
rt2500-source - source for rt2500 wireless network driver
rt2570-source - source for rt2570 wireless network driver
linux-image - Generic Linux kernel image.
linux-image-2.6.31-15-generic - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-15-server - Linux kernel image for version 2.6.31 on x86_64
linux-image-2.6.31-15-virtual - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-16-generic - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-16-server - Linux kernel image for version 2.6.31 on x86_64
linux-image-2.6.31-16-virtual - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-17-generic - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-17-server - Linux kernel image for version 2.6.31 on x86_64
linux-image-2.6.31-17-virtual - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-19-generic - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-19-server - Linux kernel image for version 2.6.31 on x86_64
linux-image-2.6.31-19-virtual - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-20-generic - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-20-server - Linux kernel image for version 2.6.31 on x86_64
linux-image-2.6.31-20-virtual - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-21-generic - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-21-server - Linux kernel image for version 2.6.31 on x86_64
linux-image-2.6.31-21-virtual - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-304-ec2 - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-305-ec2 - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-306-ec2 - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-ec2 - Linux kernel image for ec2 machines
linux-image-generic - Generic Linux kernel image
linux-image-server - Linux kernel image on Server Equipment.
linux-image-virtual - Linux kernel image for virtual machines
linux-image-2.6.31-22-generic - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-22-server - Linux kernel image for version 2.6.31 on x86_64
linux-image-2.6.31-22-virtual - Linux kernel image for version 2.6.31 on x86/x86_64
linux-image-2.6.31-307-ec2 - Linux kernel image for version 2.6.31 on x86/x86_64

Is there any specific package for cp command which shows the process of being copied.

I'm wondering if there is any package cp which shows additional information that what has been copied and what are left or how many percentage it has been copied...etc. Any body using any?

In my office I've Ubuntu 8.10 desktop installed and it's running for a long time. When ever the system is started, I'll get a file system maintenance error and something it's prompted for the root password or (press ctrl+d to continue). After pressing Ctrl+D the system normally boots up. I could not resolve this issue for a long time and I think something should be done in the fstab file. I'm not sure to do anything and expecting the experts here to help to perfectly fix this. Any help is appreciated.

Thanks!

I'm trying to find the best Log File monitoring tool for Ubuntu 9.10 server?

Is there any web-based gui tool which could be operated by anyone, that monitor any log files?

I already tried splunk and felt it's a bit hard to operate and it's not a completely free tool

Is there any other package other than elinks so that I browse internet inside the terminal using terminal as a browser. I feel elinks is a bit difficult to operate.

I'm running 2 ubuntu 9.10 servers. I have to synchronize the changes between these two machines. The following are the directories I've to synchronize:

/usr, /etc, /var, /bin, /sbin, /lib

I'm using rsync like the below for replication:

rsync -avP 192.168.2.100:/usr/ /usr

rsync -avP 192.168.2.100:/etc/ /etc ------here I'll have to exclude many files like /etc/udev/*, /etc/hosts, /etc/hostname,...

I tried using rsync -avP --exclude '/etc/fstab' 192.168.2.100:/etc/ /etc but it overwritten entire /etc directory

Can any one edit and give me rsync to one line command which synchronizes specified directories and not which are excluded?. Need help!

I have Ubuntu cloud servers running which I don't have direct access to but with ssh. I'm using 'tar' to clone or to have high availability of this server. I followed the tutorial from the link [link text][1]. I tried this installing a new server of same version. When I extracted the tar (tar -xvpzf ~/clone.tgz -C /) on the destination (new), at the end it's ending with the following output similar to the below (don't know if it's error).

tar: var/run: time stamp 2010-11-09 17:09:11 is 7335.159880406 s in the future
tar: var/spool/postfix/usr/lib/zoneinfo: time stamp 2010-11-09 17:08:26 is 7290.159730037 s in the future
tar: var/lib: time stamp 2010-11-09 17:27:51 is 8455.159349527 s in the future
tar: usr/bin: time stamp 2010-11-09 17:28:02 is 8466.159254097 s in the future
tar: usr/share/sgml: time stamp 2010-11-09 17:27:47 is 8451.158909506 s in the future
tar: usr/share/man/man7: time stamp 2010-11-09 17:27:50 is 8454.158393583 s in the future
tar: usr/share/man/man1: time stamp 2010-11-09 17:28:02 is 8466.158166556 s in the future
tar: usr/share/man/man8: time stamp 2010-11-09 17:27:51 is 8455.158057701 s in the  future
tar: usr/share/omf/time-admin: time stamp 2010-11-09 17:27:52 is 8456.157830449 s in the future
---------------------------------------------
---------------------------------------------
---------------------------------------------

I'm using following command to create a tar file of the specified directories on the source system.

tar -cvzf ~/clone.tgz --exclude ~/clone.tgz --exclude /etc/hosts --exclude /etc/hostname --exclude /etc/udev/ --exclude /etc/network/interfaces --exclude /etc/resolv.conf  /etc /home /opt /tmp /usr /var /mnt

• Is there any precautions before using tar? (the tar is one time creation from then I'll be using rsync)
• Should I've to include any more directory like bin or lib? - suggest me
• Should I've to exclude any directory? Like I had a network device (eth0) problem (failed to start up eth0). So in the above command I've excluded "/etc/udev/" and after this I felt this was fine. Like this, is there any thing I've to exclude from /etc/ or from any directory that I've included? - suggest me.
• How could I schedule rsync (incremental bkp) with ssh combination to sync the directories (specified in tar) to the remote location (say /mnt/newdir) which I could tar and extract it later in case of system failure. Rsync can be scheduled to run as root user but the ssh will prompt for the password. FYI, sudo is completely disabled and as well as direct ssh login to root is also disabled.

If there is any better way without any harm to server to achieve this, can suggest.

[1]: http://ubuntuforums.org/showthread.php? t=525660

I'm using oracle/sun virtual box3.2 on ubuntu 10.04 desktop. The ip is not assigned to the guest virtual system and the mode of network is bridged. I even tried 'dhclient' but it could not fetch.

Output of 'ifconfig':

Edit:1 Actually I want to have both, the guest should have access to internet and as well as the host to guest networking

I have scheduled a cron job to backup mysql databases on ubuntu9.10. I used the following entries in the cron file.

37 4 * * * root /usr/bin/mysqldump -u root -p<mysql-password> --all-databases > /usr/backup/mysqlbkup/all-databases.sql

It backs up all the databases puts in a single file called 'all-databases.sql'. This is what I wanted. But if I want to restore a single database I will have to restore all the databases. Is there any trick to backup all mysql databases to a directory with their database name individually?.

I'm trying to check the boot log messages in the file /var/log/boot on Ubuntu 8.10 & 9.10 and I found it empty with the message (Nothing has been logged yet.). The bootlogd service is running at the startup.

I changed the file vim /etc/default/bootlogd

# Run bootlogd at startup ?
BOOTLOGD_ENABLE=No

Change No to Yes:

# Run bootlogd at startup ?
BOOTLOGD_ENABLE=Yes

Is it possible to clone an Ubuntu system and if any changes are made to original system, those should be replicated to the one cloned? I need to have backup support if original one gets down. In my case, Ubuntu is a cloud server.

Please guide me step by step.

Is it possible to restore files/directories which are deleted from terminal using rm and rm -r?. If a file is deleted from graphical interface, it could be restored from trash, but how do you restore a file if it is removed using the rm utility?.

I'm running ubuntu 10.04. I have a newly purchased TATA Photon+ Internet connection which supports Windows and Mac. On the Internet I found a article saying that it could be configured on Linux. I followed the steps to install it on Ubuntu from this link. I am still not able to get online, and need some help.

Also, it is very slow, but I was told that I would see speeds up to 3.1MB.

I dont have wvdial installed and cannot install it from apt as I'm not connected to internet

Booting from windows I dowloaded "wvdial" .deb package and tried to install on ubuntu but it's ended with dependency problem. Automatically, don't know how, I got connected to internet only for once. Immediately I installed wvdial package after this I followed the tutorials(I could not browse and upload the files here) . From then it's showing that the device is connected in the network connections but no internet connection. Once I disable the device, it won't show as connected again and I'll have to restart my system. Sometimes the device itself not detected(wondering if there is any command to re-read the all devices).

output of wvdialconf /etc/wvdial.cof:

#wvdialconf /etc/wvdial.conf

Editing `/etc/wvdial.conf'.

Scanning your serial ports for a modem.

ttyS0<*1>: ATQ0 V1 E1 -- failed with 2400 baud, next try: 9600 baud
ttyS0<*1>: ATQ0 V1 E1 -- failed with 9600 baud, next try: 115200 baud
ttyS0<*1>: ATQ0 V1 E1 -- and failed too at 115200, giving up.
Modem Port Scan<*1>: S1   S2   S3   
WvModem<*1>: Cannot get information for serial port.
ttyUSB0<*1>: ATQ0 V1 E1 -- failed with 2400 baud, next try: 9600 baud
ttyUSB0<*1>: ATQ0 V1 E1 -- failed with 9600 baud, next try: 9600 baud
ttyUSB0<*1>: ATQ0 V1 E1 -- and failed too at 115200, giving up.
WvModem<*1>: Cannot get information for serial port.
ttyUSB1<*1>: ATQ0 V1 E1 -- failed with 2400 baud, next try: 9600 baud
ttyUSB1<*1>: ATQ0 V1 E1 -- failed with 9600 baud, next try: 9600 baud
ttyUSB1<*1>: ATQ0 V1 E1 -- and failed too at 115200, giving up.
WvModem<*1>: Cannot get information for serial port.
ttyUSB2<*1>: ATQ0 V1 E1 -- OK
ttyUSB2<*1>: ATQ0 V1 E1 Z -- OK
ttyUSB2<*1>: ATQ0 V1 E1 S0=0 -- OK
ttyUSB2<*1>: ATQ0 V1 E1 S0=0 &C1 -- OK
ttyUSB2<*1>: ATQ0 V1 E1 S0=0 &C1 &D2 -- OK
ttyUSB2<*1>: ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0 -- OK
ttyUSB2<*1>: Modem Identifier: ATI -- Manufacturer: +GMI: HUAWEI TECHNOLOGIES CO., LTD
ttyUSB2<*1>: Speed 9600: AT -- OK
ttyUSB2<*1>: Max speed is 9600; that should be safe.
ttyUSB2<*1>: ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0 -- OK

Found a modem on /dev/ttyUSB2.
Modem configuration written to /etc/wvdial.conf.
ttyUSB2<Info>: Speed 9600; init "ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0"

output of wvdial:

#wvdial
--> WvDial: Internet dialer version 1.60
--> Cannot get information for serial port.
--> Initializing modem.
--> Sending: ATZ
ATZ
OK
--> Sending: ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
OK
--> Sending: AT+CRM=1
AT+CRM=1
OK
--> Modem initialized.
--> Sending: ATDT#777
--> Waiting for carrier.
ATDT#777
CONNECT
--> Carrier detected.  Starting PPP immediately.
--> Starting pppd at Sat Oct 16 15:30:47 2010
--> Pid of pppd: 5681
--> Using interface ppp0
--> pppd: (u;[08]@s;[08]`{;[08]
--> pppd: (u;[08]@s;[08]`{;[08]
--> pppd: (u;[08]@s;[08]`{;[08]
--> pppd: (u;[08]@s;[08]`{;[08]
--> pppd: (u;[08]@s;[08]`{;[08]
--> pppd: (u;[08]@s;[08]`{;[08]
--> local  IP address 14.96.147.104
--> pppd: (u;[08]@s;[08]`{;[08]
--> remote IP address 172.29.161.223
--> pppd: (u;[08]@s;[08]`{;[08]
--> primary   DNS address 121.40.152.90
--> pppd: (u;[08]@s;[08]`{;[08]
--> secondary DNS address 121.40.152.100  
--> pppd: (u;[08]@s;[08]`{;[08]

Output of log message /var/log/messages:

Oct 16 15:29:44 avyakta-desktop pppd[5119]: secondary DNS address 121.242.190.180
Oct 16 15:29:58 desktop pppd[5119]: Terminating on signal 15
Oct 16 15:29:58 desktop pppd[5119]: Connect time 0.3 minutes.
Oct 16 15:29:58 desktop pppd[5119]: Sent 0 bytes, received 177 bytes.
Oct 16 15:29:58 desktop pppd[5119]: Connection terminated.
Oct 16 15:30:47 desktop pppd[5681]: pppd 2.4.5 started by root, uid 0
Oct 16 15:30:47 desktop pppd[5681]: Using interface ppp0
Oct 16 15:30:47 desktop pppd[5681]: Connect: ppp0 <--> /dev/ttyUSB2
Oct 16 15:30:47 desktop pppd[5681]: CHAP authentication succeeded
Oct 16 15:30:47 desktop pppd[5681]: CHAP authentication succeeded
Oct 16 15:30:48 desktop pppd[5681]: local  IP address 14.96.147.104
Oct 16 15:30:48 desktop pppd[5681]: remote IP address 172.29.161.223
Oct 16 15:30:48 desktop pppd[5681]: primary   DNS address 121.40.152.90
Oct 16 15:30:48 desktop pppd[5681]: secondary DNS address 121.40.152.100

EDIT 1 :

I tried the following

sudo stop network-manager
sudo killall modem-manager

sudo /usr/sbin/modem-manager --debug > ~/mm.log 2>&1 &

sudo /usr/sbin/NetworkManager --no-daemon > ~/nm.log 2>&1 &

Output of mm.log:

#vim ~/mm.log:

** Message: Loaded plugin Option High-Speed

** Message: Loaded plugin Option

** Message: Loaded plugin Huawei

** Message: Loaded plugin Longcheer

** Message: Loaded plugin AnyData

** Message: Loaded plugin ZTE

** Message: Loaded plugin Ericsson MBM

** Message: Loaded plugin Sierra

** Message: Loaded plugin Generic

** Message: Loaded plugin Gobi

** Message: Loaded plugin Novatel

** Message: Loaded plugin Nokia

** Message: Loaded plugin MotoC

Output of nm.log:

#vim ~/nm.log:

NetworkManager: <info>  starting...

NetworkManager: <info>  modem-manager is now available

NetworkManager:    SCPlugin-Ifupdown: init!

NetworkManager:    SCPlugin-Ifupdown: update_system_hostname

NetworkManager:    SCPluginIfupdown: guessed connection type (eth0) = 802-3-ethernet

NetworkManager:    SCPlugin-Ifupdown: update_connection_setting_from_if_block:     

name:eth0, type:802-3-ethernet, id:Ifupdown (eth0), uuid: 681b428f-beaf-8932-dce4-678ed5bae28e

NetworkManager:    SCPlugin-Ifupdown: addresses count: 1

NetworkManager:    SCPlugin-Ifupdown: No dns-nameserver configured in /etc/network/interfaces

NetworkManager: nm-ifupdown-connection.c.119 - invalid connection read from /etc/network/interfaces: (1) addresses

NetworkManager:    SCPluginIfupdown: management mode: unmanaged

NetworkManager:    SCPlugin-Ifupdown: devices added (path: /sys/devices/pci0000:00/0000:00:14.4/0000:02:02.0/net/eth1, iface: eth1)

NetworkManager:    SCPlugin-Ifupdown: device added (path: /sys/devices/pci0000:00/0000:00:14.4/0000:02:02.0/net/eth1, iface: eth1): no ifupdown configuration found.

NetworkManager:    SCPlugin-Ifupdown: devices added (path: /sys/devices/virtual/net/lo, iface: lo)

@

How do I install ubuntu packages from the ubuntu cd. I have ubuntu-desktop 10.04 running and I have to install wvdial package but no internet connection for installing from apt repository.

My Ubuntu cloud server has left only 900MB of disk space.

I'll just empty the directory /tmp and wondering if there is any other location to clean up.