[Users] bug in openser_mysql.sh script - sr-users - kamailio.org

List overview All Threads
Download

[Users] bug in openser_mysql.sh script

[Serusers] nathelper/rtpproxy/MOH

[Serusers] ser compile error

Dave

4 Jul 2005 4 Jul '05

3:12 p.m.

Seems there is a bug in the openser_mysql.sh script. Running it screws up that root password in mysql and changes it to "openserrw". It also does not create a user "openserrw". Deepak __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Attachments:

attachment.html (text/html — 389 bytes)

Reply

Show replies by date

Daniel-Constantin Mierla

4 Jul 4 Jul

3:33 p.m.

Hello, On 07/04/05 15:12, Dave wrote:

Seems there is a bug in the openser_mysql.sh script. Running it screws up that root password in mysql and changes it to "openserrw". It also does not create a user "openserrw".

I have tested and for me everything seems to be ok. root password is the same. The username that should be created is "openser" and password is "openserrw". Do you have an environment variable "USERNAME" set to "root"? Daniel

Deepak __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------------------ _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

Reply

Dave

3:48 p.m.

Strange. I ran the script twice and got the same results. Yes, since I am loggeds in as root, environment variable USERNAME is automatically set to root. "openser" user in the database is never created. For now I have manually fixed the problem. Thx Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote: Hello, On 07/04/05 15:12, Dave wrote:

Seems there is a bug in the openser_mysql.sh script. Running it screws up that root password in mysql and changes it to "openserrw". It also does not create a user "openserrw".

I have tested and for me everything seems to be ok. root password is the same. The username that should be created is "openser" and password is "openserrw". Do you have an environment variable "USERNAME" set to "root"? Daniel

Deepak __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------------------ _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Reply

Daniel-Constantin Mierla

3:57 p.m.

On 07/04/05 15:48, Dave wrote:

Strange. I ran the script twice and got the same results. Yes, since I am loggeds in as root, environment variable USERNAME is automatically set to root.

This is the problem, the script uses a variable named USERNAME and before setting it to "openser" checks if it is already set. What distribution do you use? In debian $USER is set to local user id. I will change the name of this variable. You can create a ".opensermysqlrc" file in your home directory and put there: USERNAME="openser" Daniel

"openser" user in the database is never created. For now I have manually fixed the problem. Thx */Daniel-Constantin Mierla <daniel(a)voice-system.ro>/* wrote: Hello, On 07/04/05 15:12, Dave wrote:

Seems there is a bug in the openser_mysql.sh script. Running it

screws

up that root password in mysql and changes it to "openserrw". It

also

does not create a user "openserrw".

I have tested and for me everything seems to be ok. root password is the same. The username that should be created is "openser" and password is "openserrw". Do you have an environment variable "USERNAME" set to "root"? Daniel

Deepak __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------------------ _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------------------ _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

Reply

Dave

3:59 p.m.

That explains it :) I am using Redhat Enterprise Server ES. Thx Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote: On 07/04/05 15:48, Dave wrote:

Strange. I ran the script twice and got the same results. Yes, since I am loggeds in as root, environment variable USERNAME is automatically set to root.

This is the problem, the script uses a variable named USERNAME and before setting it to "openser" checks if it is already set. What distribution do you use? In debian $USER is set to local user id. I will change the name of this variable. You can create a ".opensermysqlrc" file in your home directory and put there: USERNAME="openser" Daniel

"openser" user in the database is never created. For now I have manually fixed the problem. Thx */Daniel-Constantin Mierla /* wrote: Hello, On 07/04/05 15:12, Dave wrote:

Seems there is a bug in the openser_mysql.sh script. Running it

screws

up that root password in mysql and changes it to "openserrw". It

also

does not create a user "openserrw".

I have tested and for me everything seems to be ok. root password is the same. The username that should be created is "openser" and password is "openserrw". Do you have an environment variable "USERNAME" set to "root"? Daniel

Deepak __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------------------ _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------------------ _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Reply

7084

days inactive

7084

days old

sr-users@lists.kamailio.org

Manage subscription

4 comments

2 participants

tags (0)

participants (2)

Daniel-Constantin Mierla
Dave