View previous topic :: View next topic |
Author |
Message |
andybrandorff n00b
Joined: 03 Aug 2004 Posts: 57 Location: denmark
|
Posted: Sun Jan 30, 2005 8:29 pm Post subject: mysql |
|
|
Hej jeg er somsagt ved at sætte min server op og en af de sidste ting jeg mangler er mysql.
Og jeg fandt denne howto-do http://www.gentoo.se/docs/doc-apache-php--ssl-mysql.php
enligt god men når jeg vil køre ebuild brokker den sig
Code: | ebuild /var/db/pkg/dev-db/mysql-x.y.z[-rN]/mysql-x.y.z[-rN].ebuild config |
og da jeg bagefter skal have qmail ind skal min mysql, somsagt køre førdst hvda skal jeg gøre.
Har aldrig instaleret med ebuild før. |
|
Back to top |
|
|
kallamej Administrator
Joined: 27 Jun 2003 Posts: 4975 Location: Gothenburg, Sweden
|
Posted: Mon Jan 31, 2005 8:13 am Post subject: |
|
|
Om du körde exakt det kommandot så är det inte konstigt att det inte fungerar. Ersätt x.y.z[-rN] med den version-revision du installerat, förmodligen 4.0.22-r2. Annars behövs mer information om vad det är som blir fel. _________________ Please read our FAQ Forum, it answers many of your questions.
irc: #gentoo-forums on irc.libera.chat |
|
Back to top |
|
|
andybrandorff n00b
Joined: 03 Aug 2004 Posts: 57 Location: denmark
|
Posted: Wed Feb 02, 2005 9:46 am Post subject: Tak |
|
|
Tak det havde jeg ikke lige gennemskuget.
Nogengange er det jo meget simpel. |
|
Back to top |
|
|
andybrandorff n00b
Joined: 03 Aug 2004 Posts: 57 Location: denmark
|
Posted: Thu Feb 03, 2005 2:29 pm Post subject: |
|
|
Det lykkes men så kom der jo bare et nyt. snøft.
Jeg er enligt ved at instalere qmail med mysql. og følger gentoos guide. http://www.gentoo.org/doc/en/qmail-howto.xml
Men når jeg kommer til punktet " Setting up vpopmail in mysql"
Code: | # rc-update add mysql default
If you just emerged mysql for the first time, make sure you run
the ebuild <mysql.ebuild> config command and follow the
directions before starting the mysql server.
# /etc/init.d/mysql start
# nano /etc/vpopmail.conf
(Change the password from 'secret' to 'vpoppw')
# mysql -p << EOF
create database vpopmail;
use mysql;
grant select, insert, update, delete, create, drop on vpopmail.* to vpopmail@localhost identified by 'vpoppw';
flush privileges;
EOF
(The following steps may or may not be needed, but we run them just to be sure)
# chown root:vpopmail /etc/vpopmail.conf
# chmod 640 /etc/vpopmail.conf
# chown root:vpopmail /var/vpopmail/bin/vchkpw
# chmod 4711 /var/vpopmail/bin/vchkpw |
går det galt.
Code: | mysql -p << EOF
> create database vpopmail;
> use mysql;
> grant select, insert, update, delete, create, drop on vpopmail.* to vpopmail@localhost identified by 'andy'; > flush privileges;
> EOF
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
|
jeg har prøvet at pinge mysql med.
Code: | mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
| så det er i mysql jeg har et problem.
kan heller ikke sætte et passwd for mysql? |
|
Back to top |
|
|
kallamej Administrator
Joined: 27 Jun 2003 Posts: 4975 Location: Gothenburg, Sweden
|
|
Back to top |
|
|
andybrandorff n00b
Joined: 03 Aug 2004 Posts: 57 Location: denmark
|
Posted: Sat Feb 05, 2005 3:45 pm Post subject: |
|
|
nu har jeg fået mysql til at virke.
Men jeg får at vide at mysql at Table 'vpopmail.vpopmail' doesn't exist
hvordan opretter jeg denne?
Det er sådan jeg får at vide hvordan jeg skal gøre:
Code: |
> You only have to do this if the vadddomain step below results in "command not found")
> # source /etc/profile
>
> (While debugging vpopmail, you may want to consult the logs)
> # mysql -u vpopmail -p
> mysql> select * from vpopmail.vlog;
>
> # vadddomain wh0rd.org postpass
> (Now quickly verify the domain is setup properly)
> # printf "postmaster@wh0rd.org\0postpass\0blah\0" | vchkpw `which id` 3<&0
> uid=89(vpopmail) gid=89(vpopmail) groups=0(root)
> (If you don't see something similar to above, then permissions somewhere are incorrect)
> # vadduser vapier@wh0rd.org vappw
|
Så jeg skal have lavet en vpopmail
har prøvet
Code: |
mysql>CREATE TABLE vpopmail(vopmail); |
Men så får jeg fejlen
Code: | ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 |
|
|
Back to top |
|
|
kallamej Administrator
Joined: 27 Jun 2003 Posts: 4975 Location: Gothenburg, Sweden
|
Posted: Mon Feb 07, 2005 10:37 pm Post subject: |
|
|
Kan egentligen ingenting om det här, men enligt http://dev.mysql.com/doc/mysql/en/create-table.html måste du även ge typen för kolumnen vpopmail i create table kommandot. Jag kör inte heller vpopmail så vad som behövs utöver den guiden vet jag inte. _________________ Please read our FAQ Forum, it answers many of your questions.
irc: #gentoo-forums on irc.libera.chat |
|
Back to top |
|
|
andybrandorff n00b
Joined: 03 Aug 2004 Posts: 57 Location: denmark
|
Posted: Sun Feb 27, 2005 12:42 am Post subject: |
|
|
nu er jeg komme så langt som at jeg skal Code: | select * from vpopmail.vlog; |
men det vil den ikke siger at tabellen ikke er lavet hmm skulle vpopmail
ikke selv generere den? |
|
Back to top |
|
|
|