Discussion:
[Citrusdb-users] mysql error during install
Brad Morton
2012-01-11 16:23:15 UTC
Permalink
Been working on setting up the new and improved Citrusdb on spare box we have here.

OS: OpenBSD 5.0
Mysql-5.1.54
PHP-5.3

I'm getting close, the login page comes up but at the top it says the following:
Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

Not sure where to go with this. Not really a guru with this stuff.

Any help would be great,


Cheers
Brad
Paul Yasi
2012-01-12 01:33:52 UTC
Permalink
I don't know much about running php/mysql under OpenBSD but I found a
tutorial that recommends making a new hard link to the place where
apache can see the file.

http://freeyourbox.org/tutorials/bsd/obsd3.8_apache_php_mysql.html#Setting
that says:

On OpenBSD, apache comes chrooted in the /var/www directory. MySQL's
default socket location is in /var/run/mysql/mysql.sock. This causes a
problem since apache can't "see" the /var/run directory. To overcome
this, we need to make a hard link to the mysql.sock socket file. This
is achieved by typing the following at the command prompt:

# mkdir -p /var/www/var/run/mysql
# ln -f /var/run/mysql/mysql.sock /var/www/var/run/mysql/mysql.sock


Paul
Post by Brad Morton
Been working on setting up the new and improved Citrusdb on spare box we have here.
OS: OpenBSD 5.0
Mysql-5.1.54
PHP-5.3
Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Not sure where to go with this.  Not really a guru with this stuff.
Any help would be great,
Cheers
Brad
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
Brad Morton
2012-01-12 14:50:25 UTC
Permalink
I linked the mysql.sock and it seemed to get of the problem unitl I rebooted. After a reboot the error comes back and I have to relink it.

Ideas?

Also once the error is gone and I try to login with the default username and password it goes no where.

This is the URL that shows up in my adddress bar after the login attempt:
https://10.0.0.11/citrus-2.4.1//index.php


----
Brad Morton
Field Service Manager
Reztel Broadband
780 Midpark Dr. Suite 103
Kingston, ON K7M 7P6
Office:(613) 384-2101
Toll-Free: 888-546-8888
Cell: (613) 888-2161
www.reztel.net

Legal Notice:
Please consider the environment before printing this email.
---------------------------------------------------------------------------------------------------------
This e-mail message is intended only for the named recipient(s) above and may contain information that is privileged and/or confidential. If you have received this message in error, or are not the intended recipient(s), please immediately notify the sender and permanently delete this e-mail message.
Paul Yasi
2012-01-14 15:25:43 UTC
Permalink
It will not login and look as if it's doing nothing if you have the
wrong password or there may be some errors you can look at in the
apache error_log or wherever php may be writing errors.

I currently use ubuntu linux but citrus can run anywhere php/mysql can
run. Whatever OS you are comfortable using. I've run citrus in
various linuxes, windows, and macosx at various times.

Paul
I linked the mysql.sock and it seemed to get of the problem unitl I rebooted.  After a reboot the error comes back and I have to relink it.
Ideas?
Also once the error is gone and I try to login with the default username and password it goes no where.
https://10.0.0.11/citrus-2.4.1//index.php
----
Brad Morton
Field Service Manager
Reztel Broadband
780 Midpark Dr. Suite 103
Kingston, ON K7M 7P6
Office:(613) 384-2101
Toll-Free: 888-546-8888
Cell: (613) 888-2161
www.reztel.net
Please consider the environment before printing this email.
---------------------------------------------------------------------------------------------------------
This e-mail message is intended only for the named recipient(s) above and may contain information that is privileged and/or confidential. If you have received this message in error, or are not the intended recipient(s), please immediately notify the sender and permanently delete this e-mail message.
------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
Loading...