mysql.sock

[gangiyanrohit]

hi,
i have installed mysql 4.1.19
but i get error while access mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

the output of screen -r

There is a screen on:
4210.pts-1.nitin (Attached)
There is no screen to be resumed.

please help

[gschaller]

Look in your my.conf. What location has the socket path there?

[gangiyanrohit]

hi
if you please tell where i get this my.conf

[mflorell]

From the SCRATCH_INSTALL:
cp support-files/my-medium.cnf /etc/my.cnf

[gangiyanrohit]

hi
my socket path
/tmp/mysql.sock

thanks

[gangiyanrohit]

hi
this is the output of ps -x

root@nitin:~# ps -x
Warning: bad ps syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
PID TTY STAT TIME COMMAND
1 ? S 0:04 init [3]
2 ? S 0:00 [keventd]
3 ? SN 0:00 [ksoftirqd_CPU0]
4 ? S 0:02 [kswapd]
5 ? S 0:00 [bdflush]
6 ? S 0:00 [kupdated]
10 ? S< 0:00 [mdrecoveryd]
11 ? S 0:00 [kjournald]
43 ? S<s 0:00 udevd
95 ? Ss 0:00 /usr/sbin/syslogd
102 ? Ss 0:00 /usr/sbin/klogd -c 3 -x
270 ? S 0:00 [khubd]
3993 ? Ss 0:00 /usr/sbin/inetd
3997 ? Ss 0:00 /usr/sbin/sshd
4008 ? S 0:00 /usr/sbin/crond -l10
4013 ? Ss 0:00 sendmail: accepting connections
4025 ? Ss 0:00 /usr/sbin/gpm -m /dev/mouse -t imps2
4027 tty1 Ss 0:00 -bash
4028 tty2 Ss+ 0:00 /sbin/agetty 38400 tty2 linux
4029 tty3 Ss+ 0:00 /sbin/agetty 38400 tty3 linux
4030 tty4 Ss+ 0:00 /sbin/agetty 38400 tty4 linux
4031 tty5 Ss+ 0:00 /sbin/agetty 38400 tty5 linux
4032 tty6 Ss+ 0:00 /sbin/agetty 38400 tty6 linux
4045 tty1 S+ 0:00 xinit
4046 ? R< 1:23 X :0
4050 tty1 S 0:00 sh /root/.xinitrc
4051 tty1 S 0:00 /bin/sh /opt/kde/bin/startkde
4076 ? Ss 0:00 kdeinit Running...
4079 ? S 0:00 kdeinit: dcopserver --nosid
4081 ? S 0:00 kdeinit: klauncher
4084 ? S 0:00 kdeinit: kded
4089 ? S 0:00 kdeinit: kded
4090 ? S 0:00 kdeinit: kded
4095 ? S 0:01 artsd -F 10 -S 4096 -s 60 -m artsmessage -c drkonqi -l 3 -f
4097 ? S 0:00 kdeinit: kaccess
4098 tty1 S 0:00 kwrapper ksmserver
4100 ? S 0:00 kdeinit: ksmserver
4101 ? S 0:04 kdeinit: kwin -session 10dc697469000115278962000000038760000_1153318338_110240
4103 ? S 0:01 kdeinit: kdesktop
4105 ? S 0:02 kdeinit: kicker
4107 ? S 0:00 kdeinit: klipper
4111 ? S 0:00 korgac --miniicon korganizer
4112 ? S 0:00 kdeinit: noatun -session 10dc697469000115330465000000039930047_1153318336_216031
4115 ? S 0:00 kdeinit: knotify
4116 ? S 0:00 artsd -F 10 -S 4096 -s 60 -m artsmessage -c drkonqi -l 3 -f
4120 ? S 0:06 kdeinit: konqueror --silent
4185 ? S 0:00 kdeinit: kio_uiserver
4190 ? S 0:04 kdeinit: konqueror -mimetype inode/directory system:/
4195 ? S 0:00 kdeinit: konqueror -mimetype inode/directory system:/
4251 ? S 0:13 kdeinit: konqueror --silent
4331 ? R 0:02 kdeinit: konsole --ls
4332 pts/1 Ss 0:00 -bash
4346 pts/1 S+ 0:10 /usr/bin/perl /usr/bin/cpan
4348 pts/2 Ss+ 0:00 -bash
4366 pts/3 Ss 0:00 -bash
4614 ? S 0:00 rssservice
4619 ? S 0:00 kdeinit: kio_file file /tmp/ksocket-root/klauncher5axrca.slave-socket /tmp/ksocket-
4632 ? S 0:04 kdeinit: konqueror --silent
4679 pts/3 R+ 0:00 ps -x
root@nitin:~#


