<html><div style='background-color:'><P class=RTE>Hi, thanks for your help. I did what you said but I get an error:<BR><BR></P>
<DIV class=RTE>[root@pclabo mysql]# mysql<BR>Welcome to the MySQL monitor. Commands end with ; or \g.<BR>Your MySQL connection id is 1119 to server version: 4.1.9-standard</DIV>
<DIV class=RTE>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.</DIV>
<DIV class=RTE>mysql> USE mysql;<BR>Reading table information for completion of table and column names<BR>You can turn off this feature to get a quicker startup with -A</DIV>
<DIV class=RTE>Database changed<BR>mysql> delete from user where user='ser';<BR>Query OK, 2 rows affected (0.11 sec)</DIV>
<DIV class=RTE>mysql> INSERT INTO user VALUES('%','ser',PASSWORD('helso'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');<BR>ERROR 1136 (21S01): Column count doesn't match value count at row 1<BR>mysql> INSERT INTO user VALUES('%','ser',PASSWORD('heslo'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');<BR>ERROR 1136 (21S01): Column count doesn't match value count at row 1<BR>mysql> INSERT INTO user VALUES('localhost','ser',PASSWORD('heslo'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); <BR>ERROR 1136 (21S01): Column count doesn't match value count at row 1<BR>mysql> <BR><BR>I don't understand this error!! Please help,</DIV>
<DIV class=RTE>Llanos<BR><BR>>hi,<BR>>it seems the password or user profile problem<BR>><BR>>do this<BR>><BR>><BR>>USE mysql;<BR>><BR>>delete from user where user='ser';<BR>><BR>>( It will delete 2 records)<BR>><BR>>Then insert agin ...............<BR>><BR>><BR>><BR>>INSERT INTO user VALUES('%','ser',PASSWORD('helso'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');<BR>><BR>>INSERT INTO user VALUES('localhost','ser',PASSWORD('helso'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');<BR>><BR>><BR>><BR>>FLUSH PRIVILEGES;<BR>><BR>><BR>>Llanos Serna García-Conde <llanosserna@hotmail.com> wrote:<BR>>Hi all, I'm trying to see the serweb logging screen but I get the following error:<BR>><BR>>Warning: Client does not support authentication protocol requested by server; consider upgrading
MySQL client in /var/www/html/serweb/serweb_2004-07-27/phplib/db_mysql.inc on line 73<BR>>Database error: pconnect(localhost, ser, $Password) failed.<BR>>MySQL Error: ()<BR>>Session halted.<BR>><BR>>My Mysql version is 4.1.9.<BR>><BR>>My /etc/hosts:<BR>>127.0.0.1 pclabo localhost.localdomain localhost<BR>>172.25.97.19 sipproxy.plczar.endesa.es sipproxy<BR>><BR>>In ser_mysql.sh, db_mysql.inc and config.php:<BR>>DBNAME ser<BR>>DBHOST localhost<BR>>USER ser<BR>>PW heslo<BR>><BR>>I can connect to the database in either of these ways:<BR>> > mysql -u ser -p<BR>>Enter password: heslo<BR>><BR>>or<BR>><BR>> >mysql -h 172.25.97.19 -u
ser -p<BR>>Enter password: heslo<BR>><BR>>From another machine I can also connect to the DB with the Mysql Query Browser:<BR>>Server Host: 172.25.97.19<BR>>Username: ser<BR>>Password: heslo<BR>><BR>>What's the problem? Any ideas?<BR>>Thank you<BR>>Llanos<BR>><BR>>_______________________________________________<BR>>Serusers mailing list<BR>>serusers@lists.iptel.org<BR>>http://lists.iptel.org/mailman/listinfo/serusers<BR>><BR>><BR>>---------------------------------<BR>>Yahoo! Mail Mobile<BR>> Take Yahoo! Mail with you! Check email on your mobile phone.<BR></DIV></div></html>