Then I think the problem is located in the ser_mysql
script collecting
the root password.
Can you please add a bug in the tracker so it accepts empty root
password?
Great you solved it!
samuel.
2007/2/28, Andrey Kuprianov <andrey.kouprianov(a)gmail.com>om>:
Thanks a lot! That worked out just fine :)
On 2/28/07, Andrey Kuprianov <andrey.kouprianov(a)gmail.com> wrote:
I see.. let me try
On 2/28/07, samuel <samu60(a)gmail.com> wrote:
> can you try to use a password for root and see if it works??
>
> I had an issue with blank spaces in a password and the output was
the
same...
>
> Samuel.
>
> 2007/2/28, Andrey Kuprianov <andrey.kouprianov(a)gmail.com>om>:
> > Hi,
> >
> > Im running Ubuntu with MySQL 5.0.24a. I've downloaded and compiled
> > Ottendorf from CVS successfully. The problem came, when I tried to
> > create db with sip_router/scripts/mysql/ser_mysql.sh create. It
asked
> > for root password (i dont have any so I
pressed Enter right
away), but
> > then displayed mysql options (give
below) for me instead of
creating
> > DB. I suppose some argument went
missing. How can I fix it? I also
> > remember there was a manual way to do it, but I couldnt find a
proper
> > link. Can anyone help me, plz?
> >
> > Output:
> >
> > mysql Ver 14.12 Distrib 5.0.24a, for pc-linux-gnu (i486) using
readline 5.1
> > Copyright (C) 2002 MySQL AB
> > This software comes with ABSOLUTELY NO WARRANTY. This is free
software,
> > and you are welcome to modify and
redistribute it under the GPL
license
> > Usage: mysql [OPTIONS] [database]
> > -?, --help Display this help and exit.
> > -I, --help Synonym for -?
> > --auto-rehash Enable automatic rehashing. One doesn't
need
to use
> > 'rehash'
to get table and field
completion, but startup
> > and reconnecting
may take a longer time.
Disable with
> >
--disable-auto-rehash.
> > -A, --no-auto-rehash
> > No automatic rehashing. One has to use
'rehash' to get
> > table and field
completion. This gives a
quicker start of
> > mysql and
disables rehashing on
reconnect. WARNING:
> > options
deprecated; use
--disable-auto-rehash instead.
> > -B, --batch Don't use
history file. Disable
interactive behavior.
> > (Enables
--silent)
> > --character-sets-dir=name
> > Directory where character sets are.
> > --default-character-set=name
> > Set the default character set.
> > -C, --compress Use compression in server/client protocol.
> > -#, --debug[=#] This is a non-debug version. Catch this
and exit
> > -D, --database=name Database to use.
> > --delimiter=name Delimiter to be used.
> > -e, --execute=name Execute command and quit. (Disables
--force and
history
> > file)
> > -E, --vertical Print the output of a query (rows)
vertically.
> > -f, --force Continue even if
we get an sql error.
> > -g, --no-named-commands
> > Named commands are disabled. Use \* form
only, or
use
> > named commands
only in the beginning of a
line ending
> > with a semicolon
(;) Since version 10.9
the client now
> > starts with this
option ENABLED by
default! Disable with
> > '-G'.
Long format commands still work
from the first
> > line. WARNING:
option deprecated; use
> > --disable-named-commands instead.
> > -G, --named-commands
> > Enable named commands. Named commands
mean this
program's
> > internal
commands; see mysql> help . When
enabled, the
> > named commands
can be used from any line
of the query,
> > otherwise only
from the first line,
before an enter.
> > Disable with
--disable-named-commands.
This option is
> > disabled by
default.
> > -i, --ignore-spaces Ignore space after function names.
> > --local-infile Enable/disable LOAD DATA LOCAL INFILE.
> > -b, --no-beep Turn off beep on error.
> > -h, --host=name Connect to host.
> > -H, --html Produce HTML output.
> > -X, --xml Produce XML output
> > --line-numbers Write line numbers for errors.
> > -L, --skip-line-numbers
> > Don't write line number for errors.
WARNING:
-L is
> > deprecated, use
long version of this
option instead.
> > --no-pager Disable pager and
print to stdout. See
interactive help
> > (\h) also.
WARNING: option deprecated; use
> > --disable-pager instead.
> > --no-tee Disable outfile. See interactive help
(\h) also.
WARNING:
> > option
deprecated; use --disable-tee instead
> > -n, --unbuffered Flush buffer after each query.
> > --column-names Write column names in results.
> > -N, --skip-column-names
> > Don't write column names in results.
WARNING:
-N is
> > deprecated, use
long version of this
options instead.
> > -O, --set-variable=name
> > Change the value of a variable. Please
note that
this
> > option is
deprecated; you can set
variables directly with
> >
--variable-name=value.
> > --sigint-ignore Ignore SIGINT (CTRL-C)
> > -o, --one-database Only update the default database. This is
useful
for
> > skipping updates
to other database in the
update log.
> > --pager[=name] Pager to use to
display results. If you
don't supply an
> > option the
default pager is taken from
your ENV variable
> > PAGER. Valid
pagers are less, more, cat
[> filename],
> > etc. See
interactive help (\h) also. This
option does not
> > work in batch
mode.
> > -p, --password[=name]
> > Password to use when connecting to
server. If
password is
> > not given
it's asked from the tty.
WARNING: This is
> > insecure as the
password is visible for
anyone through
> > /proc for a short
time.
> > -P, --port=# Port number to use for connection.
> > --prompt=name Set the mysql prompt to this value.
> > --protocol=name The protocol of connection
(tcp,socket,pipe,memory).
> > -q, --quick Don't cache
result, print it row by row.
This may slow
> > down the server
if the output is
suspended. Doesn't use
> > history file.
> > -r, --raw Write fields without conversion. Used
with
--batch.
> > --reconnect Reconnect if the
connection is lost.
Disable with
> >
--disable-reconnect. This option is
enabled by default.
> > -s, --silent Be more silent.
Print results with a tab
as separator,
> > each row on new
line.
> > -S, --socket=name Socket file to use for connection.
> > --ssl Enable SSL for connection (automatically
enabled
with
> > other flags).
Disable with --skip-ssl.
> > --ssl-ca=name CA file in PEM format (check OpenSSL
docs,
implies
> > --ssl).
> > --ssl-capath=name CA directory (check OpenSSL docs, implies
--ssl).
> > --ssl-cert=name X509 cert in PEM
format (implies --ssl).
> > --ssl-cipher=name SSL cipher to use (implies --ssl).
> > --ssl-key=name X509 key in PEM format (implies --ssl).
> > --ssl-verify-server-cert
> > Verify server's "Common Name" in its cert
against
> > hostname used
when connecting. This
option is disabled by
> > default.
> > -t, --table Output in table format.
> > -T, --debug-info Print some debug info at exit.
> > --tee=name Append everything into outfile. See
interactive
help (\h)
> > also. Does not
work in batch mode.
> > -u, --user=name User for login if not current user.
> > -U, --safe-updates Only allow UPDATE and DELETE that uses keys.
> > -U, --i-am-a-dummy Synonym for option --safe-updates, -U.
> > -v, --verbose Write more. (-v -v -v gives the table
output
format).
> > -V, --version Output version
information and exit.
> > -w, --wait Wait and retry if connection is down.
> > --connect_timeout=# Number of seconds before connection timeout.
> > --max_allowed_packet=#
> > Max packet length to send to, or receive
from
server
> > --net_buffer_length=#
> > Buffer for TCP/IP and socket communication
> > --select_limit=# Automatic limit for SELECT when using
--safe-updates
> > --max_join_size=# Automatic limit
for rows in a join when
using
> > --safe-updates
> > --secure-auth Refuse client connecting to server if it
uses
old
> > (pre-4.1.1)
protocol
> > --show-warnings Show warnings after every statement.
> >
> > Default options are read from the following files in the given
order:
> > /etc/mysql/my.cnf ~/.my.cnf
/etc/mysql/my.cnf
> > The following groups are read: mysql client
> > The following options may be given as the first argument:
> > --print-defaults Print the program argument list and exit
> > --no-defaults Don't read default options from any
options
file
> > --defaults-file=# Only read
default options from the
given file #
> > --defaults-extra-file=# Read this file
after the global files
are read
>
> Variables (--variable-name=value)
> and boolean options {FALSE|TRUE} Value (after reading options)
> --------------------------------- -----------------------------
> auto-rehash TRUE
> character-sets-dir (No default value)
> default-character-set latin1
> compress FALSE
> database (No default value)
> delimiter ;
> vertical FALSE
> force FALSE
> named-commands FALSE
> local-infile FALSE
> no-beep FALSE
> host localhost
> html FALSE
> xml FALSE
> line-numbers TRUE
> unbuffered FALSE
> column-names TRUE
> sigint-ignore FALSE
> port 3306
> prompt mysql>
> quick FALSE
> raw FALSE
> reconnect FALSE
> socket /var/run/mysqld/mysqld.sock
> ssl FALSE
> ssl-ca (No default value)
> ssl-capath (No default value)
> ssl-cert (No default value)
> ssl-cipher (No default value)
> ssl-key (No default value)
> ssl-verify-server-cert FALSE
> table FALSE
> debug-info FALSE
> user root
> safe-updates FALSE
> i-am-a-dummy FALSE
> connect_timeout 0
> max_allowed_packet 16777216
> net_buffer_length 16384
> select_limit 1000
> max_join_size 1000000
> secure-auth FALSE
> show-warnings FALSE
>
>
> Andrey.
> _______________________________________________
> Serusers mailing list
> Serusers(a)lists.iptel.org
>
http://lists.iptel.org/mailman/listinfo/serusers
>
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org