i have also try

locate -u

but its not works.

also i try AST_update.pl --debug
this is output

root@nitin:/# /home/cron/AST_update.pl --debug
Can't locate Net/Telnet.pm in @INC (@INC contains: ./lib ../lib /usr/lib/perl5/5.8.7/i486-linux /usr/lib/perl5/5.8.7 /usr/lib/perl5/site_perl/5.8.7/i486-linux /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl .) at /home/cron/AST_update.pl line 139.
BEGIN failed--compilation aborted at /home/cron/AST_update.pl line 139.


this is the output of AST_VDauto-dial.pl --debug

root@nitin:/# /home/cron/AST_VDauto-dial.pl --debug
-bash: /home/cron/AST_VDauto-dial.pl: No such file or directory

the only error is that of access mysql using /usr/local/mysql/bin/mysql
i got this error

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

any clues!!!!!!!!!!!

ps- i am on slackware 10.2 with kernal 2.6.31
i have installed asterisk 1.2.9.1; zaptel 1.2.6; libpri1.2.3
i have mysql 4.1.19
my asterisk is working fine.

please help
thanks in advance

[gangiyanrohit]

hi
this is the output of ps -A

root@nitin:/# ps -A
PID TTY TIME CMD
1 ? 00:00:04 init
2 ? 00:00:00 keventd
3 ? 00:00:00 ksoftirqd_CPU0
4 ? 00:00:02 kswapd
5 ? 00:00:00 bdflush
6 ? 00:00:00 kupdated
10 ? 00:00:00 mdrecoveryd
11 ? 00:00:00 kjournald
43 ? 00:00:00 udevd
95 ? 00:00:00 syslogd
102 ? 00:00:00 klogd
270 ? 00:00:00 khubd
3993 ? 00:00:00 inetd
3997 ? 00:00:00 sshd
4008 ? 00:00:00 crond
4010 ? 00:00:00 atd
4013 ? 00:00:00 sendmail
4016 ? 00:00:00 sendmail
4025 ? 00:00:00 gpm
4027 tty1 00:00:00 bash
4028 tty2 00:00:00 agetty
4029 tty3 00:00:00 agetty
4030 tty4 00:00:00 agetty
4031 tty5 00:00:00 agetty
4032 tty6 00:00:00 agetty
4045 tty1 00:00:00 xinit
4046 ? 00:02:09 X
4050 tty1 00:00:00 sh
4051 tty1 00:00:00 startkde
4076 ? 00:00:00 kdeinit
4079 ? 00:00:00 kdeinit
4081 ? 00:00:00 kdeinit
4084 ? 00:00:01 kdeinit
4089 ? 00:00:00 kdeinit
4090 ? 00:00:00 kdeinit
4095 ? 00:00:01 artsd
4097 ? 00:00:00 kdeinit
4098 tty1 00:00:00 kwrapper
4100 ? 00:00:00 kdeinit
4101 ? 00:00:07 kdeinit
4103 ? 00:00:01 kdeinit
4105 ? 00:00:03 kdeinit
4107 ? 00:00:00 kdeinit
4111 ? 00:00:00 korgac
4112 ? 00:00:00 kdeinit
4115 ? 00:00:00 kdeinit
4116 ? 00:00:00 artsd
4120 ? 00:00:15 kdeinit
4185 ? 00:00:00 kdeinit
4190 ? 00:00:05 kdeinit
4195 ? 00:00:00 kdeinit
4251 ? 00:00:13 kdeinit
4331 ? 00:00:03 kdeinit
4332 pts/1 00:00:00 bash
4346 pts/1 00:00:10 cpan
4348 pts/2 00:00:00 bash
4366 pts/3 00:00:00 bash
4614 ? 00:00:00 rssservice
4619 ? 00:00:00 kdeinit
4632 ? 00:00:09 kdeinit
4708 ? 00:00:02 kdeinit
4709 ? 00:00:00 kdeinit
4712 ? 00:00:00 kdeinit
4733 ? 00:00:00 kdeinit
4734 ? 00:00:00 kdeinit
4738 ? 00:00:00 kdeinit
4739 ? 00:00:00 kdeinit
4741 ? 00:00:00 kdeinit
4742 ? 00:00:00 kdeinit
4746 pts/3 00:00:00 ps

regards

rohit

[nitinsrivastava]

Hi Friend,
You really need some LINUX Expert Guy who can help you. Sorry No one other then that can help you.

[mflorell]

