Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Scandinavian
View previous topic :: View next topic  
Author Message
andybrandorff
n00b
n00b


Joined: 03 Aug 2004
Posts: 57
Location: denmark

PostPosted: Sun Jan 30, 2005 8:29 pm    Post subject: mysql Reply with quote

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
View user's profile Send private message
kallamej
Administrator
Administrator


Joined: 27 Jun 2003
Posts: 4830
Location: Gothenburg, Sweden

PostPosted: Mon Jan 31, 2005 8:13 am    Post subject: Reply with quote

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.freenode.net
Back to top
View user's profile Send private message
andybrandorff
n00b
n00b


Joined: 03 Aug 2004
Posts: 57
Location: denmark

PostPosted: Wed Feb 02, 2005 9:46 am    Post subject: Tak Reply with quote

Tak det havde jeg ikke lige gennemskuget.
Nogengange er det jo meget simpel.
Back to top
View user's profile Send private message
andybrandorff
n00b
n00b


Joined: 03 Aug 2004
Posts: 57
Location: denmark

PostPosted: Thu Feb 03, 2005 2:29 pm    Post subject: Reply with quote

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
View user's profile Send private message
kallamej
Administrator
Administrator


Joined: 27 Jun 2003
Posts: 4830
Location: Gothenburg, Sweden

PostPosted: Thu Feb 03, 2005 4:13 pm    Post subject: Reply with quote

Försök att resetta mysqls root lösenord. Se http://forums.gentoo.org/viewtopic.php?p=591239#591239
_________________
Please read our FAQ Forum, it answers many of your questions.
irc: #gentoo-forums on irc.freenode.net
Back to top
View user's profile Send private message
andybrandorff
n00b
n00b


Joined: 03 Aug 2004
Posts: 57
Location: denmark

PostPosted: Sat Feb 05, 2005 3:45 pm    Post subject: Reply with quote

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
View user's profile Send private message
kallamej
Administrator
Administrator


Joined: 27 Jun 2003
Posts: 4830
Location: Gothenburg, Sweden

PostPosted: Mon Feb 07, 2005 10:37 pm    Post subject: Reply with quote

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.freenode.net
Back to top
View user's profile Send private message
andybrandorff
n00b
n00b


Joined: 03 Aug 2004
Posts: 57
Location: denmark

PostPosted: Sun Feb 27, 2005 12:42 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Scandinavian All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum