while Creating Sites during rb-site install selecting database mysql is not listed

[Chetan]

during Creating Sites when i run rb-site install /var/www/reviewboard
i am not finding mysql database. Only sqlite3 is listed. could not
make out why it is not listing mysql datbase to select the same during
rb-site install.

I have installed python-mysqldb

Has anyone faced the same issue?
Request guidance to list mysql db during rb-site install database
selection.

[Jan Koprowski]

Which distributions You use. If You have multiple Python installations
sure You install python-mysql for right version and check which
version use ReviewBoard. Check what return

% python
Python 2.4.3 (#1, Aug 29 2006, 14:45:33)
[GCC 3.4.6 (Gentoo 3.4.6-r1, ssp-3.4.5-1.0, pie-8.7.9)] on linux2
Type "help", "copyright", "credits" or "license" for more
information.
>>> import MySQLdb

in Python console.

[Ajoy Bhatia]

I have the same problem. I have Python 2.7.10 and ReviewBoard uses the same Python installation. Here is what I get on importing MySQLdb module (no error):

%> python
Python 2.7.10 (default, Jul 14 2015, 19:46:27)
[GCC 4.2.1 Compatible Apple LLVM 6.0 (clang-600.0.39)] on darwin

Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb

>>> exit()
%>

What should I do next?

- Ajoy

[Ajoy Bhatia]

Solved my problem. The libmysqlclient.18.dylib file was not being found by the install script. It was in /usr/local/mysql/lib, and DYLD_LIBRARY_PATH had that directory in it. That is probably enough to satisfy the Python console but doesn't work for the script. Then, I saw this post: http://stackoverflow.com/questions/1099981/why-cant-python-find-shared-objects-that-are-in-directories-in-sys-path. However, on my Mac OSX Yosemite 10.10.5, there is no /etc/ld.so.conf or ldconfig. I tried setting LD_LIBRARY_PATH and also LIBRARY_PATH to include /usr/local/mysql/lib but neither worked. So I created the following links under /usr/local/lib:

%> ln -s ../mysql/lib/libmysqlclient.18.dylib libmysqlclient.18.dylib
%> ln -s ../mysql/lib/libmysqlclient.dylib libmysqlclient.dylib

That did the trick.