I didn't see this posted on any of the threads, but I was wondering if someone could help me out with it. I have the MySQL database up and running on a Linux box. Client Linux machines that uses libnss-mysql to query this database works with no problems.
However, when I compiled libnss onto a Solaris 10 Sparc machine, I get this message:
$ id cinergi
Apr 28 09:38:52 solclient id[27223]: [ID 801593 user.alert] libnss-mysql: mysql_query failed: Unknown column 'age' in 'field list', trying again (2)
Apr 28 09:38:52 solclient id[27223]: [ID 801593 user.alert] libnss-mysql: mysql_query failed: Unknown column 'age' in 'field list', trying again (1)
id: invalid user name: "cinergi"
Apr 28 09:38:52 solclient id[27223]: [ID 801593 user.alert] libnss-mysql: mysql_query failed: Unknown column 'age' in 'field list'
When I copy the libnss-mysql.cfg from the working Linux clients, I get this:
$ id cinergi
id: invalid user name: "cinergi"
Apr 28 10:40:03 solclient id[27254]: [ID 801593 user.alert] libnss-mysql: mysql_fetch_row() found 7 rows (expecting 9).
If I use the MySQL client from the Solaris box to connect directly to the database, I get no problems. I can see the data structure.
Has anyone ran into this problem and does anyone have a fix or solution?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yup! The solution is actually your database design and queries. You need to create a database that provides the information you need for both Linux and Solaris. Solaris has a few fields that Linux does not. If, however, those special solaris fields are all the same, then your database doesn't need to change, just your Solaris configuration. For example, the Linux database doesn't have the 'age' column, so instead of selecting 'age', select a static number. Alternatively, add 'add' to the database user table. Let me know if you need more details.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I didn't see this posted on any of the threads, but I was wondering if someone could help me out with it. I have the MySQL database up and running on a Linux box. Client Linux machines that uses libnss-mysql to query this database works with no problems.
However, when I compiled libnss onto a Solaris 10 Sparc machine, I get this message:
$ id cinergi
Apr 28 09:38:52 solclient id[27223]: [ID 801593 user.alert] libnss-mysql: mysql_query failed: Unknown column 'age' in 'field list', trying again (2)
Apr 28 09:38:52 solclient id[27223]: [ID 801593 user.alert] libnss-mysql: mysql_query failed: Unknown column 'age' in 'field list', trying again (1)
id: invalid user name: "cinergi"
Apr 28 09:38:52 solclient id[27223]: [ID 801593 user.alert] libnss-mysql: mysql_query failed: Unknown column 'age' in 'field list'
When I copy the libnss-mysql.cfg from the working Linux clients, I get this:
$ id cinergi
id: invalid user name: "cinergi"
Apr 28 10:40:03 solclient id[27254]: [ID 801593 user.alert] libnss-mysql: mysql_fetch_row() found 7 rows (expecting 9).
If I use the MySQL client from the Solaris box to connect directly to the database, I get no problems. I can see the data structure.
Has anyone ran into this problem and does anyone have a fix or solution?
Yup! The solution is actually your database design and queries. You need to create a database that provides the information you need for both Linux and Solaris. Solaris has a few fields that Linux does not. If, however, those special solaris fields are all the same, then your database doesn't need to change, just your Solaris configuration. For example, the Linux database doesn't have the 'age' column, so instead of selecting 'age', select a static number. Alternatively, add 'add' to the database user table. Let me know if you need more details.