顯示文章

這裡允許您檢視這個會員的所有文章。請注意, 您只能看見您有權限閱讀的文章。


主題 - snack.shih

頁: [1]
1
請問各位前輩,下列不知道是哪個順序錯誤,造成outlook不勾選「我的伺服器需要驗證」也可以外寄…,我有試著把reject_sender_login_mismatch移到最上面,但還是可以外寄…。

smtpd_recipient_restrictions =
                        reject_unlisted_sender,
                        permit_mynetworks,
                        permit_sasl_authenticated,
                        reject_sender_login_mismatch,
                        reject_invalid_hostname,
                        reject_unauth_destination,
                        check_policy_service unix:private/policy-spf
                        check_client_access hash:/etc/postfix/rbl_whitelist
                        permit_auth_destination,
                        reject_unknown_sender_domain,
                        reject_non_fqdn_recipient,
                        reject_unauth_pipelining,
                        check_relay_domain reject

2
Linux 討論版 / roundcubemail 篩選器無作用
« 於: 2016-10-18 12:59 »
小弟最近在CentOS 6.x上面安裝roundcubemail,參考了下面的網站,也修改了設定檔,但就是沒有發生作用,想請問各位大哥,還是哪些是我需要注意的?

http://dywang.csie.cyut.edu.tw/dywang/l ... ode86.html

3
各位先進好:
      小弟在安裝如題的套件時,出現以下狀況,可否麻煩各位前輩幫小弟解惑一下,謝謝...
[root@dns ~]# yum -y install cyrus-sasl-md5 cyrus-sasl-plain cyrus-sasl
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Setting up Install Process
Package matching cyrus-sasl-2.1.23-13.el6.x86_64 already installed. Checking for update.
Resolving Dependencies
--> Running transaction check
---> Package cyrus-sasl-md5.x86_64 0:2.1.23-13.el6 will be installed
--> Processing Dependency: cyrus-sasl-lib = 2.1.23-13.el6 for package: cyrus-sasl-md5-2.1.23-13.el6.x86_64
---> Package cyrus-sasl-plain.x86_64 0:2.1.23-13.el6 will be installed
--> Running transaction check
---> Package cyrus-sasl-lib.i686 0:2.1.23-13.el6 will be installed
--> Processing Dependency: libc.so.6(GLIBC_2.3.4) for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1) for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.0) for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.0) for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.4) for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1.3) for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.1) for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libresolv.so.2 for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libc.so.6 for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libdl.so.2 for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libdb-4.7.so for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.3) for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Processing Dependency: libcrypt.so.1 for package: cyrus-sasl-lib-2.1.23-13.el6.i686
--> Running transaction check
---> Package db4.i686 0:4.7.25-16.el6 will be installed
---> Package glibc.i686 0:2.12-1.47.el6_2.12 will be installed
--> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.12-1.47.el6_2.12.i686
--> Processing Dependency: libfreebl3.so for package: glibc-2.12-1.47.el6_2.12.i686
--> Running transaction check
---> Package nss-softokn-freebl.i686 0:3.12.9-11.el6 will be installed
--> Finished Dependency Resolution
Error:  Multilib version problems found. This often means that the root
       cause is something else and multilib version checking is just
       pointing out that there is a problem. Eg.:

         1. You have an upgrade for cyrus-sasl-lib which is missing some
            dependency that another package requires. Yum is trying to
            solve this by installing an older version of cyrus-sasl-lib of the
            different architecture. If you exclude the bad architecture
            yum will tell you what the root cause is (which package
            requires what). You can try redoing the upgrade with
            --exclude cyrus-sasl-lib.otherarch ... this should give you an error
            message showing the root cause of the problem.

         2. You have multiple architectures of cyrus-sasl-lib installed, but
            yum can only see an upgrade for one of those arcitectures.
            If you don't want/need both architectures anymore then you
            can remove the one with the missing update and everything
            will work.

         3. You have duplicate versions of cyrus-sasl-lib installed already.
            You can use "yum check" to get yum show these errors.

       ...you can also use --setopt=protected_multilib=false to remove
       this checking, however this is almost never the correct thing to
       do as something else is very likely to go wrong (often causing
       much more problems).

       Protected multilib versions: cyrus-sasl-lib-2.1.23-13.el6.i686 != cyrus-sasl-lib-2.1.23-13.el6_3.1.x86_64
Error: Protected multilib versions: db4-4.7.25-16.el6.i686 != db4-4.7.25-17.el6.x86_64
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

小弟的作業系統是CentOS 6.4  2.6.32-358.el6.x86_64

4
想請教各位前輩,我用VB.NET加SQL資料庫封裝打包。是不是用戶端一定要安裝SQLServer才能正常執行?  ???

5
.NET程式設計討論區 / VB.Net Reader.GetOrdinal
« 於: 2009-12-30 17:14 »
想請教高手大大,我以 SqlDataReader.GetOrdinal 抓取到資料庫的資料與TextBox比對,明明輸入對的帳號及密碼,但不知為何程式卻判斷我輸入的與資料庫裡的資料不同,想請教我哪裡寫錯了?

