Hi, folks,

I'm going to set up my own blog on a solaris server
where now my personal homepage is located. First
I tried movabletype but failed in the installation due
to some Perl DB problems. I have no root access and
our admin just is kind of unresponsive to my request.
Now I am reading documentation of wordpress. It
requires mysql and php support. So here are my questions:

(1) How do I know if mysql is installed and if yes, its version?
I tried "which mysql" and "whereis mysql", but seems
it returned nothing, so can I assume the mysql is missing.

(2) Can I install mysql in my own space without root access?

(3) How do I know if the system supports php?

Any kind help would be greatly appreciated.

ps -ef|grep mysql
Not (easily) if the mysql distribution is under pkg format, yes if you compile it from the source code.
That depends first on the web server used, if it is apache, search "php" occurences in the httpd.conf file.

Hi,

I just built mysql from source on Solaris. It's
installed in my own space since I have no root
access on that solaris server.

The problem is I always get following error when
trying to run mysql.

sand:163% ./mysql
ERROR 2002: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2)

Of course, there is no such file '/tmp/mysql.sock' and
seems I need to modify the configure file '/etc/my.conf'
which also does not exist at all since I do not have write
access to /tmp and /etc.

I can run the ./bin/mysql_conf, but don't know how to use
that program.

Any help? Thanks in advance!

Innersmile,

It looks like you built your mysql without changing pathes to point to directories you own.
I don't think the problem you describe is Solaris specific, so you may have more luck posting this question to a more suitable forum.

Moreover, googling "ERROR 2002: Can't connect to local MySQL server" gives tons of hits, your answer is probably there.

Hi Jlliagre,

Thank you for your reply.

I did use --prefix option when I ran ./configure, don't know other way to change pathes.

Yes, I googled before and it did return tons of answers, while most of them
suggest modifying the configuration file '/etc/my.conf' which does not exist
on my machine at all. I would post this question to other forum if I can not
get solution today. :-)

Anyway, thank you very much!

From what you said, perhaps mysql just doesn't supports to be installed without root access rights, as "/etc" seems hard-coded.

Anyway, I think this is maybe the easiest of the problems you're faced for your blog project, as I see no way to later enable php on the solaris host web server and to configure it to connect to your local database, should you succeed in running it, unless you also plan to build a home instance of apache/php.

My advice would be for you to insist convincing your sysadmin to help ...