| View previous topic :: View next topic |
| Author |
Message |
idtt2s
Apprentice
Joined: 23 Nov 2005
Posts: 199
|
 Posted: Wed Feb 01, 2006 2:09 am Post subject: Is mysql really installed? |
 |
|
I have MySQL installed
| Code: |
localhost / # emerge -s mysql
...
* dev-db/mysql
Latest version available: 5.0.18-r30
Latest version installed: 5.0.18-r30
...
|
but some applications can't compile since they can't find the MySQL headers.
| Code: |
...
checking for mysql/mysql.h... no
...
|
This also applies to Samba
| Code: |
...
passdb/pdb_mysql.c:21:25: mysql/mysql.h: No such file or directory
...
!!! ERROR: net-fs/samba-3.0.20b failed.
...
|
|
|
| Back to top |
|
 |
Genone
Retired Dev
Joined: 14 Mar 2003
Posts: 9631
Location: beyond the rim
|
| Posted: Wed Feb 01, 2006 3:37 am Post subject: |
|
|
| That's probably a side-effect of the new slotting for mysql. File a bug about it at bugs.gentoo.org. |
|
| Back to top |
|
|
idtt2s
Apprentice
Joined: 23 Nov 2005
Posts: 199
|
| Posted: Wed Feb 01, 2006 4:01 am Post subject: |
|
|
Would using an old version of MySQL help?
EDIT: Can someone suggest a valid version? |
|
| Back to top |
|
|
BastianBalthazarBux
Retired Dev
Joined: 10 Dec 2004
Posts: 78
|
| Posted: Thu Feb 02, 2006 12:20 am Post subject: Re: Is mysql really installed? |
|
|
http://www.gentoo.org/doc/en/mysql-upgrade-slotted.xml
be sure to have >=app-admin/eselect-mysql-1.0.0-r1
run
| Code: |
eselect mysql list
eselect mysql set 1
eselect mysql show
|
-- edited formatting |
|
| Back to top |
|
|
idtt2s
Apprentice
Joined: 23 Nov 2005
Posts: 199
|
| Posted: Thu Feb 02, 2006 1:58 pm Post subject: |
|
|
| Code: |
localhost portage # eselect mysql list
Available MySQL versions:
[1] 5.0.x
localhost portage # eselect mysql set 1
/usr/share/eselect//modules/mysql.eselect: line 193: /var/lib/eselect/mysql/mysql-500.filelist: No such file or directory
find: mysql: No such file or directory
|
|
|
| Back to top |
|
|
BastianBalthazarBux
Retired Dev
Joined: 10 Dec 2004
Posts: 78
|
| Posted: Thu Feb 02, 2006 2:35 pm Post subject: |
|
|
The file "/var/lib/eselect/mysql/mysql-500.filelist" should exist and contain the following list of files, you could cut and paste this one there to make it work
| Code: | etc/mysql-500
usr/lib/mysql-500
usr/share/mysql-500
usr/bin/comp_err-500
usr/bin/innochecksum-500
usr/bin/msql2mysql-500
usr/bin/my_print_defaults-500
usr/bin/myisam_ftdump-500
usr/bin/myisamchk-500
usr/bin/myisamlog-500
usr/bin/myisampack-500
usr/bin/mysql-500
usr/bin/mysql_client_test-500
usr/bin/mysql_explain_log-500
usr/bin/mysql_find_rows-500
usr/bin/mysql_install_db-500
usr/bin/mysql_setpermission-500
usr/bin/mysql_tableinfo-500
usr/bin/mysql_tzinfo_to_sql-500
usr/bin/mysql_waitpid-500
usr/bin/mysql_zap-500
usr/bin/mysqlaccess-500
usr/bin/mysqladmin-500
usr/bin/mysqlbinlog-500
usr/bin/mysqlbug-500
usr/bin/mysqlcheck-500
usr/bin/mysqld_multi-500
usr/bin/mysqld_safe-500
usr/bin/mysqldump-500
usr/bin/mysqldumpslow-500
usr/bin/mysqlhotcopy-500
usr/bin/mysqlimport-500
usr/bin/mysqlshow-500
usr/bin/mysqltest-500
usr/bin/mysqltest_embedded-500
usr/bin/mysqltestmanager-500
usr/bin/mysqltestmanagerc-500
usr/bin/ndb_config-500
usr/bin/ndb_delete_all-500
usr/bin/ndb_desc-500
usr/bin/ndb_drop_index-500
usr/bin/ndb_drop_table-500
usr/bin/ndb_mgm-500
usr/bin/ndb_restore-500
usr/bin/ndb_select_all-500
usr/bin/ndb_select_count-500
usr/bin/ndb_show_tables-500
usr/bin/ndb_test_platform-500
usr/bin/ndb_waiter-500
usr/bin/perror-500
usr/bin/replace-500
usr/bin/resolve_stack_dump-500
usr/bin/resolveip-500
usr/bin/mysql_client_test_embedded-500
usr/bin/mysql_convert_table_format-500
usr/bin/mysql_create_system_tables-500
usr/bin/mysql_fix_extensions-500
usr/bin/mysql_fix_privilege_tables-500
usr/bin/mysql_secure_installation-500
usr/bin/mysqltestmanager-pwgen-500
usr/sbin/mysqld-500
usr/sbin/mysqlmanager-500
usr/sbin/ndb_cpcd-500
usr/sbin/ndb_mgmd-500
usr/sbin/ndbd-500
usr/share/man/man1/msql2mysql-500.1.gz
usr/share/man/man1/myisamchk-500.1.gz
usr/share/man/man1/myisamlog-500.1.gz
usr/share/man/man1/myisampack-500.1.gz
usr/share/man/man1/mysql-500.1.gz
usr/share/man/man1/mysql.server-500.1.gz
usr/share/man/man1/mysql_config-500.1.gz
usr/share/man/man1/mysql_zap-500.1.gz
usr/share/man/man1/mysqlaccess-500.1.gz
usr/share/man/man1/mysqladmin-500.1.gz
usr/share/man/man1/mysqlbinlog-500.1.gz
usr/share/man/man1/mysqlcheck-500.1.gz
usr/share/man/man1/mysqld-500.1.gz
usr/share/man/man1/mysqld_multi-500.1.gz
usr/share/man/man1/mysqld_safe-500.1.gz
usr/share/man/man1/mysqldump-500.1.gz
usr/share/man/man1/mysqlhotcopy-500.1.gz
usr/share/man/man1/mysqlimport-500.1.gz
usr/share/man/man1/mysqlman-500.1.gz
usr/share/man/man1/mysqlmanager-500.1.gz
usr/share/man/man1/mysqlshow-500.1.gz
usr/share/man/man1/perror-500.1.gz
usr/share/man/man1/replace-500.1.gz
usr/share/man/man1/safe_mysqld-500.1.gz
usr/share/man/man1/mysql_fix_privilege_tables-500.1.gz
etc/mysql-500
usr/lib/mysql-500
usr/share/mysql-500
|
|
|
| Back to top |
|
|
idtt2s
Apprentice
Joined: 23 Nov 2005
Posts: 199
|
| Posted: Thu Feb 02, 2006 2:59 pm Post subject: |
|
|
| Code: |
localhost portage # eselect mysql set 1
!!! Error: File "/usr/bin/ndb_config-500" is not suitable for symlink (1)
exiting.
|
|
|
| Back to top |
|
|
BastianBalthazarBux
Retired Dev
Joined: 10 Dec 2004
Posts: 78
|
| Posted: Thu Feb 02, 2006 4:08 pm Post subject: |
|
|
| idtt2s wrote: | | Code: |
localhost portage # eselect mysql set 1
!!! Error: File "/usr/bin/ndb_config-500" is not suitable for symlink (1)
exiting.
|
|
php and mysql issues what interest you are comments 8,9,10,11
either the old version of mysql is still installed or the uninstal phase missed to remove a piece of the installation
Correct:
| Code: |
emerge -Cp mysql
>>> These are the packages that I would unmerge:
dev-db/mysql
selected: 4.1.16-r30 5.0.18-r30 5.1.5_alpha-r30
protected: none
omitted: none
>>> 'Selected' packages are slated for removal.
>>> 'Protected' and 'omitted' packages will not be removed.
|
Wrong:
| Code: |
emerge -Cp mysql
>>> These are the packages that I would unmerge:
dev-db/mysql
selected: 5.0.18 5.0.18-r30
protected: none
omitted: none
>>> 'Selected' packages are slated for removal.
>>> 'Protected' and 'omitted' packages will not be removed.
|
|
|
| Back to top |
|
|
idtt2s
Apprentice
Joined: 23 Nov 2005
Posts: 199
|
| Posted: Thu Feb 02, 2006 4:17 pm Post subject: |
|
|
| Code: |
localhost portage # emerge -Cp mysql
>>> These are the packages that I would unmerge:
dev-db/mysql
selected: 5.0.18-r30
protected: none
omitted: none
>>> 'Selected' packages are slated for removal.
>>> 'Protected' and 'omitted' packages will not be removed.
|
|
|
| Back to top |
|
|
BastianBalthazarBux
Retired Dev
Joined: 10 Dec 2004
Posts: 78
|
| Posted: Thu Feb 02, 2006 4:53 pm Post subject: |
|
|
Need manual fixing then,
| Code: |
cd /
TMPLIST=$( cat /var/lib/eselect/mysql/mysql-500.filelist | sed -e 's!-500!!' )
ls -l $TMPLIST
[the list should be only symlinks if it was ok]
tar -jcpvf ~/my-backup.tar.bz2 $TMPLIST
rm -rf $TMPLIST
eselect mysql set 1
|
Please bug portage people to understund why those files have not been removed. |
|
| Back to top |
|
|
idtt2s
Apprentice
Joined: 23 Nov 2005
Posts: 199
|
| Posted: Thu Feb 02, 2006 5:22 pm Post subject: |
|
|
| Code: |
localhost / # TMPLIST=$( cat /var/lib/eselect/mysql/mysql-500.filelist | sed -e 's!-500!!' )
localhost / # ls -l $TMPLIST
ls: etc/mysql: No such file or directory
ls: usr/lib/mysql: No such file or directory
ls: usr/share/mysql: No such file or directory
ls: usr/bin/comp_err: No such file or directory
ls: usr/bin/innochecksum: No such file or directory
ls: usr/bin/msql2mysql: No such file or directory
ls: usr/bin/my_print_defaults: No such file or directory
ls: usr/bin/myisam_ftdump: No such file or directory
ls: usr/bin/myisamchk: No such file or directory
ls: usr/bin/myisamlog: No such file or directory
ls: usr/bin/myisampack: No such file or directory
ls: usr/bin/mysql: No such file or directory
ls: usr/bin/mysql_client_test: No such file or directory
ls: usr/bin/mysql_explain_log: No such file or directory
ls: usr/bin/mysql_find_rows: No such file or directory
ls: usr/bin/mysql_install_db: No such file or directory
ls: usr/bin/mysql_setpermission: No such file or directory
ls: usr/bin/mysql_tableinfo: No such file or directory
ls: usr/bin/mysql_tzinfo_to_sql: No such file or directory
ls: usr/bin/mysql_waitpid: No such file or directory
ls: usr/bin/mysql_zap: No such file or directory
ls: usr/bin/mysqlaccess: No such file or directory
ls: usr/bin/mysqladmin: No such file or directory
ls: usr/bin/mysqlbinlog: No such file or directory
ls: usr/bin/mysqlbug: No such file or directory
ls: usr/bin/mysqlcheck: No such file or directory
ls: usr/bin/mysqld_multi: No such file or directory
ls: usr/bin/mysqld_safe: No such file or directory
ls: usr/bin/mysqldump: No such file or directory
ls: usr/bin/mysqldumpslow: No such file or directory
ls: usr/bin/mysqlhotcopy: No such file or directory
ls: usr/bin/mysqlimport: No such file or directory
ls: usr/bin/mysqlshow: No such file or directory
ls: usr/bin/mysqltest: No such file or directory
ls: usr/bin/mysqltest_embedded: No such file or directory
ls: usr/bin/mysqltestmanager: No such file or directory
ls: usr/bin/mysqltestmanagerc: No such file or directory
ls: usr/bin/ndb_config: No such file or directory
ls: usr/bin/ndb_delete_all: No such file or directory
ls: usr/bin/ndb_desc: No such file or directory
ls: usr/bin/ndb_drop_index: No such file or directory
ls: usr/bin/ndb_drop_table: No such file or directory
ls: usr/bin/ndb_mgm: No such file or directory
ls: usr/bin/ndb_restore: No such file or directory
ls: usr/bin/ndb_select_all: No such file or directory
ls: usr/bin/ndb_select_count: No such file or directory
ls: usr/bin/ndb_show_tables: No such file or directory
ls: usr/bin/ndb_test_platform: No such file or directory
ls: usr/bin/ndb_waiter: No such file or directory
ls: usr/bin/perror: No such file or directory
ls: usr/bin/replace: No such file or directory
ls: usr/bin/resolve_stack_dump: No such file or directory
ls: usr/bin/resolveip: No such file or directory
ls: usr/bin/mysql_client_test_embedded: No such file or directory
ls: usr/bin/mysql_convert_table_format: No such file or directory
ls: usr/bin/mysql_create_system_tables: No such file or directory
ls: usr/bin/mysql_fix_extensions: No such file or directory
ls: usr/bin/mysql_fix_privilege_tables: No such file or directory
ls: usr/bin/mysql_secure_installation: No such file or directory
ls: usr/bin/mysqltestmanager-pwgen: No such file or directory
ls: usr/sbin/mysqld: No such file or directory
ls: usr/sbin/mysqlmanager: No such file or directory
ls: usr/sbin/ndb_cpcd: No such file or directory
ls: usr/sbin/ndb_mgmd: No such file or directory
ls: usr/sbin/ndbd: No such file or directory
ls: usr/share/man/man1/msql2mysql.1.gz: No such file or directory
ls: usr/share/man/man1/myisamchk.1.gz: No such file or directory
ls: usr/share/man/man1/myisamlog.1.gz: No such file or directory
ls: usr/share/man/man1/myisampack.1.gz: No such file or directory
ls: usr/share/man/man1/mysql.1.gz: No such file or directory
ls: usr/share/man/man1/mysql.server.1.gz: No such file or directory
ls: usr/share/man/man1/mysql_config.1.gz: No such file or directory
ls: usr/share/man/man1/mysql_zap.1.gz: No such file or directory
ls: usr/share/man/man1/mysqlaccess.1.gz: No such file or directory
ls: usr/share/man/man1/mysqladmin.1.gz: No such file or directory
ls: usr/share/man/man1/mysqlbinlog.1.gz: No such file or directory
ls: usr/share/man/man1/mysqlcheck.1.gz: No such file or directory
ls: usr/share/man/man1/mysqld.1.gz: No such file or directory
ls: usr/share/man/man1/mysqld_multi.1.gz: No such file or directory
ls: usr/share/man/man1/mysqld_safe.1.gz: No such file or directory
ls: usr/share/man/man1/mysqldump.1.gz: No such file or directory
ls: usr/share/man/man1/mysqlhotcopy.1.gz: No such file or directory
ls: usr/share/man/man1/mysqlimport.1.gz: No such file or directory
ls: usr/share/man/man1/mysqlman.1.gz: No such file or directory
ls: usr/share/man/man1/mysqlmanager.1.gz: No such file or directory
ls: usr/share/man/man1/mysqlshow.1.gz: No such file or directory
ls: usr/share/man/man1/perror.1.gz: No such file or directory
ls: usr/share/man/man1/replace.1.gz: No such file or directory
ls: usr/share/man/man1/safe_mysqld.1.gz: No such file or directory
ls: usr/share/man/man1/mysql_fix_privilege_tables.1.gz: No such file or directory
ls: etc/mysql: No such file or directory
ls: usr/lib/mysql: No such file or directory
ls: usr/share/mysql: No such file or directory
|
|
|
| Back to top |
|
|
idtt2s
Apprentice
Joined: 23 Nov 2005
Posts: 199
|
| Posted: Fri Feb 03, 2006 3:10 pm Post subject: |
|
|
| BUMP!!!! |
|
| Back to top |
|
|
idtt2s
Apprentice
Joined: 23 Nov 2005
Posts: 199
|
| Posted: Wed Feb 08, 2006 1:15 am Post subject: |
|
|
| RE-BUMP! |
|
| Back to top |
|
|
pancapangrawit
n00b
Joined: 10 Jan 2005
Posts: 8
Location: Graz (Austria)
|
| Posted: Wed Mar 15, 2006 2:05 pm Post subject: |
|
|
I have the same problem since updating from 5.0.18 r30 to 5.0.19. Please help
Rainer |
|
| Back to top |
|
|
p_ansell
n00b
Joined: 12 May 2005
Posts: 33
Location: Brisbane, AU
|
| Posted: Thu Mar 16, 2006 1:03 am Post subject: |
|
|
I am having the same problem upgrading to 5.0.19.
| Code: |
# eselect mysql set 1
!!! Error: File "/usr/bin/mysql_explain_log-500" is not suitable for symlink (2)
exiting.
|
This should not be a fix that has to be done with every slotted upgrade.
What also worries me is the following
| Code: |
# emerge -Cp mysql
>>> These are the packages that would be unmerged:
dev-db/mysql
selected: 5.0.18-r30 4.1.18-r30 5.0.19
protected: none
omitted: none
|
Isn't an upgrade from 5.0.18-r30 to 5.0.19 supposed to clean up the 5.0.18-r30 files?
I will now try to unemerge the 5.0.18-r30 version, not expecting success given previous fixes for this. |
|
| Back to top |
|
|
p_ansell
n00b
Joined: 12 May 2005
Posts: 33
Location: Brisbane, AU
|
| Posted: Thu Mar 16, 2006 1:08 am Post subject: |
|
|
| Code: |
emerge -Cav =dev-db/mysql-5.0.18-r30
|
The above removed all of the version 5 slotted files, including ones that would have been put there by 5.0.19.
Heavily suggest that people do not use the upgrade option for this upgrade.
Backup your /var/lib/mysql-500 directory and then unmerge seems to be the best option.
After unmerging merging the 5.0.19 version may work. Currently doing that. |
|
| Back to top |
|
|
p_ansell
n00b
Joined: 12 May 2005
Posts: 33
Location: Brisbane, AU
|
|
| Back to top |
|
|
p_ansell
n00b
Joined: 12 May 2005
Posts: 33
Location: Brisbane, AU
|
| Posted: Thu Mar 16, 2006 6:50 am Post subject: |
|
|
Following my bug report, I received what is obviously common knowledge in the Gentoo community, Mysql is no longer slotted (ie. it has SLOT=0). Despite the misleading name of the following link, It is actually the instructions on how to upgrade from slotted to unslotted.
http://www.gentoo.org/doc/en/mysql-upgrade-slotted.xml |
|
| Back to top |
|
|
|
Portage & Programming