Public Class Login
    Dim sConn As SqlConnection
    Dim conn As String = "server=localhost;database=Product;uid=sa;pwd='123'"
    Dim FailCount As Integer = 0

    Private Sub CmdEnter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CmdEnter.Click
        Dim sConn = New SqlConnection(conn)
        sConn.Open()

        Dim SqlLogin As String
        Dim SqlReader As SqlDataReader
        Dim SqlLoginCmd As SqlCommand

        SqlLogin = "Select 帳號,密碼 From Login Where 帳號=帳號"
        SqlLoginCmd = New SqlCommand(SqlLogin, sConn)
        SqlLoginCmd.Parameters.AddWithValue("帳號", TxtID.Text)
        SqlReader = SqlLoginCmd.ExecuteReader()

        If SqlReader.Read() Then
            MsgBox(SqlReader.GetString(SqlReader.GetOrdinal("密碼")))
            If SqlReader.GetString(SqlReader.GetOrdinal("密碼")) = TxtPwd.Text Then
                TxtID.Text = SqlReader.GetString(SqlReader.GetOrdinal("帳號"))
                SqlReader.Close()
            Else
                FailCount += 1
            End If
        Else
            FailCount += 1
        End If

        If FailCount > 0 And FailCount <= 3 Then
            MsgBox("第" & FailCount.ToString & "次輸入錯誤", MsgBoxStyle.Exclamation, "系統訊息。")
            If FailCount >= 3 Then
                MsgBox("輸入錯誤次數已達三次,程式將自行關閉。", MsgBoxStyle.Exclamation, "系統訊息。")
                End
            End If
        End If
    End Sub
End Class

6
Linux 討論版 / postfix無法relay
« 於: 2009-06-18 11:25 »
請教各位學長,小弟設定好postfix後,在本機寄信、收信皆正常,在不同網域收信也正常,但寄信卻出現問題,以下是小弟main.cf的設定以及log,請各位學長指教。

main.cf

queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/lib/postfix
data_directory = /var/lib/postfix
mail_owner = postfix
mydomain = 123.idv.tw
myorigin = $mydomain
unknown_local_recipient_reject_code = 550
mynetworks = 192.168.1.0/24, 127.0.0.0/8
debug_peer_level = 2
debugger_command =
    PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
    ddd $daemon_directory/$process_name $process_id & sleep 5
sendmail_path = /usr/sbin/sendmail
newaliases_path = /usr/bin/newaliases
mailq_path = /usr/bin/mailq
setgid_group = maildrop
html_directory = /usr/share/doc/packages/postfix-doc/html
manpage_directory = /usr/share/man
sample_directory = /usr/share/doc/packages/postfix-doc/samples
readme_directory = /usr/share/doc/packages/postfix-doc/README_FILES
inet_protocols = all
biff = no
mail_spool_directory = /var/mail
canonical_maps = hash:/etc/postfix/canonical
virtual_alias_maps = hash:/etc/postfix/virtual
virtual_alias_domains = hash:/etc/postfix/virtual
relocated_maps = hash:/etc/postfix/relocated
transport_maps = hash:/etc/postfix/transport
sender_canonical_maps = hash:/etc/postfix/sender_canonical
masquerade_exceptions = root
masquerade_classes = envelope_sender, header_sender, header_recipient
myhostname = mail.123.idv.tw
delay_warning_time = 1h
message_strip_characters = \0
program_directory = /usr/lib/postfix
inet_interfaces = all
masquerade_domains =
mydestination = $myhostname, localhost.$mydomain,$mydomain
defer_transports =
mynetworks_style = host
disable_dns_lookups = no
relayhost = [mail.123.idv.tw]
mailbox_command =
mailbox_transport =
strict_8bitmime = no
disable_mime_output_conversion = no
smtpd_sender_restrictions = hash:/etc/postfix/access
smtpd_client_restrictions =
smtpd_helo_required = no
smtpd_helo_restrictions =
strict_rfc821_envelopes = no
smtpd_recipient_restrictions = permit_mynetworks,reject_unauth_destination
smtp_sasl_auth_enable = no
smtpd_sasl_auth_enable = no
smtpd_use_tls = no
smtp_use_tls = no
alias_maps = hash:/etc/aliases
mailbox_size_limit = 0
message_size_limit = 10240000

log

Jun 18 10:17:25 xxx postfix/postfix-script: starting the Postfix mail system
Jun 18 10:17:25 xxx postfix/master[4052]: daemon started -- version 2.2.9, configuration /etc/postfix
Jun 18 11:03:58 xxx popper[4452]: (v4.0.8) Servicing request from "111-111-111-111.dynamic.hinet.net" at 111.111.11.111 [pop_init.c:1239]
Jun 18 11:03:59 xxx popper[4452]: Stats: xxx 0 0 0 0 111-111-111-111.dynamic.hinet.net 111.111.111.11 [pop_updt.c:301]
Jun 18 11:04:02 xxx postfix/smtpd[4453]: connect from 111-111-111-111.dynamic.hinet.net[111.111.111.111]
Jun 18 11:04:02 xxx postfix/smtpd[4453]: NOQUEUE: reject: RCPT from 111-111-111-111.dynamic.hinet.net[111.111.111.111]: 554 <123@gmail.com>: Relay access denied; from=<123@123.idv.tw> to=<123@gmail.com> proto=ESMTP helo=<speed>
Jun 18 11:04:05 xxx postfix/smtpd[4453]: disconnect from 111-111-111-111.dynamic.hinet.net[111.111.111.111]
Jun 18 11:07:25 xxx postfix/anvil[4455]: statistics: max connection rate 1/60s for (smtp:111.111.111.111) at Jun 18 11:04:02
Jun 18 11:07:25 xxx postfix/anvil[4455]: statistics: max connection count 1 for (smtp:111.111.111.111) at Jun 18 11:04:02
Jun 18 11:07:25 xxx postfix/anvil[4455]: statistics: max cache size 1 at Jun 18 11:04:02

7
我想請教各位,最近我在Linux上灌了Real SQL Server,但卻沒辦法使用,不知道是否有人能試灌並告訴小弟他的安裝流程及使用...。

頁: [1]