ERROR 2002: Can't connect to local MySQL server through socket
Hi all im t rying to run this web application called vtigerCRM, I run the script that starts it all up, but I get this error:
Starting apache at port 81
MySQL home: /vtiger/vtigerCRM4_2/mysql
Checking whether the MySQL server is already running
ERROR 2002: Can't connect to local MySQL server through socket '/vtiger//vtigerCRM4_2/mys
Mysql Server is not running. Going to start the mysql server at port 3308
rm: cannot remove `/var/run/mysqld/mysqld.pi
./bin/mysqld_safe: line 281: /var/log/mysqld.log: Permission denied
ERROR 2002: Can't connect to local MySQL server through socket '/vtiger//vtigerCRM4_2/mys
**************************
Unable to start the mysql server. Check whether the port 3308 is free
Any ideas? seems a bit straight forward
Starting apache at port 81
MySQL home: /vtiger/vtigerCRM4_2/mysql
Checking whether the MySQL server is already running
ERROR 2002: Can't connect to local MySQL server through socket '/vtiger//vtigerCRM4_2/mys
Mysql Server is not running. Going to start the mysql server at port 3308
rm: cannot remove `/var/run/mysqld/mysqld.pi
./bin/mysqld_safe: line 281: /var/log/mysqld.log: Permission denied
ERROR 2002: Can't connect to local MySQL server through socket '/vtiger//vtigerCRM4_2/mys
**************************
Unable to start the mysql server. Check whether the port 3308 is free
Any ideas? seems a bit straight forward
Vtiger CRM is a bundled package so you don't have as much control over the individual installation of components.
Is this error produced during installation?
Is the installation successful but it just can't connect to mysql?
To see if mysql is running:
shell> nmap -sT localhost
This will show you all ports and services that are currently running.
Is this error produced during installation?
Is the installation successful but it just can't connect to mysql?
To see if mysql is running:
shell> nmap -sT localhost
This will show you all ports and services that are currently running.
Hey and thanks ever so much for your reply.
Correct, installation was successful thank god, I had a nightmare with the apache, but that on its own had its own problem, took me 5 days to figure out, I had to disable SElinux in the text file.
Ill try what you said when I get to work though.
Correct, installation was successful thank god, I had a nightmare with the apache, but that on its own had its own problem, took me 5 days to figure out, I had to disable SElinux in the text file.
Ill try what you said when I get to work though.
Ok sorry I didnt type the command in properly, I get this corrently:
(The 1665 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
111/tcp open rpcbind
631/tcp open ipp
3306/tcp open mysql
8080/tcp open http-proxy
10000/tcp open snet-sensor-mgmt
50000/tcp open iiimsf
50002/tcp open iiimsf
Thing is, the mysql, runs oin port 3308, so 3306 like you currently see, shouldnt matter?
(The 1665 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
111/tcp open rpcbind
631/tcp open ipp
3306/tcp open mysql
8080/tcp open http-proxy
10000/tcp open snet-sensor-mgmt
50000/tcp open iiimsf
50002/tcp open iiimsf
Thing is, the mysql, runs oin port 3308, so 3306 like you currently see, shouldnt matter?
So in your original post it says, "Mysql Server is not running. Going to start the mysql server at port 3308"
Somewhere in the code its pointing to the wrong port. IMHO, I'm not sure how to fix this so you may want to post this on the vTiger Forum page or circle an email.
Somewhere in the code its pointing to the wrong port. IMHO, I'm not sure how to fix this so you may want to post this on the vTiger Forum page or circle an email.
Ok good, at least I have some direction, I think it is a mysql problem, because I have searched the error and alot of people have that error.
Could you possibly direct me to what file mysql uses to start etc, the config file perhaps so I could search around, the Vtiger forums are rubish, and I seem to always get my problems sorted on this site :)
Could you possibly direct me to what file mysql uses to start etc, the config file perhaps so I could search around, the Vtiger forums are rubish, and I seem to always get my problems sorted on this site :)
MySQL can be installed in any directory... from your post it appears to be in: /vtiger//vtigerCRM4_2/mysq
And it used a binary distribution, probably a .tar file. All the data, indices, and log files will be in that directory also.
The config file will end with .cnf (usually /etc/my.cnf).
And it used a binary distribution, probably a .tar file. All the data, indices, and log files will be in that directory also.
The config file will end with .cnf (usually /etc/my.cnf).
Not the solution you were looking for? Getting a personalized solution is easy.
Ask the Experts
I did a search, and there isnt one in there, is there a chance I have to create one, perhaps use a sample.cnf or something? Maybe I could use the master mysql my.cnf and ammend it for vtiger, what do you reckon?
/etc/init.d/mysql.server is the file that is used to start or stop the server
chigs20 is correct.
vTiger is trying to look for mysql whether it is running on port 3308 or not. if not it is trying to start the server at 3308.
but actually your mysql is running under 3306 port.
so check the vTiger forums for point the mysql port to 3306 instead of 3308.
or else you can change the port of your mysql to 3308.
stop the mysql server if running using the followin command
/etc/init.d/mysql.server stop
open my.cnf available under /etc/my.cnf
and add this line just under [mysqld], i.e.,
[mysqld]
port = 3308
now start the mysql usign
/etc/init.d/mysql.server start
chigs20 is correct.
vTiger is trying to look for mysql whether it is running on port 3308 or not. if not it is trying to start the server at 3308.
but actually your mysql is running under 3306 port.
so check the vTiger forums for point the mysql port to 3306 instead of 3308.
or else you can change the port of your mysql to 3308.
stop the mysql server if running using the followin command
/etc/init.d/mysql.server stop
open my.cnf available under /etc/my.cnf
and add this line just under [mysqld], i.e.,
[mysqld]
port = 3308
now start the mysql usign
/etc/init.d/mysql.server start
so let me get this straight, the file under /etc/my.cnf controls all instances of mysql? regardless of which type of application uses its own mysql, also if your running mysql on different ports, u need this file??
Im gonna try the things you just said, but I just wanted to ask that question.
Im gonna try the things you just said, but I just wanted to ask that question.
yes you are right.
my.cnf is not a mandatory file, even if the file doesnt exist mysql works, but with default settings.
using my.cnf you can change the settings of mysql, fine tune mysql...etc..etc
my.cnf is not a mandatory file, even if the file doesnt exist mysql works, but with default settings.
using my.cnf you can change the settings of mysql, fine tune mysql...etc..etc
Now im getting this error:
Starting apache at port 81
httpd not running, trying to start
MySQL home: /vtiger/vtigerCRM4_2/mysql
Checking whether the MySQL server is already running
warning: World-writeable config file /etc/my.cnf is ignored
ERROR 2002: Can't connect to local MySQL server through socket '/vtiger//vtigerCRM4_2/mys
Mysql Server is not running. Going to start the mysql server at port 3308
warning: World-writeable config file /etc/my.cnf is ignored
warning: World-writeable config file /etc/my.cnf is ignored
warning: World-writeable config file /etc/my.cnf is ignored
Checking if the vtigercrm4_2_4 database already exists
warning: World-writeable config file /etc/my.cnf is ignored
Thing is, the webpage now displays, although no one likes errors lol, so is this something I can fix easy?
Starting apache at port 81
httpd not running, trying to start
MySQL home: /vtiger/vtigerCRM4_2/mysql
Checking whether the MySQL server is already running
warning: World-writeable config file /etc/my.cnf is ignored
ERROR 2002: Can't connect to local MySQL server through socket '/vtiger//vtigerCRM4_2/mys
Mysql Server is not running. Going to start the mysql server at port 3308
warning: World-writeable config file /etc/my.cnf is ignored
warning: World-writeable config file /etc/my.cnf is ignored
warning: World-writeable config file /etc/my.cnf is ignored
Checking if the vtigercrm4_2_4 database already exists
warning: World-writeable config file /etc/my.cnf is ignored
Thing is, the webpage now displays, although no one likes errors lol, so is this something I can fix easy?
if possible try to paste the contents of the shell script also.
we will see what the shell script is trying to do.
we will see what the shell script is trying to do.
This is what I got, I couldnt do your command Sheeri, ohh wait let me try as SU...
[mysqld]
port = 3308
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysq
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.
pid-file=/var/run/mysqld/m
[mysqld]
port = 3308
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysq
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.
pid-file=/var/run/mysqld/m
>datadir=/var/lib/mysql
this should be
datadir=/var/lib/mysql/dat
and
>basedir=/var/lib
should be
basedir=/var/lib/mysql
this should be
datadir=/var/lib/mysql/dat
and
>basedir=/var/lib
should be
basedir=/var/lib/mysql
I have a question, since im using a separate mysql, for this application vtiger, is there any way I can check if its really using this file, because etc/my.cnf is the master mysql file.
Just curious...
Just curious...
did you not read my post?
Vtiger uses its own mysql.
But for some reason there is no my.cnf file in the vtiger/mysql directory
Vtiger uses its own mysql.
But for some reason there is no my.cnf file in the vtiger/mysql directory
ok then.
change the my.cnf so that the vtiger picks this my.cnf
>warning: World-writeable config file /etc/my.cnf is ignored
since your my.cnf has doesnt point to vtiger/mysql it is ignoring it.
change you my.cnf to point to your vtiger/mysql
[mysqld]
port = 3308
datadir=/vtiger/vtigerCRM4
socket=/vtiger/vtigerCRM4_
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/vtiger/vtigerCRM4
[mysqld_safe]
log-error=/var/log/mysqld.
pid-file=/var/run/mysqld/m
>>rm: cannot remove `/var/run/mysqld/mysqld.pi
>>./bin/mysqld_safe: line 281: /var/log/mysqld.log: Permission denied
the above error could be because of your mysql server is using these files but vtiger/mysql is trying to remove them.
so first stop you own mysql server and allow only vtiger/mysql to run.
stop your mysql server if running using the followin command
/etc/init.d/mysql.server stop
if you want to run both mysql servers in the same machine with different ports, there are lot of things to do.
just like that it will not work. so dont allow your mysql to run as of now.
change the my.cnf so that the vtiger picks this my.cnf
>warning: World-writeable config file /etc/my.cnf is ignored
since your my.cnf has doesnt point to vtiger/mysql it is ignoring it.
change you my.cnf to point to your vtiger/mysql
[mysqld]
port = 3308
datadir=/vtiger/vtigerCRM4
socket=/vtiger/vtigerCRM4_
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/vtiger/vtigerCRM4
[mysqld_safe]
log-error=/var/log/mysqld.
pid-file=/var/run/mysqld/m
>>rm: cannot remove `/var/run/mysqld/mysqld.pi
>>./bin/mysqld_safe: line 281: /var/log/mysqld.log: Permission denied
the above error could be because of your mysql server is using these files but vtiger/mysql is trying to remove them.
so first stop you own mysql server and allow only vtiger/mysql to run.
stop your mysql server if running using the followin command
/etc/init.d/mysql.server stop
if you want to run both mysql servers in the same machine with different ports, there are lot of things to do.
just like that it will not work. so dont allow your mysql to run as of now.
Ok let me try what you just said, but how hard is it to run 2 mysqls?
Because I want to run mysql for this vtiger, and mysql for just normal linux, for my testing etc, I dont know why vtiger can't just make its own my.cnf, it does the rest of the files, or cant it work like that?
Because I want to run mysql for this vtiger, and mysql for just normal linux, for my testing etc, I dont know why vtiger can't just make its own my.cnf, it does the rest of the files, or cant it work like that?
i dont have an idea on how to configure 2 mysql's in linux machine.
I have done this in Windows 2000 machine with the help of www.mysql.com, which are running perfectly.
following links might help you configuring multiple mysql servers on linux
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
http://www.hostlibrary.com/RunningMultipleMySQLversions
http://www.hostlibrary.com/node/533/print
http://www.roseindia.net/software-tutorials/detail/17189
http://bobcares.com/article44.html
http://bobcares.com/article44.html
i found these links in the web, try them.
http://www.vtiger.com/forums/viewtopic.php?t=1793&highlight=&sid=2b1a64b5931fd51cbabd94cb7a718229
http://www.vtiger.com/forums/viewtopic.php?t=4314&start=0&postdays=0&postorder=asc&highlight=&sid=00609df1aad5030bb6cff9fa562fe00e
I have done this in Windows 2000 machine with the help of www.mysql.com, which are running perfectly.
following links might help you configuring multiple mysql servers on linux
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
http://www.hostlibrary.com/RunningMultipleMySQLversions
http://www.hostlibrary.com/node/533/print
http://www.roseindia.net/software-tutorials/detail/17189
http://bobcares.com/article44.html
http://bobcares.com/article44.html
i found these links in the web, try them.
http://www.vtiger.com/forums/viewtopic.php?t=1793&highlight=&sid=2b1a64b5931fd51cbabd94cb7a718229
http://www.vtiger.com/forums/viewtopic.php?t=4314&start=0&postdays=0&postorder=asc&highlight=&sid=00609df1aad5030bb6cff9fa562fe00e
ok some of the links im still checking out, but heres one that will give your brain a hard time, im still getting this error
./bin/mysqld: File './vtslowquery.log' not found (Errcode: 13)
Warning: World-writable config file '/vtigercrm-5.0.2/vtigerCR
Is it permissions still?
./bin/mysqld: File './vtslowquery.log' not found (Errcode: 13)
Warning: World-writable config file '/vtigercrm-5.0.2/vtigerCR
Is it permissions still?
Thanks for using Experts Exchange.
Create a free account to continue.
Limited access with a free account allows you to:
- View three pieces of content (articles, solutions, posts, and videos)
- Ask the experts questions (counted toward content limit)
- Customize your dashboard and profile
*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.