It seems like you are not doing most of the things in the SCRATCH_INSTALL document like loading of perl modules or installing Required applications. VICIDIAL is not something that you can just throw stuff on a server at and expect it to work. You need to have all of the requirements set up correctly for it to function properly.

And you cannot have Xwindows(KDE or Gnome) on your Asterisk server, it will cause all sorts of problems with Asterisk.

[gangiyanrohit]

hi
i have installed mysql 4.0.27
but according to scratch _install
when i try to replace the
0.09 version of MySQL.pm with the 0.08 version which is MySQL 4.0.27
i had done

- cpan
- install O/OY/OYAMA/Net-MySQL-0.08.tar.gz
or you can use the version included with the astguiclient release:


But when i
- locate -u
- locate MySQL.pm


then it don't works. (only cursor moves down)

any clues!!!!!!!!!

[gangiyanrohit]

hi
the output of screen -r

root@nitin:/# screen -r
There is no screen to be resumed.

and output of ps -A

PID TTY TIME CMD
1 ? 00:00:04 init
2 ? 00:00:00 keventd
3 ? 00:00:00 ksoftirqd_CPU0
4 ? 00:00:00 kswapd
5 ? 00:00:00 bdflush
6 ? 00:00:00 kupdated
10 ? 00:00:00 mdrecoveryd
11 ? 00:00:00 kjournald
42 ? 00:00:00 udevd
99 ? 00:00:00 syslogd
102 ? 00:00:00 klogd
270 ? 00:00:00 khubd
3993 ? 00:00:00 inetd
3997 ? 00:00:00 sshd
4008 ? 00:00:00 crond
4010 ? 00:00:00 atd
4013 ? 00:00:00 sendmail
4016 ? 00:00:00 sendmail
4025 ? 00:00:00 gpm
4027 tty1 00:00:00 bash
4028 tty2 00:00:00 agetty
4029 tty3 00:00:00 agetty
4030 tty4 00:00:00 agetty
4031 tty5 00:00:00 agetty
4032 tty6 00:00:00 agetty
4045 tty1 00:00:00 xinit
4046 ? 00:00:50 X
4050 tty1 00:00:00 sh
4051 tty1 00:00:00 startkde
4076 ? 00:00:00 kdeinit
4079 ? 00:00:00 kdeinit
4081 ? 00:00:00 kdeinit
4084 ? 00:00:00 kdeinit
4089 ? 00:00:00 kdeinit
4090 ? 00:00:00 kdeinit
4095 ? 00:00:00 artsd
4097 ? 00:00:00 kdeinit
4098 tty1 00:00:00 kwrapper
4100 ? 00:00:00 kdeinit
4101 ? 00:00:02 kdeinit
4103 ? 00:00:01 kdeinit
4105 ? 00:00:01 kdeinit
4107 ? 00:00:00 kdeinit
4111 ? 00:00:00 korgac
4112 ? 00:00:00 kdeinit
4113 ? 00:00:00 kdeinit
4115 ? 00:00:00 kdeinit
4116 ? 00:00:00 artsd
4119 ? 00:00:04 kdeinit
4180 ? 00:00:01 kdeinit
4181 pts/1 00:00:00 bash
4196 ? 00:00:15 kdeinit
4307 ? 00:00:00 kdeinit
4308 ? 00:00:00 kdeinit
4312 ? 00:00:00 kdeinit
4313 ? 00:00:00 kdeinit
4314 ? 00:00:00 kdeinit
4315 ? 00:00:00 kdeinit
4316 ? 00:00:00 kdeinit
4317 ? 00:00:00 kdeinit
4355 ? 00:00:00 kdeinit
4356 ? 00:00:00 kdeinit
4366 ? 00:00:00 ispell
4367 pts/1 00:00:00 ps

the output of ps -x

