OS: BSDI BSD/OS 4.1 i386
This system is fully patched from M410-001 to M410-011
System Specs: Dual Pentium III 500 256MB ram
IN client/get_password.c file. At line 148 (just before
DBUG_RETURN(my_strdup(buff, ...));), I added the following line
fprintf(stderr, ">>>DEBUG: PASSWORD ENTERED IS '%s'<<<\n", buff);
Then compiled mysql with the following
./confiugre --prefix=/export/mysql --enable-large-files
--with-mysqld-user=mysqld --with-debug --without-docs --without-bench
It builds fine and install ok now i start the server with the following
command, from the cmmand line
# ./mysqld --debug=d,info,error,query,general,where:O,/tmp/mysql.trace &
[1] 8271
Now I shall reinstall my db. bash-2.02# ./mysqladmin create
fertilethoughts
Database "fertilethoughts" created.
bash-2.02# cat fertile.sql | ./mysql fertilethoughts
The first thing I notice which always happens is
[1]+ Abort trap (core dumped) ./mysqld
--debug=d,info,error,query,general,where:O,/tmp/mysql.trace (wd:
/export/mysql/libexec)
In my /mysql.trace file the last thing message printed was
do_command: general: Command on socket 6 = 1 (Quit)
Be sides all of the the entire DB was installed all the content is there
etc..
so I once again start up mysql
/mysqld --debug=d,info,error,query,general,where:O,/tmp/mysql.trace &
[1] 8328
bash-2.02# ./mysqld: ready for connections
Now The another weird problem happens right now Im able to connect to the
db via localhost as root, the moment I set root's password I cannot no
longer login via localhost and must use -h <domainname.com>
./mysqladmin password xxxxxxxxxxxx
./mysql -u root -p
Enter password:
>>>DEBUG: PASSWORD ENTERED IS 'xxxxxxxxxxxxxxx'<<<
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
// Note why is it saying (Using passowrd: NO)
bash-2.02# ./mysql -u root -hwww2.yrd.com -p
Enter password:
>>>DEBUG: PASSWORD ENTERED IS 'xxxxxxxxxxxxxx'<<<
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.22.32-debug
Type 'help' for help.
mysql>
This is were the problems starts now lets create a user,
mysql> insert into user
values("localhost","fertileweb",password("changemealso"),"Y","Y","Y","Y","N","N","N","N","N","N","N","N","N","N");
Query OK, 1 row affected (0.03 sec)
mysql> quit bash-2.02# ./mysqladmin -u root -hwww2.yrd.com -p reload
Enter password:
>>>DEBUG: PASSWORD ENTERED IS 'xxxxxxxxx'<<<
#
ok now lets try to login as the user fertileweb I created
bash-2.02# ./mysql -u fertileweb -p
Enter password:
>>>DEBUG: PASSWORD ENTERED IS 'changemealso'<<<
ERROR 1045: Access denied for user: 'fertileweb@localhost' (Using
password: NO)
The part that flips me out is the (Using password: NO) part
If I specify -h <domainname> I log in fine.
Here is one more bug. Lets try to give the user fertileweb access to the
database fertilethoughts and have him connect with -h<FQDN>
mysql> insert into db
values("%","fertilethoughts","fertileweb","Y","Y","Y","Y","N","N","N","N","N","N");
Query OK, 1 row affected (0.00 sec);
# ./mysqladmin -u root -hwww2.yrd.com -p reload
bash-2.02# ./mysql -u fertileweb -hwww2.yrd.com -p fertilethoughts
Enter password:
>>>DEBUG: PASSWORD ENTERED IS 'changemealso'<<<
ERROR 1044: Access denied for user: '@www2.yrd.com' to database
'fertilethoughts'
See thats the problems im having on BSDI 4.1 I have many other machines
running mysql I have a bsdi 4.0.1 machien and a couple freebsd machines
running fine w/o any problems.
HEre is the output from my /tmp/mysql.trace
?func: general: New connection received on 6
?func: general: Host: www2.yrd.com ip: 160.79.99.20
?func: info: raw_net_read returned -1, errno: 35
create_new_thread: info: Thread created
?func: general: Capabilities: 133 packet_length: 8388608 Host:
www2.yrd.com User: root Using password: no Access: 16383 db:
do_command: info: raw_net_read returned -1, errno: 35
do_command: general: Command on socket 6 = 7 (Refresh)
init_read_record: info: using rr_sequential
init_read_record: info: using rr_sequential
init_read_record: info: using rr_sequential
ha_rfirst: error: my_errno: 137
do_command: info: raw_net_read returned -1, errno: 35
do_command: general: Command on socket 6 = 1 (Quit)
?func: general: New connection received on 6
?func: general: Host: www2.yrd.com ip: 160.79.99.20
?func: info: raw_net_read returned -1, errno: 35
create_new_thread: info: Thread created
?func: general: Capabilities: 1157 packet_length: 8388608 Host:
www2.yrd.com User: Using password: no Access: 0 db:
do_command: info: raw_net_read returned -1, errno: 35
do_command: general: Command on socket 6 = 3 (Query)
do_command: query: show databases
do_command: info: query ready
do_command: info: raw_net_read returned -1, errno: 35
do_command: general: Command on socket 6 = 3 (Query)
do_command: query: show tables
do_command: info: query ready
do_command: info: raw_net_read returned -1, errno: 35
do_command: general: Command on socket 6 = 2 (Init DB)
mysql_change_db: general: Use database: fertilethoughts
do_command: info: raw_net_read returned -1, errno: 35
do_command: general: Command on socket 6 = 1 (Quit)
?func: general: New connection received on 6
?func: general: Host: www2.yrd.com ip: 160.79.99.20
?func: info: raw_net_read returned -1, errno: 35
create_new_thread: info: Thread created
?func: general: Capabilities: 1165 packet_length: 8388608 Host:
www2.yrd.com User: Using password: no Access: 0 db: fertilethoughts
mysql_change_db: general: Use database: fertilethoughts
Misc: Info:
grep localhost /etc/hosts
127.1 localhost
127.0.0.1 localhost
# nslookup localhost
Server: ns1.yard.net
Address: 160.79.99.6
Name: localhost
Address: 127.0.0.1
bash-2.02# nslookup 127.0.0.1
Server: ns1.yard.net
Address: 160.79.99.6
Name: localhost
Address: 127.0.0.1
I have also attached my mysql database.
Please im in desperate need for help.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. (0~0) Rodrick Brown (CCNA) Systems/Network Administrator .
. --ooO-(_)-Ooo- rodrick@stripped Yard Productions www.yrd.com .
. 212 West 35th St 7th AVE 212 244-5540 Real Time VideoBroadCasting .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
# MySQL dump 7.1
#
# Host: www2.yrd.com Database: mysql
#--------------------------------------------------------
# Server version 3.22.32-debug
#
# Table structure for table 'columns_priv'
#
CREATE TABLE columns_priv (
Host char(60) DEFAULT '' NOT NULL,
Db char(60) DEFAULT '' NOT NULL,
User char(16) DEFAULT '' NOT NULL,
Table_name char(60) DEFAULT '' NOT NULL,
Column_name char(60) DEFAULT '' NOT NULL,
Timestamp timestamp(14),
Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,
PRIMARY KEY (Host,Db,User,Table_name,Column_name)
);
#
# Dumping data for table 'columns_priv'
#
#
# Table structure for table 'db'
#
CREATE TABLE db (
Host char(60) DEFAULT '' NOT NULL,
Db char(32) DEFAULT '' NOT NULL,
User char(16) DEFAULT '' NOT NULL,
Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,
References_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,
PRIMARY KEY (Host,Db,User),
KEY User (User)
);
#
# Dumping data for table 'db'
#
INSERT INTO db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
INSERT INTO db VALUES ('%','test\\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
INSERT INTO db VALUES ('%','fertilethoughts','fertileweb','Y','Y','Y','Y','N','N','N','N','N','N');
#
# Table structure for table 'func'
#
CREATE TABLE func (
name char(64) DEFAULT '' NOT NULL,
ret tinyint(1) DEFAULT '0' NOT NULL,
dl char(128) DEFAULT '' NOT NULL,
type enum('function','aggregate') DEFAULT 'function' NOT NULL,
PRIMARY KEY (name)
);
#
# Dumping data for table 'func'
#
#
# Table structure for table 'host'
#
CREATE TABLE host (
Host char(60) DEFAULT '' NOT NULL,
Db char(32) DEFAULT '' NOT NULL,
Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,
References_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,
PRIMARY KEY (Host,Db)
);
#
# Dumping data for table 'host'
#
#
# Table structure for table 'tables_priv'
#
CREATE TABLE tables_priv (
Host char(60) DEFAULT '' NOT NULL,
Db char(60) DEFAULT '' NOT NULL,
User char(16) DEFAULT '' NOT NULL,
Table_name char(60) DEFAULT '' NOT NULL,
Grantor char(77) DEFAULT '' NOT NULL,
Timestamp timestamp(14),
Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL,
Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,
PRIMARY KEY (Host,Db,User,Table_name),
KEY Grantor (Grantor)
);
#
# Dumping data for table 'tables_priv'
#
#
# Table structure for table 'user'
#
CREATE TABLE user (
Host char(60) DEFAULT '' NOT NULL,
User char(16) DEFAULT '' NOT NULL,
Password char(16) DEFAULT '' NOT NULL,
Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Reload_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Shutdown_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Process_priv enum('N','Y') DEFAULT 'N' NOT NULL,
File_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,
References_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,
PRIMARY KEY (Host,User)
);
#
# Dumping data for table 'user'
#
INSERT INTO user VALUES ('localhost','root','67c53cea5997c66e','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES ('www2.yrd.com','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES ('localhost','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO user VALUES ('www2.yrd.com','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO user VALUES ('localhost','fertileweb','69dfcdad4ee5d478','Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N');
