Updated. ** Summary changed:
- knetworkmanager doesn't create loopback interface in manual mode + knetworkmanager stays in manual mode after using manual mode once ** Description changed: - /var/log/daemon.log: - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: To do so, start the server, then issue the following commands: - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: /usr/bin/mysqladmin -u root password 'new-password' - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: /usr/bin/mysqladmin -u root -h rvroede-laptop password 'new-password' - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: See the manual for more instructions. - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: Please report any problems with the /usr/bin/mysqlbug script! - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: The latest information about MySQL is available on the web at - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: http://www.mysql.com - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: Support MySQL by buying support/licenses at http://shop.mysql.com - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]: ERROR: 1046 No database selected - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]: 071016 10:17:07 [ERROR] Aborting - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]: - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]: 071016 10:17:07 [Note] /usr/sbin/mysqld: Shutdown complete - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]: - Oct 16 10:17:07 rvroede-laptop mysqld_safe[24310]: started - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: The first specified data file ./ibdata1 did not exist: - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: a new database to be created! - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 InnoDB: Setting file ./ibdata1 size to 10 MB - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Database physically writes the file full: wait... - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 InnoDB: Log file ./ib_logfile0 did not exist: new to be created - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Database physically writes the file full: wait... - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 InnoDB: Log file ./ib_logfile1 did not exist: new to be created - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Database physically writes the file full: wait... - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Doublewrite buffer not found: creating new - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Doublewrite buffer created - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Creating foreign key constraint system tables - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Foreign key constraint system tables created - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 InnoDB: Started; log sequence number 0 0 - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 [ERROR] Do you already have another mysqld server running on port: 3306 ? - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 [ERROR] Aborting - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: - Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 InnoDB: Starting shutdown... - Oct 16 10:17:10 rvroede-laptop mysqld[24313]: 071016 10:17:10 InnoDB: Shutdown completed; log sequence number 0 43655 - Oct 16 10:17:10 rvroede-laptop mysqld[24313]: 071016 10:17:10 [Note] /usr/sbin/mysqld: Shutdown complete - Oct 16 10:17:10 rvroede-laptop mysqld[24313]: - Oct 16 10:17:10 rvroede-laptop mysqld_safe[24340]: ended - - netstat -apn | grep 3306 is empty, so the port is free. - - Running from the commandline, I found this: - [EMAIL PROTECTED]:~# /usr/sbin/mysqld --print-defaults - /usr/sbin/mysqld would have been started with the following arguments: - --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp --language=/usr/share/mysql/english --skip-external-locking --bind-address=127.0.0.1 --key_buffer=16M --max_allowed_packet=16M --thread_stack=128K --thread_cache_size=8 --query_cache_limit=1M --query_cache_size=16M --log_bin=/var/log/mysql/mysql-bin.log --expire_logs_days=10 --max_binlog_size=100M --skip-bdb --old_passwords=false - [EMAIL PROTECTED]:~# /usr/sbin/mysqld --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp --language=/usr/share/mysql/english --skip-external-locking --bind-address=127.0.0.1 --key_buffer=16M --max_allowed_packet=16M --thread_stack=128K --thread_cache_size=8 --query_cache_limit=1M --query_cache_size=16M --log_bin=/var/log/mysql/mysql-bin.log --expire_logs_days=10 --max_binlog_size=100M --skip-bdb --old_passwords=false - 071016 10:30:52 InnoDB: Started; log sequence number 0 43655 - 071016 10:30:52 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address - 071016 10:30:52 [ERROR] Do you already have another mysqld server running on port: 3306 ? - 071016 10:30:52 [ERROR] Aborting - - 071016 10:30:52 InnoDB: Starting shutdown... - 071016 10:30:54 InnoDB: Shutdown completed; log sequence number 0 43655 - 071016 10:30:54 [Note] /usr/sbin/mysqld: Shutdown complete - - Again that error. I changed the port to 3307, but it gave the same - error, now for 3307. - - Good old strace gave me: - bind(13, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 EADDRNOTAVAIL (Cannot assign requested address) - - So I commented out "bind-address = 127.0.0.1" in - /etc/mysql/my.cnf and it starts. - - ProblemType: Package - Architecture: i386 - Date: Tue Oct 16 10:17:22 2007 - DistroRelease: Ubuntu 7.10 - ErrorMessage: dependency problems - leaving unconfigured - NonfreeKernelModules: nvidia - Package: mysql-server 5.0.45-1ubuntu3 - PackageArchitecture: all - SourcePackage: mysql-dfsg-5.0 - Title: package mysql-server 5.0.45-1ubuntu3 failed to install/upgrade: dependency problems - leaving unconfigured - Uname: Linux rvroede-laptop 2.6.22-14-generic #1 SMP Wed Oct 10 06:00:47 GMT 2007 i686 GNU/Linux + After I set my network with knetworkmanager to manual, I tried to put it back to automatic by setting the interface to DHCP. However, it stayed in manual mode. I found a hint on the internet somewhere that I should (re)move /etc/network/interfaces and reboot. And indeed, it was fixed, knetworkmanager was automatic again. + Later, I installed MySQL-server and had a lot of trouble with starting it. I found out that the loopback interface didn't exist. So I put back the /etc/network/interfaces file and rebooted. I had a loopback device again. However, knetworkmanager is on manual mode again. -- knetworkmanager stays in manual mode after using manual mode once https://bugs.launchpad.net/bugs/153217 You received this bug notification because you are a member of Kubuntu Team, which is a bug contact for knetworkmanager in ubuntu. -- kubuntu-bugs mailing list [EMAIL PROTECTED] https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