PID TTY STAT TIME COMMAND
1 ? S 0:04 init [3]
2 ? S 0:00 [keventd]
3 ? SN 0:00 [ksoftirqd_CPU0]
4 ? S 0:00 [kswapd]
5 ? S 0:00 [bdflush]
6 ? S 0:00 [kupdated]
10 ? S< 0:00 [mdrecoveryd]
11 ? S 0:00 [kjournald]
42 ? S<s 0:00 udevd
99 ? Ss 0:00 /usr/sbin/syslogd
102 ? Ss 0:00 /usr/sbin/klogd -c 3 -x
270 ? S 0:00 [khubd]
3993 ? Ss 0:00 /usr/sbin/inetd
3997 ? Ss 0:00 /usr/sbin/sshd
4008 ? S 0:00 /usr/sbin/crond -l10
4013 ? Ss 0:00 sendmail: accepting connections
4025 ? Ss 0:00 /usr/sbin/gpm -m /dev/mouse -t imps2
4027 tty1 Ss 0:00 -bash
4028 tty2 Ss+ 0:00 /sbin/agetty 38400 tty2 linux
4029 tty3 Ss+ 0:00 /sbin/agetty 38400 tty3 linux
4030 tty4 Ss+ 0:00 /sbin/agetty 38400 tty4 linux
4031 tty5 Ss+ 0:00 /sbin/agetty 38400 tty5 linux
4032 tty6 Ss+ 0:00 /sbin/agetty 38400 tty6 linux
4045 tty1 S+ 0:00 xinit
4046 ? R< 0:54 X :0
4050 tty1 S 0:00 sh /root/.xinitrc
4051 tty1 S 0:00 /bin/sh /opt/kde/bin/startkde
4076 ? Ss 0:00 kdeinit Running...
4079 ? S 0:00 kdeinit: dcopserver --nosid
4081 ? S 0:00 kdeinit: klauncher
4084 ? S 0:00 kdeinit: kded
4089 ? S 0:00 kdeinit: kded
4090 ? S 0:00 kdeinit: kded
4095 ? S 0:00 artsd -F 10 -S 4096 -s 60 -m artsmessage -c drkonqi
4097 ? S 0:00 kdeinit: kaccess
4098 tty1 S 0:00 kwrapper ksmserver
4100 ? S 0:00 kdeinit: ksmserver
4101 ? S 0:02 kdeinit: kwin -session 10dc6974690001152789620000000
4103 ? S 0:01 kdeinit: kdesktop
4105 ? S 0:01 kdeinit: kicker
4107 ? S 0:00 kdeinit: klipper
4111 ? S 0:00 korgac --miniicon korganizer
4112 ? S 0:00 kdeinit: noatun -session 10dc69746900011533046500000
4113 ? S 0:00 kdeinit: kio_file file /tmp/ksocket-root/klaunchereE
4115 ? S 0:00 kdeinit: knotify
4116 ? S 0:00 artsd -F 10 -S 4096 -s 60 -m artsmessage -c drkonqi
4119 ? S 0:04 kdeinit: konqueror --silent
4180 ? R 0:01 kdeinit: konsole --ls
4181 pts/1 Ss 0:00 -bash
4196 ? S 0:16 kdeinit: konqueror --silent
4366 ? S 0:00 ispell -a -S -C
4377 pts/1 R+ 0:00 ps -x

please help

[mflorell]

Are you using Slackware 10.2?

You have not installed the scripts in the crontab properly.

You need to deactivate KDE and Xwindows.

[Rohit]

Thanks for your response.

Yes, I am using Slackware 10.2

How do I insure that I have installed the scripts in the crontab properly...is there a way to cross-check...been following Scratch_Install.

How complex is it to deactivate KDE and Xwindows. What steps I should follow in order to ensure that nothing else gets affected.

Appreciate your comments and feedback.

[mflorell]

To check the crontab you can run those scripts manually and see if they run.

As for disabling Xwindows. I just never install it on an Asterisk server. Maybe you should wipe everything and follow the SCRATCH_INSTALL from the beginning.

[roche]

Thanks for your response.

Yes, I am using Slackware 10.2

How do I insure that I have installed the scripts in the crontab properly...is there a way to cross-check...been following Scratch_Install.

What is the output of?
# crontab -l

and the output of
# screen -ls

How complex is it to deactivate KDE and Xwindows. What steps I should follow in order to ensure that nothing else gets affected.

If you installed those package from the slack packages. You can use pkgtool

[Rohit]

Thanks for the fast response.

Do I need to start from the begining, ie, wipe off and re-install Asterisk, Zaptel, and ViciDialer?

[gangiyanrohit]

hi
i have uninstall the xwindows and kde packages throug pkgtool
my asterisk is working fine
but when i try to connect mysql it shows error


ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


ps-i have check all the packages and modules as in the scratch document.

please help

rohit

[Clown]

Hi. I have the same problem. While installing according to the scratch installation (Only changes made are the IP's, using given passwords etc and all links) I get to the part of logging into the dialler :
"3. Enter the vicidial administration page:
://10.10.10.15/vicidial/admin.php"
I get a message connection actively refused.

Everything is running and I was able to do all the MYSQL stuff but on running it again I cannot get back into mysql without getting the error:
"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

I've attempted some of the tips found in google and have even started from scratch but fail at the same spot and same error.

[ramindia]

Hi

cehck the Mysql Service Running

make sure you were able to connect to mysql

ram