ERROR 2002 (HY000): pls help...

[mel0683]

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

[mflorell]

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]

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

Is mysqld running?

If it is, run this command:(from the SCRATCH_INSTALL doc)
ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock

[dlapitan]

Hi,


You need to locate the MySQL_AST_CREATE_tables

mysql> \. /usr/src/astguiclient/extras/MySQL_AST_CREATE_tables.sql

[mel0683]

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

[devafree]

Run it with the path

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

regards

devafree

[mel0683]

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

thanks..

[enjay]

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

Think outside the box!