| View previous topic :: View next topic |
| Author |
Message |
blueillusion
Tux's lil' helper
Joined: 17 Jun 2004
Posts: 138
|
 Posted: Sat Sep 04, 2004 3:10 am Post subject: Mysql, vpopmail hell >.< |
 |
|
I just emerged MySQL, i had to edit the my.cnf so that the socket would be located at: /tmp/mysql.sock or else phpmyadmin wouldnt work (i downloaded it seperately cause if i emerrged it it would download a bunch of X stuff which i really really dont want) Anyways, the mysql server works when i changed it, (my forums work any everything) but vpopmail gets stuck.
I get to this point in the document by gentoo qmail setup to add my domain:
vadddomain blueillusion.ath.cx postpass
as soon as i type that i get:
Warning: Failed while attempting to delete domain from auth backend
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[e]: MySQL server has gone away
Warning: Failed to delete dir_control for blueillusion.ath.cx
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
Can someone please help? if i missed any info please tell me i really really need to get this going or customers arent going to be happy  |
|
| Back to top |
|
 |
hanj
Veteran
Joined: 19 Aug 2003
Posts: 1500
|
| Posted: Sat Sep 04, 2004 3:22 am Post subject: |
|
|
| Quote: | | I just emerged MySQL, i had to edit the my.cnf so that the socket would be located at: /tmp/mysql.sock or else phpmyadmin wouldnt work |
I'm not sure why you had to do that. /tmp probably isn't the best place to have that sock... in fact.. that is probably a really really bad place to have it.
| Quote: | | (i downloaded it seperately cause if i emerrged it it would download a bunch of X stuff which i really really dont want) |
I'm guessing that you don't have your USE flags set up properly. I would emerge ufed (use flag editor) and begin adding/removing flags that you need or don't need. Or you can do it by hand:
| Code: | | USE="-X" emerge -pv phpmyadmin mysql apache |
etc, etc
I'm thinking you need to get mysql and phpmyadmin working right.. sock in the correct directory, etc.. and that may narrow down some of the problems.
I hope this helps some
hanji
Last edited by hanj on Sat Sep 04, 2004 4:09 am; edited 1 time in total |
|
| Back to top |
|
|
blueillusion
Tux's lil' helper
Joined: 17 Jun 2004
Posts: 138
|
| Posted: Sat Sep 04, 2004 3:49 am Post subject: |
|
|
The thing is, if i change it back to where the socekt originally ran from (/var/run/mysqld/mysqld.sock)
None of my web scripts would work, like the xmbforums from www.xmbforum.com
it looks for it in /tmp/mysock.sock
i got so fed up before and i went to use the binaries from the mysql website., then when i went to emerge vpopmail and setup those settings it would look for libmysqlclient.so, and that doesnt exist with the binaries. So any other ideas? Everything works great except vpopmail so far with the socket located at /tmp/mysql.sock |
|
| Back to top |
|
|
blueillusion
Tux's lil' helper
Joined: 17 Jun 2004
Posts: 138
|
| Posted: Sat Sep 04, 2004 6:25 pm Post subject: |
|
|
| anyone?? |
|
| Back to top |
|
|
SnEptUne
l33t
Joined: 23 Aug 2004
Posts: 656
|
| Posted: Mon Sep 06, 2004 9:25 am Post subject: |
|
|
mySQL and phpmyadmin works fine for me out of the "emerge" 
I don't see any reason for putting mysql.sock in /tmp. All I did is,
| Code: | | emerge apache php mod_php |
Or is it just xmbforum not working?
I use https://forums.gentoo.org/viewtopic.php?t=104806 for guidance. Hope this would help. |
|
| Back to top |
|
|
|
Networking & Security
