Re: mySQL and 'testing'
On Fri, 2007-10-26 at 18:33, Jeff D wrote: ieb wrote: Sorry if this repeats a previous query I did scan the list of topics but couldn't spot this. I am running the 'testing' version. I came back from 3 weeks offline and simply let synaptic gather all the updates and apply them (OK.. yes , that was probably a bit dumb... but too late now)... Everything seemed to go ok until I went to log in to mySQL. and it cant find the socket. I tried to update the files using the mysql-client and mysql-server, and although the client ran OK the server complains about an unspecified dependency error and a corrupt server file. Has anyone else come across this, or should I start panicking now? Thanks Ian Are the errors with the server reported through synaptic or when you try to start the server? Have you tried to resolve the dependancies with synaptic? And could you also post the error messages you get? Thx, Jeff Hi Jeff, sorry for the delay in responding Are the errors with the server reported through synaptic or when you try to start the server? Both. It began with me firing up mysql-navigator... it started OK and showed the option to connect to the localhost - but when I tried to connect to the db it reported: Cannot connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'[2] So I, somewhat simplistically, presumed that one of the many dozens of updates that ran after my period away from my desk had screwed-up MySQL. Because this is a relatively new machine with only small volumes of data in the databases (which I could reconstruct if 'push came to shove') I decided to simply reinstall MySQL. The client seems to install OK using Synaptic but when it gets to the server Synaptic baulks and reports :- E:mysql-server-5.0: sub-process post-installation script returned error exit status 1 E: mysql server: dependency problems - leaving unconfigured My biggest problem is that I am still unfamiliar with where all the logs and programmes are maintained/held in Linux, so my investigations tend to consist of repeatedly lurching from one wild idea to the next in the forlorn hope of gathering a clue as to the root of the problem (rather than having the detail knowledge necessary for any systematic probing and fault identification). Therefore any help/advice is gratefully received. Ian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: mySQL and 'testing'
On 10/27/2007 06:15 AM, ieb wrote: [...] E:mysql-server-5.0: sub-process post-installation script returned error exit status 1 E: mysql server: dependency problems - leaving unconfigured My biggest problem is that I am still unfamiliar with where all the logs and programmes are maintained/held in Linux, so my investigations tend to consist of repeatedly lurching from one wild idea to the next [...] Look at the logs in /var/log, e.g. /var/log/mysql.log /var/log/messages /var/log/syslog and possibly others. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: mySQL and 'testing'
'Problem' has been solved. The clue was in 'syslog' it recorded that MySQl had been unable to open the directory /home////Database because it was too full. Now with a 500gig drive in this box and 250gig on my 'home' directory and only 7% used it couldn't possibly be 'too full'. On taking a look I spotted that somehow the directory (and all it's siblings at that same level) were no longer made up of titles that began with a single upper case and the rest in lower case .. but were all upper case (viz --- Database was now DATABASE) renamed it back to the original and reran the installation through synaptic, ... and it ran flawlessly and my data is still intact. I am being verbose in my explanation in case anyone else comes across a similar issue. Why the directories at that level (seven of them) became renamed to all upper case is the bigger mystery but as the original problem has been 'cured' my plea for assistance has been fulfilled. Thanks folks. Ian On Sat, 2007-10-27 at 16:00, Mumia W.. wrote: On 10/27/2007 06:15 AM, ieb wrote: [...] E:mysql-server-5.0: sub-process post-installation script returned error exit status 1 E: mysql server: dependency problems - leaving unconfigured -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
mySQL and 'testing'
Sorry if this repeats a previous query I did scan the list of topics but couldn't spot this. I am running the 'testing' version. I came back from 3 weeks offline and simply let synaptic gather all the updates and apply them (OK.. yes , that was probably a bit dumb... but too late now)... Everything seemed to go ok until I went to log in to mySQL. and it cant find the socket. I tried to update the files using the mysql-client and mysql-server, and although the client ran OK the server complains about an unspecified dependency error and a corrupt server file. Has anyone else come across this, or should I start panicking now? Thanks Ian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: mySQL and 'testing'
ieb wrote: Sorry if this repeats a previous query I did scan the list of topics but couldn't spot this. I am running the 'testing' version. I came back from 3 weeks offline and simply let synaptic gather all the updates and apply them (OK.. yes , that was probably a bit dumb... but too late now)... Everything seemed to go ok until I went to log in to mySQL. and it cant find the socket. I tried to update the files using the mysql-client and mysql-server, and although the client ran OK the server complains about an unspecified dependency error and a corrupt server file. Has anyone else come across this, or should I start panicking now? Thanks Ian Are the errors with the server reported through synaptic or when you try to start the server? Have you tried to resolve the dependancies with synaptic? And could you also post the error messages you get? Thx, Jeff -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Setting up InnoDB on MySQL on testing
I would like to use the InnoDB engine for a new database in MySQL. From what I've found so far InnoDB support should be available in the debian packages and all I need to configure it. Unfortunately I haven't found instructions on how to do so yet. The Mysql 5.0 documentation describes some parameters to set up in /etc/mysql/my.cnf. But even after adding these tables I create with the InnoDB engine specified are still created as MyISAM. I'v found old messages saying you should uncomment some parameters in my.cnf (like skip-innodb) but none of these appear in the my.cnf file. What do I need to be able to create InnoDB tables? Thanks in advance Bram -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #349737 # # debian testingkernel 2.6.15-1-686i6861024MB RAM # # 14:39:30 up 1 day, 20:16, 3 users, load average: 0.13, 0.29, 0.14 # -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: Setting up InnoDB on MySQL on testing
2006/6/23, Mertens Bram [EMAIL PROTECTED]: I would like to use the InnoDB engine for a new database in MySQL. From what I've found so far InnoDB support should be available in the debian packages and all I need to configure it. Unfortunately I haven't found instructions on how to do so yet. The Mysql 5.0 documentation describes some parameters to set up in /etc/mysql/my.cnf. But even after adding these tables I create with the InnoDB engine specified are still created as MyISAM. I'v found old messages saying you should uncomment some parameters in my.cnf (like skip-innodb) but none of these appear in the my.cnf file. What do I need to be able to create InnoDB tables? The only option I have in my.cnf are : innodb_data_file_path=ibdata/ibdata1:50M:autoextend innodb_file_per_table and then, you need to restart MySQL. -- http://www.w-fenec.org/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: Setting up InnoDB on MySQL on testing [Solved]
On 2006-06-23, Pooly wrote: 2006/6/23, Mertens Bram [EMAIL PROTECTED]: I would like to use the InnoDB engine for a new database in MySQL. From what I've found so far InnoDB support should be available in the debian packages and all I need to configure it. Unfortunately I haven't found instructions on how to do so yet. The Mysql 5.0 documentation describes some parameters to set up in /etc/mysql/my.cnf. But even after adding these tables I create with the InnoDB engine specified are still created as MyISAM. I'v found old messages saying you should uncomment some parameters in my.cnf (like skip-innodb) but none of these appear in the my.cnf file. What do I need to be able to create InnoDB tables? The only option I have in my.cnf are : innodb_data_file_path=ibdata/ibdata1:50M:autoextend innodb_file_per_table and then, you need to restart MySQL. Thanks I added the following options (following the MySQL documentation): innodb_data_file_path = ibdata1:10M:autoextend innodb_buffer_pool_size=70M innodb_additional_mem_pool_size=10M innodb_log_file_size=20M innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 This time I tried starting mysql with simply mysqld rather than /etc/init.d/mysql start and noticed an error message about the size of the log files. Then I adjusted the innodb_log_file_size=20M to 5M which appears to be the size of the log created during the installation and everything is working as expected! I shut the server down again using mysqladmin shutdown and restarted with /etc/init.d/mysql start. Thanks Bram -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #349737 # # debian testingkernel 2.6.15-1-686i6861024MB RAM # # 16:26:54 up 1 day, 22:04, 3 users, load average: 0.06, 0.07, 0.03 # -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
php/mysql in testing
Hi All, I'm having some problems with php/mysql after a system update ... my code was working before ... (but I've messed with it since) test code is: ?php #phpinfo(); print(time()); $db_config[database_host] = localhost; $db_config[database_user] = school; $db_config[database_password] = bonfire; $db_config[database_name] = school; $db_connection = mysql_connect($db_config[database_host] , $db_config[database_user] ,$db_config[database_password] ); if (mysql_errno()){ trigger_error(Server error:. mysql_error()); exit; } $db_selection = mysql_select_db($db_config[database_name], $db_connection); if (mysql_errno()){ trigger_Error(Server error:. mysql_error()); exit; } ? outputs 1054567413 Notice: Server error:Access denied for user: '@localhost' to database 'school' in /home/sean/projects/onlinedb/public_html/test.php on line 22 so it seems to be forgetting the db connection any help much appreciated :) Package: mysql-server Version: 3.23.49-8 Package: php4-mysql Version: 4:4.1.2-6 Depends: libc6 (= 2.2.4-4), libmysqlclient10, zlib1g (= 1:1.1.4), zendapi-20010901 Package: php4 Version: 4:4.1.2-5 Package: libmysqlclient10 Version: 3.23.49-8 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]