ERROR 2002 (HY000): pls help...

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

ERROR 2002 (HY000): pls help...

Postby mel0683 » Thu Mar 15, 2007 8:11 pm

hi guys,

i encountered error when run the mysql, anyone knows how to fix it?

root@ddi:/usr/local/mysql/bin/mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
root@ddi:/usr/local/mysql/bin#

thank you..
beginner
mel0683
 
Posts: 20
Joined: Fri Feb 02, 2007 1:20 pm

Postby mflorell » Fri Mar 16, 2007 12:13 am

Is mysqld running?

If it is, run this command:(from the SCRATCH_INSTALL doc)
ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock
mflorell
Site Admin
 
Posts: 18334
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby mel0683 » Fri Mar 16, 2007 11:16 pm

i got it, thank you sir,but a have one more problem when creating database query.here's the error:

mysql> create database asterisk;
ERROR 1007: Can't create database 'asterisk'. Database exists
mysql> GRANT SELECT,INSERT,UPDATE,DELETE on asterisk.* TO cron@'%' IDENTIFIED BY '1234';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT SELECT,INSERT,UPDATE,DELETE on asterisk.* TO cron@localhost IDENTIF IED BY '1234';
Query OK, 0 rows affected (0.00 sec)

mysql> use asterisk;
Database changed
mysql> \. /usr/src/astguiclient/MySQL_AST_CREATE_tables.sql
ERROR:
Failed to open file '/usr/src/astguiclient/MySQL_AST_CREATE_tables.sql', error: 2
mysql> GRANT SELECT on asterisk.phones TO idcheck@'%' IDENTIFIED BY '1234';
ERROR 1146: Table 'asterisk.phones' doesn't exist
mysql> GRANT SELECT on asterisk.phones TO idcheck@localhost IDENTIFIED BY '1234' ;
ERROR 1146: Table 'asterisk.phones' doesn't exist


mflorell wrote:Is mysqld running?

If it is, run this command:(from the SCRATCH_INSTALL doc)
ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock
mel0683
 
Posts: 20
Joined: Fri Feb 02, 2007 1:20 pm

Postby dlapitan » Sat Mar 17, 2007 10:34 am

Hi,


You need to locate the MySQL_AST_CREATE_tables

mysql> \. /usr/src/astguiclient/extras/MySQL_AST_CREATE_tables.sql
dlapitan
 
Posts: 68
Joined: Fri Nov 24, 2006 3:59 pm

Postby mel0683 » Mon Mar 19, 2007 2:28 pm

hi guys,can you help me again..why this command not running ADMIN_area_code_populate.pl?Im in the right directory.

thank you..

root@ddi:/usr/share/astguiclient# ls
ADMIN_adjust_GMTnow_on_leads.pl* AST_agent_week.pl*
ADMIN_area_code_populate.pl* AST_cleanup_agent_log.pl*
ADMIN_keepalive_AST_VDadapt.pl* AST_conf_update.pl*
ADMIN_keepalive_AST_VDautodial.pl* AST_flush_DBqueue.pl*
ADMIN_keepalive_AST_VDremote_agents.pl* AST_manager_kill_hung_congested.pl*
ADMIN_keepalive_AST_send_listen.pl* AST_manager_listen.pl*
ADMIN_keepalive_AST_update.pl* AST_manager_send.pl*
ADMIN_restart_roll_logs.pl* AST_reset_mysql_vars.pl*
AST_CRON_mix_recordings.pl* AST_send_action_child.pl*
AST_CRON_mix_recordings_BASIC.pl* AST_update.pl*
AST_CRON_mix_recordings_GSM.pl* AST_vm_update.pl*
AST_CRON_mix_recordings_MP3.pl* LEADS_IN/
AST_CRON_mix_recordings_MP3_DATE.pl* MySQL_AST_CREATE_tables.sql
AST_DB_optimize.pl* VICIDIAL_IN_new_leads_file.pl*
AST_VDadapt.pl* build_translation_www_files.pl*
AST_VDauto_dial.pl* phone_codes_GMT.txt
AST_VDhopper.pl* start_asterisk_boot.pl*
AST_VDremote_agents.pl*
root@ddi:/usr/share/astguiclient# ADMIN_area_code_populate.pl
-bash: ADMIN_area_code_populate.pl: command not found
mel0683
 
Posts: 20
Joined: Fri Feb 02, 2007 1:20 pm

Postby devafree » Mon Mar 19, 2007 2:32 pm

Run it with the path

/usr/share/astguiclient/<script.pl>

regards

devafree
devafree
 
Posts: 180
Joined: Wed Sep 20, 2006 5:03 pm

Postby mel0683 » Mon Mar 19, 2007 4:01 pm

hi,what script.pl you mean?..there's no <script.pl> under my /usr/share/atguiclient path..

thanks..
mel0683
 
Posts: 20
Joined: Fri Feb 02, 2007 1:20 pm

Postby enjay » Tue Mar 20, 2007 6:38 pm

<script.pl> as in, whatever script you are trying to run.

Think outside the box!
enjay
 
Posts: 806
Joined: Mon Jun 19, 2006 12:40 pm
Location: Utah


Return to Support

Who is online

Users browsing this forum: No registered users and 51 guests

cron