[Serusers] Problems creating DB in SER Ottendorf
Greger V. Teigre
greger at teigre.com
Mon Mar 5 08:19:33 CET 2007
Not allowing empty root password may be a feature, not a bug... ;-)
But an error message would probably be appropriate.
samuel wrote:
> 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 at gmail.com>:
>> Thanks a lot! That worked out just fine :)
>>
>> On 2/28/07, Andrey Kuprianov <andrey.kouprianov at gmail.com> wrote:
>> > I see.. let me try
>> >
>> > On 2/28/07, samuel <samu60 at 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 at gmail.com>:
>> > > > 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 at lists.iptel.org
>> > > > http://lists.iptel.org/mailman/listinfo/serusers
>> > > >
>> > >
>> >
>> _______________________________________________
>> Serusers mailing list
>> Serusers at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
>
More information about the sr-users
mailing list