Hi, I have just downloaded and installed libnss-mysql 0.9 but am getting segfaults when I try to su or ssh to a user in the database.
After some testing using getent I have discovered that it happens on shadow when I have fields that return null.
I am trying to achieve something along the lines of test:$1$haw/ZY.1$C9J7XcACqNYAkD1srTxa41:12242:0:99999:7:::
Can anyone make any suggestions as to what I should use for the last 3 fields? I am running mySQL 4 on an LFS system
Cheers
The sample database leaves sets it up as
username:pw:1:0:99999:0:0::0
Perhaps a zero after the 7 and a zero at the end will do the trick? I also don't use NULLs in the database.
+----------+---------------+--------+-----+-------+------+-------+--------+------+ | username | password | lstchg | min | max | warn | inact | expire | flag | +----------+---------------+--------+-----+-------+------+-------+--------+------+ | cinergi | 14UTHWYPCJAgg | 1 | 0 | 99999 | 0 | 0 | -1 | 0 | +----------+---------------+--------+-----+-------+------+-------+--------+------+
mysql> describe users; +----------+---------------------+------+-----+-----------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+---------------------+------+-----+-----------+----------------+ | username | varchar(16) | | MUL | | | | uid | int(11) | | PRI | NULL | auto_increment | | gid | int(11) | | | 5000 | | | gecos | varchar(128) | | | | | | homedir | varchar(255) | | | | | | shell | varchar(64) | | | /bin/bash | | | password | varchar(34) | | | x | | | lstchg | bigint(20) | | | 1 | | | min | bigint(20) | | | 0 | | | max | bigint(20) | | | 99999 | | | warn | bigint(20) | | | 0 | | | inact | bigint(20) | | | 0 | | | expire | bigint(20) | | | -1 | | | flag | bigint(20) unsigned | | | 0 | | +----------+---------------------+------+-----+-----------+----------------+ 14 rows in set (0.02 sec)
Log in to post a comment.
Hi, I have just downloaded and installed libnss-mysql 0.9 but am getting segfaults when I try to su or ssh to a user in the database.
After some testing using getent I have discovered that it happens on shadow when I have fields that return null.
I am trying to achieve something along the lines of test:$1$haw/ZY.1$C9J7XcACqNYAkD1srTxa41:12242:0:99999:7:::
Can anyone make any suggestions as to what I should use for the last 3 fields? I am running mySQL 4 on an LFS system
Cheers
The sample database leaves sets it up as
username:pw:1:0:99999:0:0::0
Perhaps a zero after the 7 and a zero at the end will do the trick? I also don't use NULLs in the database.
+----------+---------------+--------+-----+-------+------+-------+--------+------+
| username | password | lstchg | min | max | warn | inact | expire | flag |
+----------+---------------+--------+-----+-------+------+-------+--------+------+
| cinergi | 14UTHWYPCJAgg | 1 | 0 | 99999 | 0 | 0 | -1 | 0 |
+----------+---------------+--------+-----+-------+------+-------+--------+------+
mysql> describe users;
+----------+---------------------+------+-----+-----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------------------+------+-----+-----------+----------------+
| username | varchar(16) | | MUL | | |
| uid | int(11) | | PRI | NULL | auto_increment |
| gid | int(11) | | | 5000 | |
| gecos | varchar(128) | | | | |
| homedir | varchar(255) | | | | |
| shell | varchar(64) | | | /bin/bash | |
| password | varchar(34) | | | x | |
| lstchg | bigint(20) | | | 1 | |
| min | bigint(20) | | | 0 | |
| max | bigint(20) | | | 99999 | |
| warn | bigint(20) | | | 0 | |
| inact | bigint(20) | | | 0 | |
| expire | bigint(20) | | | -1 | |
| flag | bigint(20) unsigned | | | 0 | |
+----------+---------------------+------+-----+-----------+----------------+
14 rows in set (0.02 sec)