Results 1 to 3 of 3

Thread: mysql instruction waiting for somthing

  1. #1

    Red face mysql instruction waiting for somthing

    hi

    i have this mysql instruction

    mysql -u root --password= syslog< /tmp/mysql.pipe

    part of this script
    Code:
    if [ -e /tmp/mysql.pipe ]; then
         while [ -e /tmp/mysql.pipe ]
         do
             mysql -u root --password= syslog< /tmp/mysql.pipe
         done
    else
         mkfifo /tmp/mysql.pipe
    fi
    syslog is an existing database
    each time it is invocated the terlinal is blocked seems wating for somthing

    i have to exite it with ctrl + c to come back to # linux_test1

    so

    could any body tell me what is wrong this the theird day were i am looking for solution

  2. #2
    Join Date
    Sep 2008
    Location
    Dubai
    Posts
    1,770

    Default Re: mysql instruction waiting for somthing

    You have to provide more info to get help. It looks like the script is reading SQL commands from the pipe /tmp/mysql.pipe if it exists.
    So, there is some other process that writes to that pipe. So, the reading process will wait until the writing process closes the pipe.
    openSUSE 12.3 (x86_64) with Kernel 3.7.10-1.16-desktop and KDE 4.11.2 on MacBook Pro
    Latest MS Windows version used: Win95

  3. #3
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,441

    Default Re: mysql instruction waiting for somthing

    The obvious error is that the password invocation is incorrect. There should be no = after password unless 'syslog' is the password; in that case, there should be no space after =.

    Alternatively, did you use PASSWORD() to encrypt the password? In that case you need to provide the encrypted password.

    If you are using plain text passwords, you are asking for problems.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •